oracle數(shù)據(jù)塊原理深入剖析-資料下載頁
2025-06-25 07:16本頁面
【正文】 RMAN list backup of archivelog s from 11856250905List of Backup Sets===================BS Key Size Device Type Elapsed Time Completion Time 680 265K DISK 00:00:00 16MAR09 BP Key: 681 Status: AVAILABLE Tag: TAG20090316T154731Piece Name: /d02/fullbackup/20090316_arch_28List of Archived Logs in backup set 680Thrd Seq Low SCN Low Time Next SCN Next Time 1 109 11856250805 16MAR09 11856251483 16MAR091 110 11856251483 16MAR09 11856251487 16MAR09查找sequence 110 以后的archivelog是否有備份RMAN list copy of archivelog from sequence 110。List of Archived Log CopiesKey Thrd Seq S Low Time Name 694 1 111 A 16MAR09 /d02/arch/695 1 112 A 16MAR09 /d02/arch/查詢online archive logSQL select sequence,members,archived,status from v$log。SEQUENCE MEMBERS ARC STATUS 113 1 NO CURRENT111 1 YES INACTIVE112 1 YES INACTIVE從以上查詢中可以看出datafile 15有一次最近的全備份，有全備份以來的所有archivelog，online redo log下面開始blockreocver，其實命令很簡單RMAN blockrecover datafile 15 block 18。Starting blockrecover at 16MAR09allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=16 devtype=DISKchannel ORA_DISK_1: restoring block(s)channel ORA_DISK_1: specifying block(s) to restore from backup setrestoring blocks of datafile 00015channel ORA_DISK_1: restored block(s) from backup piece 1piece handle=/d02/fullbackup/20090316_data_24_1 tag=TAG20090316T154352 params=NULLchannel ORA_DISK_1: block restore pletestarting media recoveryarchive log thread 1 sequence 111 is already on disk as file /d02/arch/archive log thread 1 sequence 112 is already on disk as file /d02/arch/channel ORA_DISK_1: starting archive log restore to default destinationchannel ORA_DISK_1: restoring archive logarchive log thread=1 sequence=109channel ORA_DISK_1: restoring archive logarchive log thread=1 sequence=110channel ORA_DISK_1: restored backup piece 1piece handle=/d02/fullbackup/20090316_arch_28 tag=TAG20090316T154731 params=NULLchannel ORA_DISK_1: restore pletemedia recovery pleteFinished blockrecover at 16MAR09再SELECT一下表DPA_HISTORYSQL select * from dpa_history。PRODLINEID BARCODE PA 7 S*33040D8311050149512B 037 S*33040D8311050143512B 037 S*33040D8311050140512B 039 / 9
醫(yī)療健康相關推薦
鄂ICP備17016276號-1