INTRODUCTION :
This post describes renaming a datafile in standby.
NOTE :
In Primary database renaming a Datafile will not be reflected in Standby database even the STANDBY_FILE_MANAGEMENT=auto , So we need to rename the Datafile in Standby .
STEPS TO RENAME A DATAFILE :
STEP 1 : Stop the MRP process
alter database recover managed standby database cancel ;
STEP 2: Set the STANDBY_FILE__MANAGEMENT=MANUAL
alter system set STANDBY_FILE_MANAGEMENT=manual ;
STEP 3 : Make the tablespace offline.
alter tablespace users offline
STEP 4 : Move the datafile
mv /u01/app/oracle/oradata/testdb/users.dbf /u02/app/oracle/oradata/testdb/doyen.dbf
STEP 5 : Rename the datafile in Controlfile .
alter database create datafile ‘/u01/app/oracle/oradata/testdb/users.dbf’ as ‘/u02/app/oracle/oradata/testdb/doyen.dbf’;
STEP 6 : Make the tablespace online.
alter tablespace users online.
STEP 7 : Set the STANDBY_FILE__MANAGEMENT=AUTO
alter system set STANDBY_FILE_MANAGEMENT=auto ;
STEP 8 : Start the MRP process
alter database recover managed standby database using current logfile disconnect from session ;
STEP 9 : Check whether MRP process started or not
ps -ef|grep mrp
