ORACLE STANDBY 修复ORA-19505问题记录

最新推荐文章于 2024-02-28 14:14:22 发布
最新推荐文章于 2024-02-28 14:14:22 发布
阅读量1.2w 收藏 2
点赞数 2
分类专栏： oracle problem oracle dataguard
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/csdnhsh/article/details/95800185
版权

备库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@odbs1

Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 5 19:49:04 2017

Copyright (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 commands
RMAN-01009: syntax error: found "identifier": expecting one of: "device, type"
RMAN-01008: the bad identifier was: devicetype
RMAN-01007: at line 2 column 31 file: standard input

allocate auxiliary channel c2 device type disk;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "auxiliary": expecting one of: "channel"
RMAN-01007: at line 1 column 10 file: standard input

duplicate target database for standby nofilenamecheck dorecover;

Starting Duplicate Db at 05-JUN-17
release channel c1;
release channel c2;
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=4708 device type=DISK

contents of Memory Script:
{
   set until scn  14430447592;
   restore clone standby controlfile;
}
executing Memory Script

executing command: SET until clause

Starting restore at 05-JUN-17
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /oracle/backup/data/controlfiles/c-3391761643-20170605-00
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /oracle/backup/data/controlfiles/c-3391761643-20170605-00
ORA-19505: failed to identify file "/oracle/backup/data/controlfiles/c-3391761643-20170605-00"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

failover to previous backup

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /oracle/backup/data/controlfiles/c-3391761643-20170604-00
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /oracle/backup/data/controlfiles/c-3391761643-20170604-00
ORA-19505: failed to identify file "/oracle/backup/data/controlfiles/c-3391761643-20170604-00"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

failover to previous backup

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /oracle/backup/data/controlfiles/c-3391761643-20170603-00
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /oracle/backup/data/controlfiles/c-3391761643-20170603-00
ORA-19505: failed to identify file "/oracle/backup/data/controlfiles/c-3391761643-20170603-00"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

failover to previous backup


【解决办法】

（1）关闭备库standby

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> shutdown immediate;
ORA-01109: database not open


Database 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 sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 5 19:57:14 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 4409401344 bytes
Fixed Size		2260408 bytes
Variable Size		 2936013384 bytes
Database Buffers	 1459617792 bytes
Redo Buffers		   11509760 bytes
SQL>

（3）在master主库上重新拉active数据进行恢复操作 
[oracle@odbm1 dbs]$ rlwrap rman target sys/pwd_0978@odbm1 auxiliary sys/pwd_0978@odbs1

Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jun 5 19:57:27 2017

Copyright (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-17
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=5649 device type=DISK

contents 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 Script

Starting backup at 05-JUN-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1430 device type=DISK
Finished backup at 05-JUN-17

contents 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 Script

Starting backup at 05-JUN-17
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcldb.f tag=TAG20170605T195936 RECID=30 STAMP=945892777
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 05-JUN-17

Starting restore at 05-JUN-17
using channel ORA_AUX_DISK_1

......


bty，如果执行命令：duplicate target database for standby from active database nofilenamecheck;在线恢复standby库的话，需要特别慎重，因为这会在线锁表的，建议在业务低峰期间做，不然会影响业务使用。
林震南
关注
专栏目录
ORA-17502 与 ORA-15173 错误解决
lb517290079的专栏
05-21 2669
  用rman恢复spfile时，报错误如下：   RMAN> restore spfile from '+FLASHBACKDATA1/ORAC/AUTOBACKUP/2010_05_16/s_719137976.308.719137979'; Starting restore at 17-MAY-10allocated channel: ORA_DISK_1channel ORA...
oracle ora 00283,【案例】Oracle报错ORA-16433非归档丢失redo无法启动的恢复过程
weixin_33755379的博客
04-04 3542
天萃荷净Oracle研究中心案例分析：运维DBA反映Oracle数据库处理非归档模式，redo文件损坏常规修复无法正常open数据库。本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客本文链接地址: One recover case!今天ML的群中女神和travel在纠结一个恢复的问题，11.2.0.3版本，非归档，...
RMAN RAC 到 单实例 duplicate 自动分配通道 触发 ORA-19505 错误
369540808
07-17 590
用RMAN Duplicate来搭建RAC 到 单实例的Data Guard，结果在duplicate时，触发ORA-19505的错误，如下： ORA-19505:failed to identify file "/u01/app/oracle/11.2.0/db_1/dbs/orapwdave1" 看了一下log，修改了一下通道数量，再次duplicate 成功。 一. 报错的情况 ...
【Oracle】ORA-19505: failed to identify file “/chac/app/oracle/product/11.2.0/db_1/dbs/orapwcoredb2
最新发布
weixin_43346403的博客
02-28 690
1.RAC->单机同步报错。
搭建dg在duplicate过程中报错ORA-17628: Oracle error 19505 returned by remote Oracle server
zongzizz的博客
11-17 1296
搭建dg在duplicate过程中报错ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file "/oradata1/dump/CASCTRL07.DMP EXPDP
zero_plus的专栏
06-27 5746
expdp 出错 $ impdp system/manager directory=DMP content=METADATA_ONLY dumpfile=CASCTRL01.DMP, CASCTRL02.DMP, CASCTRL03.DMP, CASCTRL04.DMP, CASCTRL05.DMP, CASCTRL06.DMP, CASCTRL07.DMP, CASCTRL08.DMP ful
ORA-19505 与 ORA-39126
STEPHEN_ORACLE 'S LIFE
10-26 1227
今天处理数据，遇到两个报错，记录于下 数据库版本：SQL> select * from v$version 2 /BANNER -------------------------------------------------------------------------------- CON_ID ---------- Oracle Database 12c Enterpris
Oracle ADG备库SYSAUX数据文件坏块恢复处理（ORA-00600,ORA-10567,ORA-10564......
Enmotech的博客
10-14 1306
点击上方"蓝字"关注我们，享更多干货！本文阐述了Oracle ADG备库SYSAUX数据文件坏块恢复处理（ORA-00600,ORA-10567,ORA-10564,ORA-01110,O...
oracle实验中的错误,【案例】Oracle报错ORA-01190的产生原因和2种官方解决办法
weixin_29964487的博客
04-09 864
【案例】Oracle报错ORA-01190的产生原因和2种官方解决办法时间:2016-10-21 19:34来源:Oracle研究中心作者:HTZ点击:次天萃荷净运维DBA反映生产环境数据库在宕机后数据文件的SCN不一致并报错ORA-01190.总结出两种方法来修复数据文件头SCN不一致的方法。ORA-01190这个错误比较常见.特别在没有正规DBA运维的环境中比较常见.先看看O...
Dataguard还原测试故障ORA-10458
清风弄影
05-16 1667
主机备份拷贝到备机上进行Rman 还原，完成后用standy controlfile替换。 SQL*Plus: Release 12.2.0.1.0 Production on Fri May 15 11:06:00 2020 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount; ORACLE instance started. Tota.
【DATAGUARD】物理dg配置客户端无缝切换 (八.4)--ora-16652 和 ora-16603错误
07-31
### DATAGUARD 物理DG配置客户端无缝切换——ora-16652与ora-16603错误解析 #### 1. DataGuardBroker的配置 **DataGuardBroker** 是Oracle提供的用于简化Oracle Data Guard管理和配置的工具。通过使用...
oracle 31640,理解IMPDP ORA-19505、ORA-31640错误
weixin_42510271的博客
04-08 243
若在Oracle RAC集群数据库中，则可能Data Pump Worker数据泵工作进程在非发起本Expdp的节点上被分配并工作，除非指定了EXPDP参数CLUSTER=NO。 若启动该Workder进程的节点上相应的data pump目录没有合适的权限，则remote node上的Worker将无法正常工作。 可以利用cluster=no参数来Workaround这个由于RAC引起的ORA-1...
ORA-19505: failed to identify file "/orabak/expdp/TB201411.dmp"
rgb_rgb的博客
12-16 3416
[oracle@erpcrmtest expdp]$ impdp userid=\"/ as sysdba\" DIRECTORY=DATA_EXP parallel=8 DUMPFILE=TB201411.dmp logfile=impdp_TB201411.logImport: Release 11.2.0.3.0 - Production on Tue Dec 16 09:12:40 201
ORA-17628: Oracle error 19505 returned by remote Oracle server
喝醉酒的小白
02-23 5713
备库控制文件路径
ORA-19600&ORA-19601
12-06 888
RMAN> run 2> { 3> ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE'; 4> SEND 'NB_ORA_CLIENT=essdb2,NB_ORA_S...
理解IMPDP ORA-19505、ORA-31640错误
weixin_34417814的博客
10-20 262
若在Oracle RAC集群数据库中，则可能Data Pump Worker数据泵工作进程在非发起本Expdp的节点上被分配并工作，除非指定了EXPDP参数CLUSTER=NO。 若启动该Workder进程的节点上相应的data pump目录没有合适的权限，则remote node上的Worker将无法正常工作。 可以利用cluster=no参数来Workaround这个由于...
RMAN RESTORE fails with RMAN-06023 or ORA-19505 or RMAN-06100
huoshuyinhua的专栏
01-02 844
某个库用nbu做了一个全库备份但不知什么原因，输出日志没了，为了验证备份有效性，使用restore validate database 验证备份有效性。 报错 RMAN> restore validate database; Starting restore at 07-SEP-2007 20:38:21 allocated channel: ORA_DISK_1 chann
ora-01274 standby_file_management=manual
05-15
当 `standby_file_management` 参数设置为 `manual` 时，Oracle数据库会将所有新增的数据文件和重命名的数据文件标记为“只读”并不会将这些文件复制到备库。这意味着，如果您需要将这些文件复制到备库，您需要手动...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值