Rman Restore from Productions Server To UAT or DEV Server

Rman Restore from Productions Server To UAT or DEV Server

Collect The Refresh Form :-
I say Example like
  IP address:-                                  DBNAME
      PROD --> 192.168.0.9             PRODDB
     TEST -->  192.168.0.15            PRODDB

STEPS:-       

                               PRODUCTIONS

      1)      Take Backup from Production with RMAN Backup

      2)      Copy the Parameter file and Password file from Production to Test environment Through SCP Command

      3)      Move the backups from Production to Test environment

                TESTING  

     1)      Make a directory Udump dpdump cdump

     2)      Edit password and parameter file

     3)      Startup nomount

     4)      Connect rman utility

     5)      Restore controlfile from backup path

     6)      Alter database mount

     7)      Start with catalog in Rman utility

     8)      Restore database and  Recover database

     9)      Open resetlogs

                               Screen Shots

PRODUCTIONS

     1)      Take Backup from Production with RMAN Backup 

 

I have set to backup path like ‘/ftdatagb/rman/%u.bkp’

2) Copy the Parameter file and Password file from Production to Test environment   Through SCP Command 

3) Move the backups from Production to Test environment 

                      Now am completed in production server Side 

                                              TESTING  

       1)      Make a directory  like /ebdata/FTPDB

Under FTPDB create three directory like adump dpdump cdump

        2)      Edit password and parameter file

 

         You must set two parameter like db file name convert and logfile name convert

        3)      Startup nomount

        4 )      Connect rman utility

   5)      Restore controlfile from backup path

    6)      Alter database mount

     7)      Start with catalog in Rman utility 

           After start with location I have to check all datafile is there or not

         8)      Restore database and  Recover database

                Final again I got error 

           Solution for Error ORA-00349 Rename the logfiles 

           9)      Open resetlogs

            Solution for this error ORA-00312

             Solution for Error ORA-39700:

            Run the script like that

            Script(ORACLE_HOME)/rdbms/admin/catupgrd.sql

            SQL > Shut immediate

            SQL > startup

    

                                             Completed task ………