Export/Import with Physical Standby
Date: Thu, 1 Oct 2009 17:44:27 -0400
I've got a requirement to move about 300GB of table and index data from the current tablespaces into new tablespaces. There is a physical standby in place. The standby is located in another city. The database is 7TB in size. I am running Oracle 10.2.0.4 on AIX 6.1.
The standby is currently mounted with the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO. We are not using ASM.
I'd like to get a sanity check on the plan I've put together.
Stop the application
Create the new tablespaces and datafiles --> this should propagate to the standby
Get table and index DDL using dbms_metadata.get_ddl Export tables using datapump
Drop tables and indexes --> this should propagate to the standby Edit DDL to recreate tables and indexes in new tablespaces Run create scripts --> this should propagate to the standby Import tables using datapump --> this should propagate to the standby
All tables will remain in the same schema.
Comments appreciated.Received on Thu Oct 01 2009 - 16:44:27 CDT