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
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.
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.
Comments