【文章內(nèi)容簡(jiǎn)介】 1 0 Incr 632251 153月 12 E:\ORACLE\PRODUCT\\ORADATA\ORCL\SYSTE 4 0 Incr 632251 153月 12 E:\ORACLE\PRODUCT\\ORADATA\ORCL\USERS 6 0 Incr 632251 153月 12 F:\ORADATA2\BS Key Size Device Type Elapsed Time Completion Time 45 7K DISK 00:00:01 153月 12 BP Key: 45 Status: AVAILABLE Compressed: YES Tag: TAG20120315T132425 Piece Name: F:\BAK\DATA\DT1\ORCL_DATAFILE_BAK_1HN5UFK9_1_1 List of Archived Logs in backup set 45 Thrd Seq Low SCN Low Time Next SCN Next Time 1 6 632247 153月 12 632273 153月 12BS Key Type LV Size Device Type Elapsed Time Completion Time 46 Full 2M DISK 00:00:01 153月 12 BP Key: 46 Status: AVAILABLE Compressed: NO Tag: TAG20120315T132427 Piece Name: F:\BAK\CTLPF\ORCL_CTF_BAK_C12946171272012031502 Controlfile Included: Ckp SCN: 632278 Ckp time: 153月 12 SPFILE Included: Modification time: 143月 12可以看到當(dāng)時(shí)的備份集到達(dá)了46，下一個(gè)SCN 為632273控制文件所對(duì)應(yīng)的塊為F:\BAK\CTLPF\ORCL_CTF_BAK_C1294617127201203150測(cè)試信息匯總 從插入數(shù)據(jù)到第一次全備份結(jié)束時(shí)產(chǎn)生的歸檔日志為26，即在恢復(fù)這一段時(shí)間用到的歸檔日志為26當(dāng)時(shí)的SCN 為632272（從最后一個(gè)備份的歸檔日志得知）時(shí)間段為：120315 12:52:23 至 120315 13:25:19控制文件的對(duì)應(yīng)的備份片為：F:\BAK\CTLPF\ORCL_CTF_BAK_C1294617127201203150第一次增量備份、數(shù)據(jù)記錄SQL insert into name values(2,39。wxh39。)。1 row created.SQL insert into name values(3,39。zyx39。)。1 row created.SQL mit。Commit plete.SQL select * from name。 ID NAME 1 zxk 2 wxh 3 zyx、當(dāng)時(shí)的歸檔日志序列號(hào)SQL alter system switch logfile。System altered.SQL archive log list。Database log mode Archive ModeAutomatic archival EnabledArchive destination f:\archOldest online log sequence 6Next log sequence to archive 8Current log sequence 數(shù)據(jù)庫(kù)當(dāng)時(shí)的時(shí)間SQL select to_char(sysdate,39。yymmdd hh24:mi:ss39。) from dual。TO_CHAR(SYSDATE,39。120315 13:33:5開始第一次增量備份RMAN backup incremental level 1 database plus archivelog。Starting backup at 153月 12current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2channel ORA_DISK_1: starting pressed archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=1 recid=46 stamp=777991779channel ORA_DISK_1: starting piece 1 at 153月 12channel ORA_DISK_2: starting pressed archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=1 sequence=2 recid=47 stamp=777993230input archive log thread=1 sequence=3 recid=48 stamp=777993432input archive log thread=1 sequence=4 recid=49 stamp=777993480input archive log thread=1 sequence=5 recid=50 stamp=777993819channel ORA_DISK_2: starting piece 1 at 153月 12channel ORA_DISK_1: finished piece 1 at 153月 12piece handle=F:\BAK\DATA\DT1\ORCL_DATAFILE_BAK_1JN5UGVH_1_1 ment=NONEchannel ORA_DISK_1: backup set plete, elapsed time: 00:00:06channel ORA_DISK_2: finished piece 1 at 153月 12piece handle=F:\BAK\DATA\DT2\ORCL_DATAFILE_BAK_1KN5UGVH_1_1 ment=NONEchannel ORA_DISK_2: backup set plete, elapsed time: 00:00:06channel ORA_DISK_1: starting pressed archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=6 recid=51 stamp=777993865input archive log thread=1 sequence=7 recid=52 stamp=777994374input archive log thread=1 sequence=8 recid=53 stamp=777995249channel ORA_DISK_1: starting piece 1 at 153月 12channel ORA_DISK_1: finished piece 1 at 153月 12piece handle=F:\BAK\DATA\DT1\ORCL_DATAFILE_BAK_1LN5UGVN_1_1 ment=NONEchannel ORA_DISK_1: backup set plete, elapsed time: 00:00:02Finished backup at 153月 12Starting backup at 153月 12using channel ORA_DISK_1using channel ORA_DISK_2channel ORA_DISK_1: starting pressed incremental level 1 datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=E:\ORACLE\PRODUCT\\ORADATA\ORCL\input datafile fno=00006 name=F:\ORADATA2\input datafile fno=00004 name=E:\ORACLE\PRODUCT\\ORADATA\ORCL\channel ORA_DISK_1: starting piece 1 at 153月 12channel ORA_DISK_2: starting pressed incremental level 1 datafile backupsetchannel ORA_DISK_2: specifying datafile(s) in backupsetinput datafile fno=00003 name=E:\ORACLE\PRODUCT\\ORADATA\ORCL\input datafile fno=00005 name=E:\ORACLE\PRODUCT\\ORADATA\ORCL\Finput datafile fno=00002 name=E:\ORACLE\PRODUCT\\ORADATA\ORCL\Fchannel ORA_DISK_2: starting piece 1 at 153月 12channel ORA_DISK_1: finished piece 1 at 153月 12piece handle=F:\BAK\DATA\DT1\ORCL_DATAFILE_BAK_1MN5UGVQ_1_1 ment=NONEchannel ORA_DISK_1: backup set plete, elapsed time: 00:00:35channel ORA_DISK_2: finished piece 1 at 153月 12piece handle=F:\BAK\DATA\DT2\ORCL_DATAFILE_BAK_1NN5UGVQ_1_1 ment=NONEchannel ORA_DISK_2: backup set plete, elapsed time: 00:00:35Finished backup at 153月 12Starting backup at 153月 12current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2channel ORA_DISK_1: starting pressed archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=9 recid=54 stamp=777995293channel ORA_DISK_1: starting piece 1 at 153月 12channel ORA_DISK_1: finished piece 1 at 153月 12piece handle=F:\BAK\DATA\DT1\ORCL_DATAFILE_BAK_1ON5UH0T_1_1 ment=NONEchannel ORA_DISK_1: backup set plete, elapsed time: 00:00:02Finished backup at 153月 12Starting Control File and SPFILE Autobackup at 153月 12piece handle=F:\BAK\CTLPF\ORCL_CTF_BAK_C12946171272012031503 ment=NONEFinished Control File and SPFIL