Backup And Recovery User's Guide-從RMAN開始-維護RMAN備份-cross-checking備份

LuiseDalian發表於2014-02-13
GUIIDEROS

維護RMAN備份

RMAN庫後設資料始終儲存在目標資料庫的控制檔案中。RMAN維護命令管理備份的時候會使用這些後設資料。

cross-checking備份

CROSSCHECK命令會將RMAN備份和映象的邏輯記錄與儲存介質上的檔案進行同步。

如果備份存在於磁碟上，則CROSSCHECK會確定檔案頭是否有效；

如果備份在磁帶上，則RMAN查詢RMAN庫，檢視備份片的名稱和位置。

 

在刪除之前首先對備份和拷貝進行cross-check檢查是很好的做法。

--對所有備份進行檢查

RMAN> crosscheck backup;

 

using channel ORA_DISK_1

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_nnndf_TAG20130706T192144_8xk9n8of_.bkp RECID=1 STAMP=820092104

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_annnn_TAG20130706T202136_8xkf4jno_.bkp RECID=3 STAMP=820095696

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_nnndf_TAG20130706T202137_8xkf4l36_.bkp RECID=4 STAMP=820095698

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_ncsnf_TAG20130706T202137_8xkfd4fb_.bkp RECID=5 STAMP=820095940

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_annnn_TAG20130706T202541_8xkfd5tj_.bkp RECID=6 STAMP=820095941

Crosschecked 5 objects

 

--只對映象拷貝進行檢查

RMAN> crosscheck copy;

 

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=50 device type=DISK

specification does not match any datafile copy in the repository

specification does not match any control file copy in the repository

validation succeeded for archived log

archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB12/archivelog/2013_07_06/o1_mf_1_9_8xkf4h9k_.arc RECID=1 STAMP=820095695

validation succeeded for archived log

archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB12/archivelog/2013_07_06/o1_mf_1_10_8xkfd5gv_.arc RECID=2 STAMP=820095941

Crosschecked 2 objects

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1080779/，如需轉載，請註明出處，否則將追究法律責任。

相關文章