System refresh using RMAN backup

Here i am providing steps for System refresh using RMAN backup.

1.Ensure db is shutdown

Sqlplus “/ as sysdba”

Shutdown immediate

exit

2.Create a symbolic link on target server

cd /oracle

ln –s /oracle/


3. Ftp to the following directory on Source server

/oracle//sapbackup

Copy to /oracle//sapbackup on the target server the required file for the restore.

Note you will always need the .fnr (Level 0) backup

Also copy across the required .inr file, this should be the .inr backup closest to the point in time you are trying to recover to, but not later than.

Final file to copy is back.log

Once copied to target server, ensure permissions are correct

4.Ftp to the following directory on Source server

/oracle//102_64/dbs

Copy the following files to

/oracle//102_64/dbs

 Init.dba

init.ora

init.sap

init.sap

init.sap_rman_incr

spfile.ora

 init.bki

Again check permissions once copied

5. Set environment variables on target server

Note – Ensure you are logged in as ora

SETENV DB_SID

SETENV SAPDATA_HOME /ORACLE/

SETENV ORACLE_HOME /oracle//102_64

If your session times out, or you log off these environment variables will need to be set again

6.

Restore the DB control files saved with the Level 1 backup (This is the .inr file)

brrestore -b <.inr file>  -m 0 -d rman_util

Once complete you should then have the Source SID control files in the following locations

/oracle//sapdata1/cntrl

/oracle//origlogA/cntrl

/oracle//origlogB/cntrl

7.Mount the Database

Sqlplus “/ as sysdba”

Startup mount

Exit

8.Start the restore of the data files

brrestore -b <.fnr filename> -m all -d rman_util

Check log file for successful completion

9.

Apply incremental backup once step 8 complete

brrestore -b <.inr filename> -m incr -d rman_util

Check log file for successful completion

10.

Shutdown DB

Sqlplus “/ as sysdba”

Shutdown immediate

exit

11. Log off as ora to reset environment variables to original values

12.

On target server remove the logical link created earlier

Cd /oracle

Rm  

13 .

Change the SID of the database by running the control.sql file:

Run the control.sql script at the sqlplus command prompt:

- logon to target system and type:-

      su – ora

sqlplus “/as sysdba”

      sqlplus> @control.sql

      sqlplus> exit;

14.

Follow Step mention in System Refresh Documentation to complete point in time recovery using log files.

15.

You can check the database has returned to its original SID and using the correct control files by issuing the following commands

Sqlplus “/ as sysdba”

Show parameter control_file;

The output should reference the target SID

select NAME from v$database;

This should show the target SID

16.

Continue as per System Refresh activity. and follow remaining  Post processing steps