Q
Problem solve Get help with specific problems with your technologies, process and projects.

Duplicating a very active database

I have a very active database around 200 GB and I want to duplicate it. The same apps and db jobs must be running on this db. Can you tell me what will be the best way to duplicate such a database?

I have a database around 200 GB and I want to duplicate this database, which is very active. The same apps and db jobs must be running on this db.

My backup policy was to take three tablespace backups on each Monday, Wednesday and Thursday, as I have only nine tablespaces. This way I took the hot backup of the database in a week.

I don't want to open my new database with reset log so that I can use the control file of the primary database for recovery if required.

Can you tell me what will be the best way to duplicate such a database?

I'd use RMAN to duplicate my database. You point RMAN to your source database and the destination database (called the Auxilliary in RMAN terminology) and then tell RMAN to duplicate the database with the DUPLICATE command. Please refer to your version-specific RMAN documentation for the exact procedure.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close