重庆思庄Oracle、Redhat认证学习论坛

标题: 搭建dg时报错ORA-19505: failed to identify file "/u01/app/oracle/product [打印本页]

作者: jiawang 时间: 2024-7-3 21:52
标题: 搭建dg时报错ORA-19505: failed to identify file "/u01/app/oracle/product
系统：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

报错原因：
DG同步时TNS,指定一个节点就可以了，我这里TNS连接串里面配置的SCANIP,所以会报这个错误。

解决过程：
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，无异常发生.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)