【正文】 d.SQL mit。Commit plete.SQL select * from name。 ID NAME 1 zxk 2 wxh 3 zyx 4 wyk 5 zy 6 sms 7 wfq7 rows selected.SQL時間：SQL select to_char(sysdate,39。yymmdd hh24:mi:ss39。) from dual。TO_CHAR(SYSDATE,39。120315 14:40:2繼續(xù)插入數(shù)據(jù)：SQL insert into name values(8,39。zl39。)。1 row created.SQL mit。Commit plete.SQL select * from name。 ID NAME 1 zxk 2 wxh 3 zyx 4 wyk 5 zy 6 sms 7 wfq 8 zl8 rows selected.時間：SQL select to_char(sysdate,39。yymmdd hh24:mi:ss39。) from dual。TO_CHAR(SYSDATE,39。120315 14:44:5當(dāng)時的歸檔日志序列號SQL alter system switch logfile。System altered.SQL archive log list。Database log mode Archive ModeAutomatic archival EnabledArchive destination f:\archOldest online log sequence 10Next log sequence to archive 12Current log sequence 12SQL、數(shù)據(jù)庫當(dāng)時的時間SQL select to_char(sysdate,39。yymmdd hh24:mi:ss39。) from dual。TO_CHAR(SYSDATE,39。120315 14:47:0開始第二次增量備份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=7 recid=52 stamp=777994374input archive log thread=1 sequence=8 recid=53 stamp=777995249input archive log thread=1 sequence=9 recid=54 stamp=777995293input archive log thread=1 sequence=10 recid=55 stamp=777996028channel 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=1 recid=46 stamp=777991779input 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=777993819input archive log thread=1 sequence=6 recid=51 stamp=777993865channel 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_1QN5UKHI_1_1 ment=NONEchannel ORA_DISK_1: backup set plete, elapsed time: 00:00:04channel ORA_DISK_2: finished piece 1 at 153月 12piece handle=F:\BAK\DATA\DT2\ORCL_DATAFILE_BAK_1RN5UKHI_1_1 ment=NONEchannel ORA_DISK_2: backup set plete, elapsed time: 00:00:04channel ORA_DISK_1: starting pressed archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=11 recid=56 stamp=777998772input archive log thread=1 sequence=12 recid=57 stamp=777998898channel 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_1SN5UKHM_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_1TN5UKHP_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_1UN5UKHP_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=13 recid=58 stamp=777998940channel 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_1VN5UKIS_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_C12946171272012031504 ment=NONEFinished Control File and SPFILE Autobackup at 153月 12RMAN、備份后的歸檔日志序列號SQL archive log list。Database log mode Archive ModeAutomatic archival EnabledArchive destination f:\archOldest online log sequence 12Next log sequence to archive 14Current log sequence 1第二次增量備份后的時間SQL select to_char(sysdate,39。yymmdd hh24:mi:ss39。) from dual。TO_CHAR(SYSDATE,39。120315 14:51:5查看第二次增量備份RMAN 備份集BS Key Size Device Type Elapsed Time Completion Time 54 9M DISK 00:00:03 153月 12 BP Key: 54 Status: AVAILABLE Compressed: YES Tag: TAG20120315T14481