Export/Import with Physical Standby
Date: Thu, 1 Oct 2009 17:44:27 -0400
Message-ID: <69eafc3f0910011444w30bb4088t46f34a9ffd3bb642_at_mail.gmail.com>
Good Morning,
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 01 2009 - 16:44:27 CDT