The Oracle Backup and Recover
文章平均质量分 63
名曰华平
这个作者很懒,什么都没留下…
展开
-
The oracle reference scripts of the backup and the recover
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原创 2013-09-17 06:40:17 · 1478 阅读 · 0 评论 -
Backup incremental level and scripts
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原创 2013-09-18 10:00:35 · 1243 阅读 · 0 评论 -
Try to finish hcheck after restore database
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转载 2013-09-18 10:26:50 · 614 阅读 · 0 评论 -
Delete archivelog in the primary database
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原创 2013-09-18 10:25:33 · 1824 阅读 · 0 评论 -
Enable block change tracking
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';---原创 2013-09-18 10:18:02 · 780 阅读 · 0 评论 -
Check the recover datafile header
ORACLE_RMAN_Check the recover datafile headerset pagesize 20000set linesize 180set pause offset serveroutput onset feedback onset echo onset numformat 999999999999999Spool recovery原创 2013-09-18 09:49:25 · 919 阅读 · 0 评论 -
How to clear the archive log
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原创 2013-09-18 10:29:35 · 1289 阅读 · 0 评论 -
The backup progress monitor
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%'/原创 2013-09-18 10:21:16 · 775 阅读 · 0 评论 -
Recover database until time format
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: ============================原创 2013-09-18 09:51:20 · 6508 阅读 · 0 评论 -
Delete archive log
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原创 2013-09-17 06:45:47 · 929 阅读 · 0 评论 -
Change archive mode
Change archive mode1. The HAorSINGLEmode,Changetothearchivemode (Please freeze the cluster)$ sqlplus '/ as sysdba'SQL> show parameter spfile;NAME TYPE原创 2013-09-17 06:43:50 · 682 阅读 · 0 评论 -
Print the rman output
ORACLE_RMAN_Print the rman output$ rman target /RMAN> spool log to ‘/tmp/rman_output.out’;原创 2013-09-18 10:19:40 · 646 阅读 · 0 评论