53 1 32 A 29-OCT-10 D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00032.001
RMAN> BACKUP ARCHIVELOG ALL DELETE all INPUT;
Starting backup at 29-OCT-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=32 recid=53 stamp=733658496
input archive log thread=1 sequence=33 recid=54 stamp=733658533
channel ORA_DISK_1: starting piece 1 at 29-OCT-10
channel ORA_DISK_1: finished piece 1 at 29-OCT-10
piece handle=D:\ORACLE\ORA92SERV\DATABASE\0MLRLFD5_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00032.001 recid=53 stamp=733658496
archive log filename=D:\ARCHIVE\ARCHIVE\ARC00033.001 recid=54 stamp=733658533
archive log filename=D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00033.001 recid=55 stamp=733658533
Finished backup at 29-OCT-10
实验2:
修改D:\ARCHIVE\ARCHIVE路径,切换日志,则路径1缺少44,45号日志(41为上次使用backup archivelog all delete input遗留下来的)。可以看出清单上就没有路径1的44,45记录,备份也能正常
RMAN> list archivelog all;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
71 1 41 A 29-OCT-10 D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00041.001
75 1 44 A 29-OCT-10 D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00044.001
76 1 45 A 29-OCT-10 D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00045.001
77 1 46 A 29-OCT-10 D:\ARCHIVE\ARCHIVE\ARC00046.001
78 1 46 A 29-OCT-10 D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00046.001
RMAN> BACKUP ARCHIVELOG ALL DELETE all INPUT;
Starting backup at 29-OCT-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=41 recid=71 stamp=733659138
input archive log thread=1 sequence=44 recid=75 stamp=733659256
input archive log thread=1 sequence=45 recid=76 stamp=733659298
input archive log thread=1 sequence=46 recid=77 stamp=733659331
input archive log thread=1 sequence=47 recid=79 stamp=733659345
channel ORA_DISK_1: starting piece 1 at 29-OCT-10
channel ORA_DISK_1: finished piece 1 at 29-OCT-10
piece handle=D:\ORACLE\ORA92SERV\DATABASE\0QLRLG6H_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00041.001 recid=71 stamp=733659138
archive log filename=D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00044.001 recid=75 stamp=733659256
archive log filename=D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00045.001 recid=76 stamp=733659298
archive log filename=D:\ARCHIVE\ARCHIVE\ARC00046.001 recid=77 stamp=733659331
archive log filename=D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00046.001 recid=78 stamp=733659331
archive log filename=D:\ARCHIVE\ARCHIVE\ARC00047.001 recid=79 stamp=733659345
archive log filename=D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00047.001 recid=80 stamp=733659345
Finished backup at 29-OCT-10
进一步
[NextPage]
SQL> alter system switch logfile;
System altered.
RMAN> list archivelog all;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
81 1 48 A 29-OCT-10 D:\ARCHIVE\ARCHIVE\ARC00048.001
82 1 48 A 29-OCT-10 D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00048.001
手工删除路径1的48号
del D:\ARCHIVE\ARCHIVE\ARC00048.001
再次执行备份
RMAN> BACKUP ARCHIVELOG ALL DELETE all INPUT;
Starting backup at 29-OCT-10
current log archived
using channel ORA_DISK_1
archived log D:\ARCHIVE\ARCHIVE\ARC00048.001 not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 48
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=48 recid=82 stamp=733660133
input archive log thread=1 sequence=49 recid=83 stamp=733660217
channel ORA_DISK_1: starting piece 1 at 29-OCT-10
channel ORA_DISK_1: finished piece 1 at 29-OCT-10
piece handle=D:\ORACLE\ORA92SERV\DATABASE\0RLRLH1P_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00048.001 recid=82 stamp=733660133
archive log filename=D:\ARCHIVE\ARCHIVE\ARC00049.001 recid=83 stamp=733660217
archive log filename=D:\ORACLE\ORADATA\FOX\ARCHIVE\ARC00049.001 recid=84 stamp=733660217
Finished backup at 29-OCT-10
| 广告合作:400-664-0084 全国热线:400-664-0084 Copyright 2010 - 2017 www.my8848.com 珠峰网 粤ICP备15066211号 珠峰网 版权所有 All Rights Reserved
|