Tuesday, December 17, 2013

Manual cloning database from one server to another?

First of all you will have to take the full backup of the primary database by using RMAN and transfer the same backup on new server then follow the bellow steps. 

Following are the steps to restore and recover the database on different server. 
1) Create the init. ora file. 
2) startup nomount. 
3) Connect to the RMAN Prompt. 
4) Restore the controlfile. 
5) catalog the backup. 
6) startup mount 
7) Restore database. 
8) Recover database. 
9) alter database open resetlogs. 
10) Select name,open_mode from v$database; 

Do let me know if you need any other information. 

Or you can use the "duplicate command" for clonning the database on different server.

No comments:

Post a Comment