Export/Import with Physical Standby

From: David Barbour <david.barbour1_at_gmail.com>
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 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

Original text of this message