We're here to help!

Synchronizing Rename/Move of Primary Datafile to Standby

Follow

Read our docs This article explains how to copy a datafile(s) after changing from Diskgroup A to Diskgroup B on Primary and make the required changes on Standby DB to reflect this change.

Problem Statement

N/A

Applicable Error Code

N/A

Affected Versions

v8 & v9

Affected Platforms

All

Description

How to copy a datafile(s) after changing from Diskgroup A to Diskgroup B on Primary and what to do on the Standby DB to reflect this change.

Steps Performed
 
On Primary:

1) take the tablespace offline 
2) copy file using RMAN
3) switch file using RMAN 
4) recover the file using RMAN 
5) bring the tablespace online

On Standby:

1) stop Dbvisit daemon / crontab schedule on the Standby server
2) copy file using RMAN 
3) switch file using RMAN 
4) Start Daemons / crontab schedule on the Standby server

If you use new diskgroup on the Primary database and use OMF, you should review the OMF parameters on the Standby server:

db_create_file_dest  
db_create_online_log_dest_n

If you're not using OMF, then review your convert parameters on standby database:

db_file_name_convert
log_file_name_convert

Note : If these are not properly set, you could have issues when you try adding the new datafile to the tablespace which you moved.

 

Have more questions? Submit a request

Comments