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

Recovering a database on another machine

I want to recover a database on a different machine from where I took the backup. What are the requirements in the target machine for recovering this database and what are the steps for recovering the database in the target machine?

I have backed up an Oracle 8.1.7 database (tablespaces and archive log files) using Veritas Backup Exec Oracleagent in Windows 2000 Server. I would like to recover this database in another machine (assuming the configuration of the target machine is same as the source). What are the requirements in the target machine for recovering this database and what are the steps for recovering the database in the target machine?

Your target machine must be the same platform as the source machine. You won't be able to take a backup of a database running on Unix and move that to Windows, for instance. The next thing to do to make your life easier is to use the exact directory structure on both servers for your Oracle datafiles. Restore your backup to the target server (don't forget control files, your parameter file, and your password file). Then, use ORADIM to create the database service. This is the basics and everything should come up just fine.

For More Information

Dig Deeper on Oracle database design and architecture

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