STEP1:- Check the name of the datafile on both PRIMARY & STANDBY database
select name from v$datafile; ---- This command should show the datafile name as UNNAMEDxxxxx
STEP2:- ON STANDBY DATABASE
alter system set standby_file_management='manual' SCOPE=BOTH;
STEP3:- Rename the datafile
alter database create datafile '/u01/app/oracle/product/11.2/db_1/dbs/UNNAMED00215' as '/u03/oracle/oradata/QPPRDRD/datafiles/sysaux02.dbf';
STEP4:- On the standby database
alter system set standby_file_management='auto';
shutdown and then reopen the standby database in MOUNT mode
STEP5:- On the standby database
alter database recover managed standby database disconnect from session;
No comments:
Post a Comment