Move Datafiles on standby server without moving Primary
Include below parameter in standby parameter file
DB_FILE_NAME_CONVERT = '/primary_location/xyz.dbf','/standby_location/xyz.dbf'
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel;
shut immediate
startup nomount pfile=initSCSL.ora
alter database mount standby database ;
alter system set standby_file_management='MANUAL' SCOPE=MEMORY ;
! cp /primary_location/xyz.dbf' /standby_location/xyz.dbf
alter database rename file '/primary_location/xyz.dbf' to '/standby_location/xyz.dbf';
alter system set standby_file_management='AUTO' SCOPE=MEMORY ;
alter database recover managed standby database parallel 4 disconnect from session;
OR
-concept not tested--do a test on non-produciton-
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel;
mv /primary_location/xyz.dbf /standby_location/xyz.dbf
create a soft link ln -s /standby_location/xyz.dbf /primary_location/xyz.dbf
startup nomount pfile=initSCSL.ora
alter database mount standby database ;
alter database recover managed standby database parallel 4 disconnect from session;
Regards
Manoj
No comments:
Post a Comment