System refresh using RMAN backup

Thursday, May 24, 201231comments

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 + 31 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/

June 29, 2017 at 6:21 AM

The Creating Experts is the leading trainer in SAP BASIS so, if you are looking for one here is the link

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

contact +91-08122241286

June 29, 2017 at 6:28 AM

The Creating Experts is the leading trainer in SAP BASIS so, if you are looking for one here is the link

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

contact +91-08122241286

July 2, 2017 at 10:23 PM

SAP BASIS training is provided in CHENNAI.

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

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

contact 8122241286

July 11, 2017 at 3:43 AM

The Creating Experts provides training in SAP basis

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

contact +91-08122241286

July 11, 2017 at 11:50 PM

SAP BASIS Training in Chennai is provided by

THE CREATING EXPERTS they provide hands on training with real time scenarios

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

contact 8122241286 for more info

July 14, 2017 at 5:46 AM

Nice blog....For a long time I was looking for SAP BASIS training in Chennai and got the link


THE CREATING EXPERTS is providing SAP BASIS training in real time

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

Contact 8122241286

July 15, 2017 at 3:58 AM

SAP BASIS training is provided in CHENNAI.I personally got trained with them one of the best trainers in CHENNAI

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

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

contact 8122241286

July 21, 2017 at 1:18 AM

Informative post...for a long time I was searching for a trainer in Chennai

And i landed with THE CREATING EXPERTS one of the leading trainer with real time training in Chennai

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

contact 8122241286 for more info.

July 22, 2017 at 1:41 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

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

contact 8122241286

July 24, 2017 at 2:25 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

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

contact 8122241286

July 27, 2017 at 7:18 AM

SAP basis training by THE CREATING EXPERTS

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

contcat 8122241286 for more info.

If you are looking for SAP basis here is a real time trainer to get trained from.

July 28, 2017 at 8:46 AM

Creating experts, A leading career development organization with live examples by corporate Experts.

SAP training by online and classroom training is provided

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


Contact 8122241286 SAP basis training in chennai

July 30, 2017 at 1:58 AM

The Information you provided is very much useful for SAP Learners. This Information was very Interesting,

SAP training in Chennai by THE CREATING EXPERTS for SAP BASIS, take a look at the link below

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

contact 8122241286 for more info.

July 31, 2017 at 9:40 AM

NICE BLOG...SAP basis training in CHENNAI provided by THE CREATING EXPERTS

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

CONTACT 8122241286.

August 11, 2017 at 3:52 AM

Excellent and very cool idea and the subject at the top of magnificence and I am happy to this post..Interesting post! Thanks for writing it. What's wrong with this kind of post exactly? It follows your previous guideline for post length as well as clarity..

AWS Training in Chennai

SEO 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