Bug 14143011 : ORA-19606: CANNOT COPY OR RESTORE TO SNAPSHOT CONTROL FILE

Bug 14143011 : ORA-19606: CANNOT COPY OR RESTORE TO SNAPSHOT CONTROL FILE

 

[oracle@test]$ tail -f rman_delete.log   Backup Piece       3687   2018:06:08 01:05:13 /home/oracle/nfs/arch_TRANDB_20180608_3789_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of delete command on ORA_MAINT_DISK_1 channel at 06/08/2018 01:05:36 ORA-19606: Cannot copy or restore to snapshot control file

RMAN>

Recovery Manager complete. [oracle@trandb1 nfs]$ cd ..

[oracle@test]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jun 8 11:42:56 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TRANDB (DBID=28069)

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name TRANDB are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1.f'; # default

RMAN> show SNAPSHOT CONTROLFILE NAME;

RMAN configuration parameters for database with db_unique_name TRANDB are:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1.f'; # default

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1_temp.f';

old RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1.f'; new RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1_temp.f'; new RMAN configuration parameters are successfully stored

RMAN>

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1_temp.f';

old RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1_temp.f'; new RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1_temp.f'; new RMAN configuration parameters are successfully stored

[oracle@test dbs ]$ cd /u01/app/oracle/11.2.0/db_1/dbs/
[oracle@test ]$ mv snapcf_trandb1.f snapcf_trandb1.f.bak

RMAN> crosscheck controlfilecopy '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1.f';

allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=4921 instance=trandb1 device type=DISK validation failed for control file copy control file copy file name=/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1.f RECID=4 STAMP=975839353 Crosschecked 1 objects

RMAN> delete expired controlfilecopy '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1.f';

released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=4921 instance=trandb1 device type=DISK List of Control File Copies ===========================

Key     S Completion Time     Ckp SCN    Ckp Time           ------- - ------------------- ---------- ------------------- 4       X 2018:05:11 10:29:13 105054602912 2018:05:11 10:29:13         Name: /u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1.f         Tag: TAG20180511T102912

Do you really want to delete the above objects (enter YES or NO)? yes deleted control file copy control file copy file name=/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1.f RECID=4 STAMP=975839353 Deleted 1 EXPIRED objects

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME clear;

old RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1_temp.f'; RMAN configuration parameters are successfully reset to default value

RMAN> show SNAPSHOT CONTROLFILE NAME;

RMAN configuration parameters for database with db_unique_name TRANDB are: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/11.2.0/db_1/dbs/snapcf_trandb1.f'; # default


-----再次执行RMAN 删除操作;不报错
rman target / nocatalog log /home/oracle/nfs/rman_delete.log append << EOF
  allocate channel for maintenance type disk; 
  crosscheck backupset; 
  crosscheck archivelog all; 
  delete noprompt expired backup; 
  crosscheck copy;
  report obsolete;
  delete noprompt  obsolete;

 

posted @   钱若梨花落  阅读(660)  评论(0编辑  收藏  举报
编辑推荐:
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
点击右上角即可分享
微信分享提示