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
rkl1
Messages: 97
Registered: June 2005
Member
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

Thanks.

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: 10707
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
sonumalhi
Messages: 62
Registered: April 2008
Member
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
Mehtab
Previous Topic: V10 RMAN capabilities
Next Topic: Technical Support
Goto Forum:
  


Current Time: Sun Apr 28 15:00:20 CDT 2024