ORACLE STANDBY 修复ORA-19505问题记录

备库down了，经过检查，坏块无法做增量修复，所以需要重新搭建的方式来修复standby库，oracle11g里面有duplicate的方式远程在线修复命令：

run {allocate auxiliary channel c1 device type disk;allocate auxiliary channel c2 device type disk;duplicate target database for standby from active database nofilenamecheck;release channel c1;release channel c2;}

意外的是，修复过程中报错ORA-19505，如下：

[oracle@odbm1 dbs]$ rlwrap rman target sys/pwd_0978@odbm1 auxiliary sys/pwd_0978@odbs1Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 5 19:49:04 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database: orcldb (DBID=3391761643)connected to auxiliary database: orcldb (not mounted)run {allocate auxiliary channel c1 device type disk;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00558: error encountered while parsing input commandsRMAN-01009: syntax error: found "identifier": expecting one of: "device, type"RMAN-01008: the bad identifier was: devicetypeRMAN-01007: at line 2 column 31 file: standard inputallocate auxiliary channel c2 device type disk;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00558: error encountered while parsing input commandsRMAN-01009: syntax error: found "auxiliary": expecting one of: "channel"RMAN-01007: at line 1 column 10 file: standard inputduplicate target database for standby nofilenamecheck dorecover;Starting Duplicate Db at 05-JUN-17release channel c1;release channel c2;using target database control file instead of recovery catalogallocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: SID=4708 device type=DISKcontents of Memory Script:{   set until scn  14430447592;   restore clone standby controlfile;}executing Memory Scriptexecuting command: SET until clauseStarting restore at 05-JUN-17using channel ORA_AUX_DISK_1channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: restoring control filechannel ORA_AUX_DISK_1: reading from backup piece /oracle/backup/data/controlfiles/c-3391761643-20170605-00channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /oracle/backup/data/controlfiles/c-3391761643-20170605-00ORA-19505: failed to identify file "/oracle/backup/data/controlfiles/c-3391761643-20170605-00"ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3failover to previous backupchannel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: restoring control filechannel ORA_AUX_DISK_1: reading from backup piece /oracle/backup/data/controlfiles/c-3391761643-20170604-00channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /oracle/backup/data/controlfiles/c-3391761643-20170604-00ORA-19505: failed to identify file "/oracle/backup/data/controlfiles/c-3391761643-20170604-00"ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3failover to previous backupchannel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: restoring control filechannel ORA_AUX_DISK_1: reading from backup piece /oracle/backup/data/controlfiles/c-3391761643-20170603-00channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /oracle/backup/data/controlfiles/c-3391761643-20170603-00ORA-19505: failed to identify file "/oracle/backup/data/controlfiles/c-3391761643-20170603-00"ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3failover to previous backup

【解决办法】
（1）关闭备库standby

SQL> select open_mode from v$database;OPEN_MODE--------------------MOUNTEDSQL> shutdown immediate;ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> 

（2）在备库上覆盖控制文件，启动到nomount

[oracle@pldb02 dbs]$ cp /home/oracle/ctlfile4.bak /oracle/app/oracle/oradata/orcldb/control01.ctl[oracle@pldb02 dbs]$ rlwrap sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 5 19:57:14 2017Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to an idle instance.SQL> startup nomountORACLE instance started.Total System Global Area 4409401344 bytesFixed Size      2260408 bytesVariable Size        2936013384 bytesDatabase Buffers     1459617792 bytesRedo Buffers           11509760 bytesSQL> 

（3）在master主库上重新拉active数据进行恢复操作

[oracle@odbm1 dbs]$ rlwrap rman target sys/pwd_0978@odbm1 auxiliary sys/pwd_0978@odbs1Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 5 19:57:27 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database: orcldb (DBID=3391761643)connected to auxiliary database: orcldb (not mounted)RMAN> duplicate target database for standby from active database nofilenamecheck;Starting Duplicate Db at 05-JUN-17using target database control file instead of recovery catalogallocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: SID=5649 device type=DISKcontents of Memory Script:{   backup as copy reuse   targetfile  '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcldb' auxiliary format  '/oracle/app/oracle/product/11.2.0.4/dbhome_1/dbs/orapworcldb'   ;}executing Memory ScriptStarting backup at 05-JUN-17allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=1430 device type=DISKFinished backup at 05-JUN-17contents of Memory Script:{   backup as copy current controlfile for standby auxiliary format  '/oracle/app/oracle/oradata/orcldb/control01.ctl';   restore clone controlfile to  '/oracle/app/oracle/fast_recovery_area/orcldb/control02.ctl' from  '/oracle/app/oracle/oradata/orcldb/control01.ctl';}executing Memory ScriptStarting backup at 05-JUN-17using channel ORA_DISK_1channel ORA_DISK_1: starting datafile copycopying standby control fileoutput file name=/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcldb.f tag=TAG20170605T195936 RECID=30 STAMP=945892777channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01Finished backup at 05-JUN-17Starting restore at 05-JUN-17using channel ORA_AUX_DISK_1......

bty，如果执行命令：duplicate target database for standby from active database nofilenamecheck;在线恢复standby库的话，需要特别慎重，因为这会在线锁表的，建议在业务低峰期间做，不然会影响业务使用。