System refresh using RMAN backup

Thursday, May 24, 201228comments

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 + 28 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.

Anonymous
June 27, 2015 at 4:56 AM

Good.. Real time Training in SAP HR

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

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

Anonymous
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/

Anonymous
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

Anonymous
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

Anonymous
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

Anonymous
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

Anonymous
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

Anonymous
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.

Anonymous
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

Anonymous
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.

Anonymous
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

September 4, 2017 at 3:12 AM

Thanks for appreciating. Really means and inspires a lot to hear from you guys.I have bookmarked it and I am looking forward to reading new articles. Keep up the good work..Believe me, This is very helpful for me.

SAP Training in Chennai

SAP ABAP Training in Chennai

May 30, 2018 at 10:16 PM

Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all.

sap abap training

October 25, 2018 at 10:42 PM

High Technologies Solutions is an award winning SAP Education Partner in India & overseas. Our best SAP Certification Courses in Delhi, Noida & Gurgaon will help you to get placed at renowned organizations. To Know More Detail-https://www.htsindia.com/

Sap Authorised Training Centres in Gurgaon
Sap Training Centres in Gurgaon
Sap Course fees in Gurgaon
Sap Institute in Gurgaon
Sap Training Centres in Gurgaon

October 16, 2019 at 5:24 AM

Creative experts, A leading career development organization with live examples by corporate Experts. So thanks for sharing this useful information with us.
ecommerce website design
redbus ticket online booking
best matrimonial site
Digital Marketing Institute

June 4, 2021 at 5:04 AM

Thanks for Sharing this Information. SAP Basis Institute in Gurgaon

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