Error In Standby Database:
22-12-28T12:33:32.063138+06:00
EMOB(7):File #581 added to control file as 'UNNAMED00581' because
EMOB(7):the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
EMOB(7):The file should be manually created to continue.
PR00 (PID:42551): MRP0: Background Media Recovery terminated with error 1274
2022-12-28T12:33:32.097676+06:00
Errors in file /d01/app/oracle/diag/rdbms/cdbdg/cdbdg/trace/cdbdg_pr00_42551.trc:
ORA-01274: cannot add data file that was originally created as '+ADATA/CDBPR/EMOB/undotbs04.dbf'
2022-12-28T12:33:32.098788+06:00
.... (PID:30028): Managed Standby Recovery not using Real Time Apply
2022-12-28T12:33:32.534498+06:00
Recovery interrupted!
2022-12-28T12:33:33.204594+06:00
Solution:
Perform the following steps in Standby Database
SQL> show parameter file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /d01/app/oracle/admin/cdbdg/ad
ump
control_file_record_keep_time integer 7
control_files string +ADATA/CDBDG/CONTROLFILE/curre
nt.261.1120417171, +FRA/CDBDG/
CONTROLFILE/current.260.112041
7171
db_create_file_dest string
db_file_multiblock_read_count integer 128
db_file_name_convert string cdbpr, cdbdg
db_files integer 4000
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flash_cache_file string
db_performance_profile string
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 1800G
db_securefile string PREFERRED
dg_broker_config_file1 string /d01/app/oracle/product/19c/db
_1/dbs/dr1cdbdg.dat
dg_broker_config_file2 string /d01/app/oracle/product/19c/db
_1/dbs/dr2cdbdg.dat
file_mapping boolean FALSE
fileio_network_adapters string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options string asynch
ifile file
log_file_name_convert string cdbpr, cdbdg
max_dump_file_size string unlimited
pdb_file_name_convert string
remote_login_passwordfile string EXCLUSIVE
remote_recovery_file_dest string
session_max_open_files integer 10
spfile string /d01/app/oracle/product/19c/db
_1/dbs/spfilecdbdg.ora
standby_file_management string MANUAL
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_pdb_source_file_dblink string
standby_pdb_source_file_directory string
tracefile_identifier string
SQL> alter system set standby_file_management=AUTO;
System altered.
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB MOUNTED
7 EMOB READ ONLY NO
SQL> alter session set container=EMOB;
Session altered.
SQL> select name from v$datafile where file#=581;
NAME
--------------------------------------------------------------------------------
/d01/app/oracle/product/19c/db_1/dbs/UNNAMED00581
SQL>
SQL> alter database recover managed standby database cancel;
alter database recover managed standby database cancel
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active
-bash-5.1$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 28 12:46:33 2022
Version 19.14.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0
SQL> alter system set standby_file_management=MANUAL;
System altered.
SQL> alter session set container=EMOB;
Session altered.
SQL> alter database create datafile '/d01/app/oracle/product/19c/db_1/dbs/UNNAMED00581' as '+ADATA/cdbdg/emob/undotbs04.dbf';
Database altered.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0
-bash-5.1$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 28 12:47:16 2022
Version 19.14.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0
SQL> alter system set standby_file_management=AUTO;
System altered.
SQL>
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
SQL>
