RMAN validation failed for control file copy

在RMAN中list copy of controlfile时，提示有个控制文件的有限性失败，查询后发现，dataguarg中的primary库记录了stangby的控制文件，而此时该文件并不存在：

RMAN> crosscheck copy of controlfile;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=4 device type=DISK

validation failed for control file copy

control file copy file name=/u01/oracle/standby.ctl RECID=1 STAMP=803608184

Crosschecked 1 objects

RMAN> list copy of controlfile;

List of Control File Copies

===========================

Key     S Completion Time      Ckp SCN    Ckp Time            

------- - -------------------- ---------- --------------------

1       X 02-JAN-2013 00:29:44 993530     02-JAN-2013 00:29:06

        Name: /u01/oracle/standby.ctl

        Tag: TAG20130102T002944

RMAN> delete obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

using channel ORA_DISK_1

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

-------------------- ------ ------------------ --------------------

Control File Copy     1      02-JAN-2013 00:29:44 /u01/oracle/standby.ctl

Backup Set           18     17-JUL-2013 09:38:50

  Backup Piece       18     17-JUL-2013 09:38:50 /u01/backupset/auto_ctl_PRIMARY_c-1641089729-20130717-02

Backup Set           19     18-JUL-2013 09:17:04

  Backup Piece       19     18-JUL-2013 09:17:04 /u01/backupset/full_PRIMARY_0lof1o8e_1_1

Do you really want to delete the above objects (enter YES or NO)? yes

deleted control file copy

control file copy file name=/u01/oracle/standby.ctl RECID=1 STAMP=803608184

deleted backup piece

backup piece handle=/u01/backupset/auto_ctl_PRIMARY_c-1641089729-20130717-02 RECID=18 STAMP=821007529

deleted backup piece

backup piece handle=/u01/backupset/full_PRIMARY_0lof1o8e_1_1 RECID=19 STAMP=821092623

Deleted 3 objects

RMAN> list copy of controlfile;

specification does not match any control file copy in the repository

RMAN> 

os:oracle linux 6.2 

db:oracle 11g r2

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8541492/viewspace-766556/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8541492/viewspace-766556/