【正文】 1 2 630832 153月 12 631802 153月 12 1 3 631802 153月 12 632048 153月 12 1 4 632048 153月 12 632071 153月 12 1 5 632071 153月 12 632247 153月 12BS Key Size Device Type Elapsed Time Completion Time 49 270K DISK 00:00:01 153月 12 BP Key: 49 Status: AVAILABLE Compressed: YES Tag: TAG20120315T134729 Piece Name: F:\BAK\DATA\DT1\ORCL_DATAFILE_BAK_1LN5UGVN_1_1 List of Archived Logs in backup set 49 Thrd Seq Low SCN Low Time Next SCN Next Time 1 6 632247 153月 12 632273 153月 12 1 7 632273 153月 12 632557 153月 12 1 8 632557 153月 12 632972 153月 12BS Key Type LV Size Device Type Elapsed Time Completion Time 50 Incr 1 192K DISK 00:00:31 153月 12 BP Key: 50 Status: AVAILABLE Compressed: YES Tag: TAG20120315T134737 Piece Name: F:\BAK\DATA\DT1\ORCL_DATAFILE_BAK_1MN5UGVQ_1_1 List of Datafiles in backup set 50 File LV Type Ckp SCN Ckp Time Name 1 1 Incr 632978 153月 12 E:\ORACLE\PRODUCT\\ORADATA\ORCL\SYSTE 4 1 Incr 632978 153月 12 E:\ORACLE\PRODUCT\\ORADATA\ORCL\USERS 6 1 Incr 632978 153月 12 F:\ORADATA2\BS Key Type LV Size Device Type Elapsed Time Completion Time 51 Incr 1 480K DISK 00:00:31 153月 12 BP Key: 51 Status: AVAILABLE Compressed: YES Tag: TAG20120315T134737 Piece Name: F:\BAK\DATA\DT2\ORCL_DATAFILE_BAK_1NN5UGVQ_1_1 List of Datafiles in backup set 51 File LV Type Ckp SCN Ckp Time Name 2 1 Incr 632979 153月 12 E:\ORACLE\PRODUCT\\ORADATA\ORCL\UNDOT 3 1 Incr 632979 153月 12 E:\ORACLE\PRODUCT\\ORADATA\ORCL\SYSAU 5 1 Incr 632979 153月 12 E:\ORACLE\PRODUCT\\ORADATA\ORCL\EXAMPBS Key Size Device Type Elapsed Time Completion Time 52 5K DISK 00:00:01 153月 12 BP Key: 52 Status: AVAILABLE Compressed: YES Tag: TAG20120315T134813 Piece Name: F:\BAK\DATA\DT1\ORCL_DATAFILE_BAK_1ON5UH0T_1_1 List of Archived Logs in backup set 52 Thrd Seq Low SCN Low Time Next SCN Next Time 1 9 632972 153月 12 632997 153月 12BS Key Type LV Size Device Type Elapsed Time Completion Time 53 Full 2M DISK 00:00:01 153月 12 BP Key: 53 Status: AVAILABLE Compressed: NO Tag: TAG20120315T134815 Piece Name: F:\BAK\CTLPF\ORCL_CTF_BAK_C12946171272012031503 Controlfile Included: Ckp SCN: 633002 Ckp time: 153月 12 SPFILE Included: Modification time: 143月 12可以看到此次備份的下一個SCN為：632997 控制文件所對應(yīng)的塊為：F:\BAK\CTLPF\ORCL_CTF_BAK_C1294617127201203150測試信息匯總 從插入數(shù)據(jù)到第一次增量備份結(jié)束時產(chǎn)生的歸檔日志為79，即在恢復(fù)這一段時間用到的歸檔日志為79當(dāng)時的SCN 為632996（從最后一個備份的歸檔日志得知）時間段為：120315 13:33:54 至 120315 14:02:39控制文件的片為：F:\BAK\CTLPF\ORCL_CTF_BAK_C1294617127201203150第二次增量備份、數(shù)據(jù)記錄、先插入兩條數(shù)據(jù)SQL insert into name values(4,39。Database log mode Archive ModeAutomatic archival EnabledArchive destination f:\archOldest online log sequence 9Next log sequence to archive 11Current log sequence 1第一次增量備份后的時間SQL select to_char(sysdate,39。) from dual。 ID NAME 1 zxk 2 wxh 3 zyx、當(dāng)時的歸檔日志序列號SQL alter system switch logfile。zyx39。120315 13:25:1查看RMAN 備份集BS Key Size Device Type Elapsed Time Completion Time 40 2M DISK 00:00:02 153月 12 BP Key: 40 Status: AVAILABLE Compressed: YES Tag: TAG20120315T132339 Piece Name: F:\BAK\DATA\DT2\ORCL_DATAFILE_BAK_1DN5UFIR_1_1 List of Archived Logs in backup set 40 Thrd Seq Low SCN Low Time Next SCN Next Time 1 2 630832 153月 12 631802 153月 12 1 3 631802 153月 12 632048 153月 12 1 4 632048 153月 12 632071 153月 12BS Key Size Device Type Elapsed Time Completion Time 41 3M DISK 00:00:02 153月 12 BP Key: 41 Status: AVAILABLE Compressed: YES Tag: TAG20120315T132339 Piece Name: F:\BAK\DATA\DT1\ORCL_DATAFILE_BAK_1CN5UFIR_1_1 List of Archived Logs in backup set 41 Thrd Seq Low SCN Low Time Next SCN Next Time 1 1 627378 153月 12 630832 153月 12BS Key Size Device Type Elapsed Time Completion Time 42 67K DISK 00:00:00 153月 12 BP Key: 42 Status: AVAILABLE Compressed: YES Tag: TAG20120315T132339 Piece Name: F:\BAK\DATA\DT1\ORCL_DATAFILE_BAK_1EN5UFIT_1_1 List of Archived Logs in backup set 42 Thrd Seq Low SCN Low Time Next SCN Next Time 1 5 632071 153月 12 632247 153月 12BS Key Type LV S