ORA-19505: failed to identify file ?/dbs/spfileheal1.ora

时间:2022-11-28 21:58:39
问题描述:搭建rac dg时,执行以下活动复制语句报错ORA-19505: failed to identify file ?/dbs/spfileheal1.ora,如下所示:
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 nofilenamecheck from active database
19> DORECOVER
20> spfile
21> set db_unique_name='healdg'
22> set log_archive_dest_1='location=+fra valid_for=(all_logfiles,all_roles) db_unique_name=healdg'
23> set log_archive_dest_2='service=heal lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=heal'
24> set standby_file_management='AUTO'
25> set fal_client='healdg'
26> set fal_server='heal'
27> set control_files='+DATA/healdg/controlfile/control01.ctl'
28> set log_file_name_convert='+data/heal/tempfile/','+data/healdg/tempfile/','+data/heal/onlinelog/','+data/healdg/onlinelog/','+data/heal/controlfile/','+data/healdg/controlfile/'
29> set db_file_name_convert='+data/heal/datafile/','+data/healdg/datafile/','+data/heal/tempfile/','+data/healdg/tempfile/'
30> set audit_file_dest='/u01/app/oracle/admin/healdg/adump'
31> set db_create_file_dest = '+DATA'
32> set instance_number = '1';
33> }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/27/2022 14:17:39
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on c2 channel at 11/27/2022 14:17:39
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0/db_1/dbs/spfileheal1.ora"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
解决过程:
告警提示无法识别节点1的spfile文件.
在主库节点1生成spfileheal1.ora文件,此后成功执行活动复制.
[oracle@hisdb1 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Nov 27 14:26:30 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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
HEAL

SQL> create pfile from spfile;

File created.

SQL> create spfile='/u01/app/oracle/product/11.2.0/db_1/dbs/spfileheal1.ora' from pfile;

File created.