RMAN Video Tutorial series – Performing Disaster Recovery with RMAN
Posted by Kamran Agayev A. on March 29th, 2010
In this video tutorial I perform a disaster recovery of the database using two virtual machine with RMAN. Enjoy it
To download the .mp4 version of this file, use the following link
http://www.kamranagayev.com/Video_Tutorials/Disaster_Recovery.mp4
March 29th, 2010 at 11:54 am
Thank you for this valuable tutorial…
March 29th, 2010 at 11:58 am
Congratulation!
Good work.
March 29th, 2010 at 12:36 pm
Good job,Great Sir.
March 29th, 2010 at 11:47 pm
Great tutorial.Can u post more backup and recovery scenario using RMAN
Thnx
March 30th, 2010 at 1:07 pm
Dear Ansari
I’m currently working on preparing more interesting scenarios and demonstrations for RMAN backup and recovery techniques
March 30th, 2010 at 12:04 am
[…] RMAN Video Tutorial series – Performing Disaster Recovery wіtһ RMAN « Kamran A… […]
March 30th, 2010 at 2:05 am
Excellent video! Nicely explained!
March 30th, 2010 at 2:58 am
Kamran,
thanks for sharing your knowledge.
March 30th, 2010 at 5:00 am
Thanks for the tutorial. it was very informative and a good review.
March 30th, 2010 at 1:11 pm
Thank you all for your comments
March 30th, 2010 at 3:34 pm
Super, thanx a lot for a tutorial. very useful.
April 4th, 2010 at 11:51 pm
Good job, well preseneted.
April 5th, 2010 at 2:23 am
Hi Kamran,
Excellent tutorial!! Thank’s for sharing.
Cheers
Eduardo Legatti
April 5th, 2010 at 5:14 am
nice tutorial… thanx
April 21st, 2010 at 1:25 am
good presentation Kamran. Excellent job.
Thanks a lot for sharing this tutorial.
April 21st, 2010 at 8:43 am
Thank you for your comment Rufat
April 28th, 2010 at 11:14 am
Hello Kamran. Though I have experience with Oracle but not with RMAN and I had been given task to recreate a development from production rman backup copy. I was searching for some good examples and information to complete my task. Google gave your link fortunately. I found your vedio session was very much useful and very clear. I am certain that you excelled in your RMAN restoration tutorial better than Oracle corp. tutorials. Congratulations
Thanking you very much for your tutorial.
-/Raja.Govindan
April 28th, 2010 at 2:06 pm
Thank you dear Raja for the kind words.
I’m really happy that my video tutorials are helpful for you and for other DBAs around the world. It gives me inspiration to prepare another video tutorials on different areas of Oracle (Especially RMAN as I’m an author of upcoming RMAN book)
Take care and check my Video Tutorials link frequently
May 19th, 2010 at 9:50 am
Kamran,
thanks again for sharing your knowledge(videos and tutorials). You have a lot of knowledge in Oracle database which I find you as a valuable source for Oracle newbies.
Regards,
Oraclelearner
August 6th, 2010 at 10:24 am
I again Thank you Mr.Kamran.
This video clarified my doubts and gave more insight on the recovery scenario. I (People like me) expect much more guidance from you on this particular aspect of using RMAN to its complete extent.
Thanks a lot again.
August 6th, 2010 at 10:27 am
Dear Artiste
I’m currently working on different video tutorials of RMAN scenarios and will post the new tutorial once it’s completed
August 21st, 2010 at 1:44 pm
Hi..
very Nice video tutorial… thanks..
But I have one question that is… if we have ASM disk (+FLASH) instead of flash_recovery_area for rman backup so how can we transfer this backupset to another machine…
plz reply me ..
Regards…
KHALID
khalid_dba@yahoo.com
October 27th, 2010 at 1:12 am
Thank you for the wonderful effort to let everyone know how RMAN works. I have some questions on this RMAN restore.
Does this work the same way in Windows Server environment as well?
I tried to set ORACLE_SID and tried to run RMAN on the DR but getting TNS 12560 error. Do we need to do any pre-checks before attempting to run RMAN to recover spfile and control file? Thanks for you help.
October 27th, 2010 at 6:32 pm
Hi dear OP
The only difference is you have to create a windows service using ORADIM utility before starting the DR process
Good Luck
October 28th, 2010 at 4:23 am
It worked as I was able to restore the database successfully on a new server after creating windows service using ORADIM. Thank you very much for the immediate response that made my day. Looking forward to see more tutorials from you. Thanks once again.
October 28th, 2010 at 9:35 am
You’re welcome and congratulations!
November 22nd, 2010 at 3:58 pm
it was great and very useful thnx a lot
February 3rd, 2011 at 10:11 pm
Dear Kamran,
Great to share.
Many Thanks to you
February 9th, 2011 at 11:13 am
Hi,
Thanks a lot for sharing the detailed procedure, i’ve installed a fresh R12 instance on oracle enterprise linux (x-86 32 bit) but finding it difficult to start RMAN from the OS prompt. Please suggest me the way out..
Regards
February 10th, 2011 at 10:00 am
Dear Sachin
You can check the following link:
http://orafin.blogspot.com/2008/08/using-rman-to-backup-r12.html
February 10th, 2011 at 9:54 am
Excellent Work Kamran!
February 10th, 2011 at 10:14 am
Hi,
Thanks a lot for sharing the detailed procedure, i’ve installed a fresh R12 instance on oracle enterprise linux (x-86 32 bit) but finding it difficult to start RMAN from the OS prompt. Please suggest me the way out..
Regards
February 16th, 2011 at 5:35 am
Excellent Tutorial, very informative !!
I have a question or rather doubt, how is this approach different than “duplicate target database”. Can’t we use this approach to clone or duplicate the database on other server.
Much appreciated.
Regards
February 25th, 2011 at 10:43 am
I never expected a goldmining vedio lik this. I am really appriciate for ur effort. The vedio is wonderful, very very well explained. Thank you sir.
February 25th, 2011 at 10:54 am
Thank you for feedback Suvajit
Keep visiting my blog, as I try to post minimum one video tutorial per month
March 27th, 2011 at 10:12 am
Dear Kamran,
Excellent Video,
Great effort in sharing ur Knowledge to DBA community.
Regards,
Abdul Kalam
May 26th, 2011 at 10:03 am
Dear Kamran vai,
Awesome video,
thank you for sharing such a helpful video for DBA people.
June 2nd, 2011 at 8:49 pm
Thanks for this video, it was very helpful for me.
Now, follow all steps, but im getting this error when i do the open resetlogs:
RMAN-11003: failure during parse/execution of SQL statement: alter database open resetlogs
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: ‘/orainst/app/oracle/oradata/lanco/system01’
I want open my database even with some data lost, but i need to openit in a consistent state.
I’ll appreciate your help.
June 6th, 2011 at 1:51 am
Please make sure you’ve followed all steps
June 3rd, 2011 at 12:52 am
PD: Im making the exercise from an ASM to a FileSystem Based DB. All process goes fine but, alter database open resetlogs.
Hope you can light me.
June 6th, 2011 at 1:47 am
Dear Reynaldo
Check the following link:
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmasm.htm#i1016581
August 3rd, 2011 at 5:35 pm
Hi Kamran,
This video has been a real help for me. I have tried the same steps what have showed in the video but for some reason my backup doesn’t have archivelog file in it. I have ensured it is in archivelog mode but still it doesnt help. Please advise. I have restored spfile file but i am unable to do controlfile. I dont even find the archivelog folder within backup folder
August 25th, 2011 at 6:28 pm
hi
this was great but i’m still having a problem starting up rman to perform a restore on my new host, its giving me RMAN-00554,04005 error and also ORA-12560 error which i excepted because, as your video said, i should install ONLY the oracle software without configuring any database. Pls help anyone
October 24th, 2011 at 12:47 am
Hello,
Thank you for this tutorial. It moves a little fast for me but it was great when I paused it and took notes. Thank you again.
Star Shahuri
October 24th, 2011 at 1:54 am
I was looking at the time that I turned in the last comment and the time is incorrect right now it has been about an hour since I commented and it is 10/23/2011 9:54 pm est. Please verify, thank you.
November 18th, 2011 at 1:49 pm
Hello kamran,
your document is wounderful, i just a a question which i want to be answered. is it possiable to restore rman back across platforms.
eg: i have windows production database, if i take rman full back along with spfile and controlfile, is it possiable to restore this backup on linux platform, if so please just send me some link or document if not then is their any possiable way out.
thanks and regards
Firdous
November 21st, 2011 at 3:41 pm
No it’s not possible, for this you need to convert the database to the required format and then restore/recover it
February 18th, 2012 at 3:48 am
Its one of the great tutorial I have seen. Really very helpful .
Thanks a lot for sharing .
April 17th, 2012 at 12:18 pm
Dear Kamran,
Excellent Work! Your document is wounderful for the beginners like me in the area of RMAN.
Will be really grateful if you could please answered to some of my questions on dr.
In windows platform, have two nodes (node1 – Production DB(PD) & node2 – Recover DB (RD)), on node1 backups has been scheduled as : Sat – Ince Level 0, Sun to Fri – Ince Level 1.
First thing i want to be sure about the requirement of archivelog, is it manadatory to take backup with archivelogs or not?, if i take rman backup (1 week bkp i.e 1L0+6L1 along with spfile and controlfile only not archivelogs, then is it possiable to restore this backup in node2, or archivelogs should also be available with the datafile,controlfile and spfile backup at dr side.
Please can you provide me some moi links or your valuable documents to perform the dr using incremental l0,l1 backups.
Best Regards
Syed
April 19th, 2012 at 3:57 am
If you don’t take backup of archived redo log files and then delete them, you’ll be asked to perform the recovery when you’ll recovery from full backup, as there were changes made to the database while you backup was running in the background
So make sure you take backup of archived redo log files as well
But if you don’t delete archived redo log files and can use it anytime, you don’t need to backup them with RMAN
April 18th, 2012 at 1:27 pm
Mr. kamran,
Please reply to my previous message, its a bit of urgent.
Kindly do the needful.
Regards
July 2nd, 2012 at 6:52 am
Hi Kamran,
This video is so simple to understand RMAN backup and restore process . thanks for share this videos.
share more videos on different and complex techniques of oracle , like RAC configuration.
July 26th, 2012 at 9:03 am
Hi,
kamran ,i have performed cloning of database before this but i donot find any emphasis point THATs make me understand the difference b/w disaster recovery and cloning of db. if any then let me know .
thanks
August 2nd, 2012 at 7:22 am
You clone db while database is running for the testing purpose or something else
You perform a Disaster Recovery when your database is down
July 31st, 2012 at 1:30 pm
hi,
dear kamran,
i want to know how would update the dr if some updation is occour in prod db.
plz let me know
August 2nd, 2012 at 7:11 am
If the production db is updated, all changes are written to redo log files, then redo log files are archived and sent to DR site where it automatically applied to the Standby database
August 3rd, 2012 at 6:26 am
dear kamran,thanks for the reply,
but my problem is, it is not sent archive to dr.
why so? must i apply some parameters that invokes updated logs to dr. if yes? then what is that parameters?
thanks
September 2nd, 2012 at 11:29 am
Dear Sir
Thanks for your valuable guidelines of disaster recovery using RMAN technology,but I getting error while the same step using in Windows XP OS…Can’t restore Spfile / controlfile….
Can u suggest commands to restore both file in win environment…
sanjay patil
September 4th, 2012 at 2:42 pm
Could you post the steps you perform and error you get?
July 25th, 2013 at 2:47 am
Thank you Kamran for the great post. Question? how does it change if I have a full backup, and a differential backup and archive logs in order to do the disaster recovery on another server?
Thank you Sever
July 26th, 2013 at 4:17 am
If you have full backup, incremental backup and archived redo log files, RMAN will restore Full backup, then recover using incremental backup and applies necessary archived redo log files at the end
August 4th, 2013 at 7:03 pm
Excellent Work done!!
The video cleared and eliminated all my doubts…
Thanks Sir for sharing your Valuable info through video..
Very much Appreciated !!!
August 4th, 2013 at 7:08 pm
I need to restore the DR database with latest full rman backup and archive logs to revocer the db.
For this:
1. I need to copy over the RMAN backup sets to target server, and place those in backup directory. (Using rsync/scp etc.)
2.Copy over the archivelog files to target server .
3.Restore the database and leave it in recovery mode.
How can i do the restore and leave the db in recovery mode. Please advise and help me.
Please elaborate 3rd step in detail and for stes 1 & 2.. what files are need to be copied to the other server???
I already have the same database in DR side also but t was restored 6 months earlier..So what is the plan for it now Sir..
Waiting for your reply…Thanks in Advance !!!
I need to re
August 5th, 2013 at 4:01 am
Hi Vishnu
And why you don’t want to recover the database. Without recovering the database, you will not be able to open it?
If you don’t want to recover, don’t run “recover database” command
August 5th, 2013 at 11:32 am
Hi Kamran,
Thanks for the reply !!
I want to recover the database as well after restore.
In both the servers i have the same db running..The requirement here is to restore & recover the database with the latest rman full backup of production at other server which has the same directory structure and db name and then to apply logs of productn on dr side..
Please advice me how can i implement this in detail..
Thanks !!!
August 5th, 2013 at 11:33 am
All you need is just to follow the steps I’ve shown in the video tutorial
August 5th, 2013 at 11:37 am
but here i have the same db name running on both servers..
September 23rd, 2013 at 4:45 pm
Awesome Video !! Thanks You.
Vishnu .. it works fine with the same database names as well .. actually it’s easier.
Just follow step by step ignoring the export sid statement. I also performed on Windows 2008
server with no issues.
February 20th, 2014 at 9:14 am
Thank you very much , this clip use full to me.
May 5th, 2014 at 6:58 pm
After listening to this video, I bought Oracle Backup and Recovery by Kamran Agayev A., from Amazon. The explanation is pretty much on the money. Thanks!
May 8th, 2014 at 7:57 pm
I forgot to include on thing in my last postage. I did order for Oracle Backup & Recovery by the author of this video and another person (Karam Agayev Agamehdi & Aman Sharma). Oh my. If you have not bought this book, you better do before the publisher stops manufacturing it! Wow, what took me so long to find a great book like this.
March 13th, 2017 at 4:20 pm
You saved my day. Thank You.
September 12th, 2018 at 3:12 pm
Thank you so much kamran. You are the best. This really helped me understanding the recovery process.
September 12th, 2018 at 3:15 pm
You’re welcome my friend. Make sure to follow oraclevideotutorials.com for more videos!