RMAN Video Tutorial series – Performing Disaster Recovery with RMAN
Posted by Kamran Agayev A. on March 29, 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
Shafi said
Thank you for this valuable tutorial…
Ulfat said
Congratulation!
Good work.
Mohamed Azar said
Good job,Great Sir.
Ansari said
Great tutorial.Can u post more backup and recovery scenario using RMAN
Thnx
Wordpress Blog Tutorial 2: Domain & Web Hosting | Host Rage said
[…] RMAN Video Tutorial series – Performing Disaster Recovery wіtһ RMAN « Kamran A… […]
Suhaib said
Excellent video! Nicely explained!
OracleLearner said
Kamran,
thanks for sharing your knowledge.
Denis said
Thanks for the tutorial. it was very informative and a good review.
Kamran Agayev A. said
Dear Ansari
I’m currently working on preparing more interesting scenarios and demonstrations for RMAN backup and recovery techniques
Kamran Agayev A. said
Thank you all for your comments
Zaur Hajili said
Super, thanx a lot for a tutorial. very useful.
vips said
Good job, well preseneted.
Eduardo Legatti said
Hi Kamran,
Excellent tutorial!! Thank’s for sharing.
Cheers
Eduardo Legatti
shahid said
nice tutorial… thanx
Rufat Guliyev said
good presentation Kamran. Excellent job.
Thanks a lot for sharing this tutorial.
Kamran Agayev A. said
Thank you for your comment Rufat
Raja.Govindan said
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
Kamran Agayev A. said
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
Oraclelearner said
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
ArtistePrasanna said
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.
Kamran Agayev A. said
Dear Artiste
I’m currently working on different video tutorials of RMAN scenarios and will post the new tutorial once it’s completed
Khalid said
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
GT said
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.
Kamran Agayev A. said
Hi dear OP
The only difference is you have to create a windows service using ORADIM utility before starting the DR process
Good Luck
GT said
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.
Kamran Agayev A. said
You’re welcome and congratulations!
sai said
it was great and very useful thnx a lot
Abdul Wahab said
Dear Kamran,
Great to share.
Many Thanks to you
Sachin Srivastava said
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
M. Mohammed said
Excellent Work Kamran!
Kamran Agayev A. said
Dear Sachin
You can check the following link:
http://orafin.blogspot.com/2008/08/using-rman-to-backup-r12.html
Sachin Srivastava said
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
Sundar said
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
suvajit said
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.
Kamran Agayev A. said
Thank you for feedback Suvajit
Keep visiting my blog, as I try to post minimum one video tutorial per month
Abdul Kalam said
Dear Kamran,
Excellent Video,
Great effort in sharing ur Knowledge to DBA community.
Regards,
Abdul Kalam
Rajesh Chakraborty said
Dear Kamran vai,
Awesome video,
thank you for sharing such a helpful video for DBA people.
Reynaldo Cruz Rijo said
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.
Reynaldo Cruz Rijo said
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.
Kamran Agayev A. said
Dear Reynaldo
Check the following link:
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmasm.htm#i1016581
Kamran Agayev A. said
Please make sure you’ve followed all steps
Balaji said
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
christy said
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