Kamran Agayev's Oracle Blog

Oracle Certified Master

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

67 Responses to “RMAN Video Tutorial series – Performing Disaster Recovery with RMAN”

  1. Shafi Says:

    Thank you for this valuable tutorial…

  2. Ulfat Says:

    Congratulation!
    Good work.

  3. Mohamed Azar Says:

    Good job,Great Sir.

  4. Ansari Says:

    Great tutorial.Can u post more backup and recovery scenario using RMAN

    Thnx

  5. Wordpress Blog Tutorial 2: Domain & Web Hosting | Host Rage Says:

    [...] RMAN Video Tutorial series – Performing Disaster Recovery w&#1110t&#1211 RMAN « Kamran A… [...]

  6. Suhaib Says:

    Excellent video! Nicely explained!

  7. OracleLearner Says:

    Kamran,

    thanks for sharing your knowledge.

  8. Denis Says:

    Thanks for the tutorial. it was very informative and a good review.

  9. Kamran Agayev A. Says:

    Dear Ansari
    I’m currently working on preparing more interesting scenarios and demonstrations for RMAN backup and recovery techniques

  10. Kamran Agayev A. Says:

    Thank you all for your comments

  11. Zaur Hajili Says:

    Super, thanx a lot for a tutorial. very useful.

  12. vips Says:

    Good job, well preseneted.

  13. Eduardo Legatti Says:

    Hi Kamran,

    Excellent tutorial!! Thank’s for sharing.

    Cheers

    Eduardo Legatti

  14. shahid Says:

    nice tutorial… thanx

  15. Rufat Guliyev Says:

    good presentation Kamran. Excellent job.
    Thanks a lot for sharing this tutorial.

  16. Kamran Agayev A. Says:

    Thank you for your comment Rufat

  17. Raja.Govindan Says:

    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

  18. Kamran Agayev A. Says:

    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

  19. Oraclelearner Says:

    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

  20. ArtistePrasanna Says:

    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.

  21. Kamran Agayev A. Says:

    Dear Artiste

    I’m currently working on different video tutorials of RMAN scenarios and will post the new tutorial once it’s completed

  22. Khalid Says:

    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

  23. GT Says:

    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.

  24. Kamran Agayev A. Says:

    Hi dear OP

    The only difference is you have to create a windows service using ORADIM utility before starting the DR process

    Good Luck

  25. GT Says:

    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.

  26. Kamran Agayev A. Says:

    You’re welcome and congratulations!

  27. sai Says:

    it was great and very useful thnx a lot

  28. Abdul Wahab Says:

    Dear Kamran,

    Great to share.

    Many Thanks to you

  29. Sachin Srivastava Says:

    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

  30. M. Mohammed Says:

    Excellent Work Kamran!

  31. Kamran Agayev A. Says:

    Dear Sachin

    You can check the following link:
    http://orafin.blogspot.com/2008/08/using-rman-to-backup-r12.html

  32. Sachin Srivastava Says:

    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

  33. Sundar Says:

    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

  34. suvajit Says:

    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.

  35. Kamran Agayev A. Says:

    Thank you for feedback Suvajit

    Keep visiting my blog, as I try to post minimum one video tutorial per month

  36. Abdul Kalam Says:

    Dear Kamran,

    Excellent Video,

    Great effort in sharing ur Knowledge to DBA community.

    Regards,
    Abdul Kalam

  37. Rajesh Chakraborty Says:

    Dear Kamran vai,

    Awesome video,

    thank you for sharing such a helpful video for DBA people.

  38. Reynaldo Cruz Rijo Says:

    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.

  39. Reynaldo Cruz Rijo Says:

    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.

  40. Kamran Agayev A. Says:

    Dear Reynaldo

    Check the following link:
    http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmasm.htm#i1016581

  41. Kamran Agayev A. Says:

    Please make sure you’ve followed all steps

  42. Balaji Says:

    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

  43. christy Says:

    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

  44. Star Shahuri Says:

    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

  45. Star Shahuri Says:

    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.

  46. Firdous Says:

    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

  47. Kamran Agayev A. Says:

    No it’s not possible, for this you need to convert the database to the required format and then restore/recover it

  48. Ramakant Says:

    Its one of the great tutorial I have seen. Really very helpful .
    Thanks a lot for sharing .

  49. Syed Says:

    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

  50. Syed Says:

    Mr. kamran,

    Please reply to my previous message, its a bit of urgent.

    Kindly do the needful.

    Regards

  51. Kamran Agayev A. Says:

    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

  52. Rajnish Kumar Says:

    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.

  53. abdul Says:

    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

  54. abdul Says:

    hi,
    dear kamran,

    i want to know how would update the dr if some updation is occour in prod db.
    plz let me know

  55. Kamran Agayev A. Says:

    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

  56. Kamran Agayev A. Says:

    You clone db while database is running for the testing purpose or something else
    You perform a Disaster Recovery when your database is down

  57. abdul Says:

    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

  58. Sanjay Patil Says:

    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

  59. Kamran Agayev A. Says:

    Could you post the steps you perform and error you get?

  60. Sever Says:

    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

  61. Kamran Agayev A. Says:

    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

  62. Vishnu Says:

    Excellent Work done!!

    The video cleared and eliminated all my doubts…

    Thanks Sir for sharing your Valuable info through video..

    Very much Appreciated !!!

  63. Vishnu Says:

    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

  64. Kamran Agayev A. Says:

    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

  65. Vishnu Says:

    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 !!!

  66. Kamran Agayev A. Says:

    All you need is just to follow the steps I’ve shown in the video tutorial

  67. vishnu Says:

    but here i have the same db name running on both servers..

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>