首页 > 数据库 >ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl2"

ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl2"

时间:2022-10-06 21:01:12浏览次数:47  
标签:product 19505 auxiliary app allocate device disk type channel

系统:centos 7.9 64位
数据库:oracle 11.2.0.4 64位
环境:rac(双节点)+dg
问题描述:搭建dg时报错ORA-19505,如下所示.
[oracle@hisdbdg ~]$ rman target sys/********@orcl auxiliary sys/********@orcldg

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 6 20:32:57 2022

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

connected to target database: ORCL (DBID=1645154714)
connected to auxiliary database: ORCL (not mounted)
……
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/06/2022 20:33:38
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on c1 channel at 10/06/2022 20:33:38
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl2"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

说明:在给rac搭建dg时,ora-19505的告警在所难免会遇到.
解决过程:
RMAN> exit
[oracle@hisdbdg ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 6 20:34:25 2022

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1586708480 bytes
Fixed Size 2253624 bytes
Variable Size 989859016 bytes
Database Buffers 587202560 bytes
Redo Buffers 7393280 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
注意:此处rman只需连接rac其中一个节点进行duplicate即可.
[oracle@hisdbdg ~]$ rman target sys/********@192.168.133.210:1521/orcl auxiliary sys/********@orcldg

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 6 20:35:22 2022

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

connected to target database: ORCL (DBID=1645154714)
connected to auxiliary database: ORCL (not mounted)

RMAN> run{
2> allocate channel c1 device type disk;
3> allocate channel c2 device type disk;
4> allocate channel c3 device type disk;
5> allocate channel c4 device type disk;
6> allocate channel c5 device type disk;
7> allocate channel c6 device type disk;
8> allocate channel c7 device type disk;
9> allocate channel c8 device type disk;
10> allocate auxiliary channel a1 device type disk;
11> allocate auxiliary channel a2 device type disk;
12> allocate auxiliary channel a3 device type disk;
13> allocate auxiliary channel a4 device type disk;
14> allocate auxiliary channel a5 device type disk;
15> allocate auxiliary channel a6 device type disk;
16> allocate auxiliary channel a7 device type disk;
17> allocate auxiliary channel a8 device type disk;
18> duplicate target database for standby from active database;
19> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=202 instance=orcl1 device type=DISK

allocated channel: c2
channel c2: SID=16 instance=orcl1 device type=DISK
……
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1117398965 file name=/u01/app/oracle/oradata/system.259.1117373983
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=1117398965 file name=/u01/app/oracle/oradata/sysaux.260.1117373985
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=1117398965 file name=/u01/app/oracle/oradata/undotbs1.261.1117373985
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=1117398965 file name=/u01/app/oracle/oradata/undotbs2.263.1117373991
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=1117398965 file name=/u01/app/oracle/oradata/users.264.1117373991
Finished Duplicate Db at 06-OCT-22
released channel: c1
released channel: c2
released channel: c3
released channel: c4
released channel: c5
released channel: c6
released channel: c7
released channel: c8
released channel: a1
released channel: a2
released channel: a3
released channel: a4
released channel: a5
released channel: a6
released channel: a7
released channel: a8

结论:成功执行duplicate,无异常发生.

标签:product,19505,auxiliary,app,allocate,device,disk,type,channel
From: https://blog.51cto.com/u_12991611/5734019

相关文章