System refresh using RMAN backup

Thursday, May 24, 201216comments

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




Share this article :

+ comments + 16 comments

February 25, 2013 at 9:53 PM

what does rman_util representing?

October 4, 2013 at 2:35 PM

how do you restore redologs and control file first before restoration of datafiles ? I understand the control files are backed up using backint and not RMAN. Mu backup doesnot have a recovery catalog rather it uses controlfile. Kindly post the syntax

I'm facing a similar scenairo.

September 6, 2014 at 10:52 AM

W3webschool on of the best online training institute in india we offering courses like Web Design Training , Advanced SEO Training , Php/Mysql Training , Graphic Design Training , Java Training , Wordpress Training with 100% live project and practical class.

March 6, 2016 at 11:30 PM

Thanks for the great information in your blog SAP SF Training in Chennai

May 4, 2016 at 11:28 PM

Thanks for the great information ,was looking for this information from long.Great blog SAP Basis Training in Chennai

July 29, 2016 at 6:30 AM



This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.

Online Reputation Management

August 9, 2016 at 7:46 AM




Awesome article. It is so detailed and well formatted that i enjoyed reading it as well as get some new information too.


BASE SAS training in Chennai

August 22, 2016 at 11:44 PM

Great place to learn new things and got the best SAP BASIS Training in Chennai

December 24, 2016 at 2:17 AM

It was very nice blog to learn about SAP BASIS. Thanks for sharing
We provides Best SAP BASIS. Training in Chennai with real time project assistance by our leading SAP BASIS. Consultant.
For Free Live Demo @ Call to 8122241286.
SAP MM, SAP SD, SAP HR,SAP FICO 
www.thecreatingexperts.com 
.SAP basis

January 17, 2017 at 9:37 PM

Creating experts, A leading career development organization provides Real time training in SAP Success Factors, SAP MM, SAP SD, SAP ABAP, SAP BASIS,SAP BASIS, SAP FICO, with live examples by corporate Experts.
www.thecreatingexperts.com (Best SAP training institute in chennai with placement assistance)
SAP Success Factor, SAP MM Training in chennai Vadapalani ECR velachery Tambaram
SAP basis training in chennaai

March 2, 2017 at 1:11 AM

You have share the great info. I like your post. Thanks for sharing the good points. I will recommend this info. industrial training Punjab

April 6, 2017 at 4:25 AM

This list is in reality very beneficial. in an assessment of top notch internet net websites I have visited, you moreover could probably in all like LaHood blanket the little thru the guide to test in this internet websites
for more information please visit the site
Oracle Fusion procurement Online Coaching
Oracle Fusion procurement Coaching Center

June 15, 2017 at 11:13 PM

Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..
PHP Training in Chennai

June 16, 2017 at 11:20 PM

Thank you for your post..much helpful to know things better.

I personally got trained with THE CREATING EXPERTS one of the best trainer in CHENNAI with hands on training in real time scenarios.

It would be useful for the viewers to take a look at the provided link below for SAP trainings.

http://thecreatingexperts.com/sap-basis-training-in-chennai/

Post a Comment
 
Support : Basis SAP | Basis SAP | Basis SAP
Copyright © 2011. Basis SAP - All Rights Reserved
Template Created by Basis SAP Published by Basis SAP
Proudly powered by Blogger