crosscheck backup 和crosscheck backupset发现不了过期的copy的备份文件，
要用 CROSSCHECK CONTROLFILECOPY 语句
[oracle@showdb01 rman]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Jun 21 18:03:30 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ADDB (DBID=3520460317)
RMAN> crosscheck datafilecopy '/oracle/rman/stdbyctl.ctl';
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=981 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 06/21/2011 18:04:24
RMAN-20230: datafile copy not found in the recovery catalog
RMAN-06015: error while looking up datafile copy name: /oracle/rman/stdbyctl.ctl
RMAN> crosscheck controlfilecopy '/oracle/rman/stdbyctl.ctl';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=981 devtype=DISK
validation failed for control file copy
control file copy filename=/oracle/rman/stdbyctl.ctl recid=2 stamp=750706456
Crosschecked 1 objects
RMAN> crosscheck controlfilecopy '/tmp/addb.ctl';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=981 devtype=DISK
validation failed for control file copy
control file copy filename=/tmp/addb.ctl recid=1 stamp=739118943
Crosschecked 1 objects
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 2 days
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 1 30-DEC-10 /tmp/addb.ctl
Control File Copy 2 09-MAY-11 /oracle/rman/stdbyctl.ctl
Do you really want to delete the above objects (enter YES or NO)? yes
deleted control file copy
control file copy filename=/tmp/addb.ctl recid=1 stamp=739118943
deleted control file copy
control file copy filename=/oracle/rman/stdbyctl.ctl recid=2 stamp=750706456
Deleted 2 objects
RMAN>
阅读(3237) | 评论(0) | 转发(0) |
