ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN validation failed for control file copy

RMAN validation failed for control file copy

原创 Linux操作系统 作者:sendqmail 时间:2013-07-18 09:20:24 0 删除 编辑
在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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: linux date 用法
请登录后发表评论 登录
全部评论

注册时间:2012-10-09

  • 博文量
    25
  • 访问量
    68296