Home » RDBMS Server » Backup & Recovery » Restore database on another server (Both Window2003 and Linux)
Restore database on another server [message #343172] Tue, 26 August 2008 09:19 Go to next message
Messages: 97
Registered: June 2005
Dear All, We will soon go for some DR type testing and need your help and advices for the situation as below:

1. We have 2 database running on Window2003 and Linux of 10G version. Since both the database are relatively small size, we take a full backup (RMAN) every night. database are running under archive mode. We save a copy of the backup sets in another server.

2.We like to know if the database servers crashed and gone: what the steps we need to take to restore from the backups: The condition may be: if we have the backup sets, can we build an identical database in another servers by restoring it ?

My assumptions are:

1. Build the identical database
2.Then engage the rman backup sets to restore
3. open the database with no restore logs option


Re: Restore database on another server [message #343197 is a reply to message #343172] Tue, 26 August 2008 10:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>1. Build the identical database
From where?

Steps 1 and 2 will be done by RMAN.
Just refer RMAN docs the chapter which talks about restoring in a different node.
Re: Restore database on another server [message #344597 is a reply to message #343172] Sat, 30 August 2008 22:45 Go to previous message
Messages: 62
Registered: April 2008
You need to install same OS and same exact version of oracle binaries(even patch set should be same) on the server and restore the database with rman.
For restoring database using rman you can go through docs.
thank you
Previous Topic: RMAN Implementation.
Next Topic: RMAN BACK UP
Goto Forum:

Current Time: Wed Aug 23 05:12:46 CDT 2017

Total time taken to generate the page: 0.04642 seconds