Wednesday, July 23, 2014

STANDBY DATAFILE PROBLEM---- and ERRORS ORA-01111,1110,1157


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