Restore database on another server [message #343172] |
Tue, 26 August 2008 09:19 |
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 #344597 is a reply to message #343172] |
Sat, 30 August 2008 22:45 |
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
|
|
|