Wednesday, May 4, 2016

RMAN Backup Restoration on Fresh server/New Server

RMAN Backup Restoration on Fresh server/New Server

Step 1- First we will copy all the backup to new server 

Step 2-  Now we will create manually pfile and startup database in nomount stage and from here we                 will restore SPFILE and Control file. 

             SQL> startup nomount

Step 3- Now we will connect with RMAN Target                                                                                                                                                                                                                                                
Step 4- After that connect to rman and fire command for spfile restoration and mention full path where                           rman backup is present, with full SPFILE name with extension.

              SQL> restore spfile from 'spfile location\spfile.ora';

Step 5- And restore control file now.

            SQL> restore controlfile from 'location of controlfile\control.ctl';

Step 6- Once we restore control file, go to mount stage. Either sql prompt or rman prompt we can go              to mount stage.

            SQL> alter database mount;

Step 7- Now we have RMAN backup at known location so we have to address that backup to RMAN              by which it can identify backup and can process restore and recovery so we will catalog that               location. Using below command.

            SQL> catalog start with 'location of backup folder';


Step 8- Once we done with catalog then restore our database, It will take time to restore.

           SQL> restore database;


Step 9- Once we complete restoration then will recover database as below command.

           SQL> recover database;

Step 10- In this case of recovery it shows some archive missing so we tried to recover but did not                     reover because archive missing so it will be incomplete recovery. That’s why it’s showing                   error. So what next,
             We will open our database in resetlog mode.

              SQL> recover database open resetlogs;

         Now our task has been completed.



No comments:

Post a Comment