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

Creating a database clone from a cold backup

I have a cold backup of my Oracle 9iR2 Patchset 4 database running on a Windows 2000 server. I have to create a database clone from this backup onto another Windows 2000 server box. Can you please provide a step-by- step procedure to do so?

I have a cold backup of my Oracle 9iR2 Patchset 4 database running on a Windows 2000 server. I have to create a database clone from this backup onto another Windows 2000 server box. Can you please provide a step-by- step procedure to do so?
  1. Install Oracle on the new server with the same patchset level.
  2. Precreate a database on this new server with the same ORACLE_SID as the source database. Use the same directory structure if possible.
  3. Shut down your database.
  4. Restore your cold backup to the new server, overwriting the control files and datafiles.
  5. You should be able to start your database.

If the same directory structure is not possible, you'll have to modify the parameter file to point to the correct control file location after step 4. Before you can start the database, you'll also need to issue the ALTER DATABASE RENAME FILE commands for each datafile and online redo log file not in the correct location.

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