Enhancing Your Oracle Capability

ORACLE_BACKUP_The oracle reference scripts of the backup and the recoverThere are two familiar ways for thedatabase backup: exp/imp and rman. Expdp/impdp only Applies to above the oracle10g. Now the

1. Full backuprun {allocate channel 'dev1' type disk   ;allocate channel 'dev2' type disk ;allocate channel 'dev3' type disk ;backup full  tag 'dbfull' format '/o9i/testrman/full%u_%p_%c' da

ORACLE_RMAN_Try to finish hcheck after restore databaseIf restore the database, need to check the databasedictionary by hcheck. Generally speaking, don’t to do this, it will takea lot of resources

ORACLE_RMAN_delete archivelog in the primary databaseAbout RMAN-08137, please refer to :1.  Case 1Check that the standby database is uptodate - if not, restartmanaged recovery and resolve the ga

RACLE_RMAN_Enable block change tracking--- Enable block change trace (Don’t reboot thedatabase.)alter databaseenable block change tracking using file'/oracle/changetrace/rman_change_track.f';---

ORACLE_RMAN_Check the recover datafile headerset pagesize 20000set linesize 180set pause offset serveroutput onset feedback onset echo onset numformat 999999999999999Spool recovery

Some time, the archive is full, we have to clear the archive log and then make the database normal.The following way, maybe is useful to you.1. For NO-DATAGUARD:--- 1. Check the archiv

ORACLE_RMAN_The backup progress monitor--- 1. RMAN $  sqlplus/ as sysdbaSELECT sid,spid, client_info  FROM v$processp, v$session s  WHERE p.addr =s.paddr  AND client_infoLIKE '%rman%'/

ORACLE_RMAN_until time formatProble Desc:RMAN> recover database until time '02/28/2011 16:06:23';Starting recover at 28-FEB-11using channel ORA_DISK_1RMAN-00571: ============================

ORACLE_RMAN_Delete archive log1. Remove thearchive log directly1). Remove thearchive log;2). Delete therecord of the database# su - oracle$ rman target /RMAN> listarchivelog all;RMAN>cro

Change archive mode1. The HAorSINGLEmode,Changetothearchivemode (Please freeze the cluster)$ sqlplus '/ as sysdba'SQL> show parameter spfile;NAME                                TYPE 

ORACLE_RMAN_Print the rman output$ rman target /RMAN> spool log to ‘/tmp/rman_output.out’;