Oracle 19c RMAN Backup And Restore

[@pedrokarandeniya162]

✌clearly explained. Very good video. The only point to add is once you had changed the name of the database you had forgot to change the entry in /etc/oratab with the new database name.

[@DB2_Oracle]

Thank you for pointing out. Will correct in future.

[@wildanusman]

Many thanks for this video. It's very crispy and clear..... 👍👍👍👍

[@gsraj511]

Thanks for your valuable time and clear step by step explanation...

[@yatheeshkumar294]

Super and nice explanations please share the documents as u used while restoration. Thank you

[@joseCausado-v3p]

Thanks, but ask. if there is no database on the destination, what did you enter in db2 from minute 14:16 to sqlplus?

[@DB2_Oracle]

The instance can be started in no mount mode even if database is not present. You need spfile or pfile for the same.

[@sadrulalom1627]

Excellent explanation as expected ! how can i get the pdf doc that you used?

[@SleekPaul]

Pls can u share the scripts u used. Then at first u said there's no running database on the target. I don't think u can have an Oracle home without a database in it. I got confused at the point i saw u did cd Oracle home on the target server. U can help clarify. Because the scenario i am looking at is a case where u just server ans an OS running then u copy the init.ora, orapw file and backups then create directories. Thank you

[@DB2_Oracle]

You can have ORACLE_HOME without any database in it. In most production servers, we first install Oracle Software which creates Oracle Home. Then we create the database. In this lab, the Oracle is installed on both of the servers before. And on the target server, there is no Database created.

[@SleekPaul]

Thanks again boss. You are the best. If it pleases you can u share the script u used for this demo with me for my enhancement.

[@im_akash]

In which step u created instance ora19 in db2? I want to understand that

[@ansariimran3029]

This was absolutely amazing

[@itschriscash]

So if you have specified multiple locations on the source DB for tablespaces, where are the tablespace files placed on the target DB?

[@DB2_Oracle]

You can restore db to different location. Use set newname for datafile clause in the restore rman run block.

[@srinivaskotte8838]

how can i get the pdf doc that you used?

[@kylamarshall4042]

Can the restore be done from a backup that didn't use rman?

[@DB2_Oracle]

Yes, but not using RMAN. If you want to use other backup and restore methods, its fine. However RMAN does not recognize those backups.

[@weicui6692]

where can i download the pdf appeared in your video?

[@gotchihaeyo1825]

Why not using recovery catalog?

[@DB2_Oracle]

Thank you for suggestion. Will record one using recovery catalog

[@shrivyam]

Thank you sir fabulous 😍

[@pratikraghuvanshi]

any video on restore with same method on rac setup

[@bk5268]

Sir this video is rman refresh and restore? Or rman refrssh is separate topics ??

[@DB2_Oracle]

Refresh and restore is same. You can use any keywords. So this video covers both.

[@bk5268]

@@DB2_Oracle sir how I contact you for further doubt and interview preparation questions?

[@DB2_Oracle]

You can only reach via KZbin Comments. You will not find any Email ID or Contact Number on any of my Video.

[@PrajwalM-zh6xx]

where can we get that document you are referring to sir please let us know

[@sebastianthomas4286]

Spoon feeding?!

[@krzysztofrz82]

How can i restore database on a other server for example one minut before failure on source server?

[@DB2_Oracle]

You have to do point in time restore. When you restore you need to specify the time of the restore. It's possible.

[@sangarapple7479]

many thanks for this video, it is clear to understand.

[@papsny]

i love the "only God can save you" comment haha

[@SleekPaul]

That part was scary. It's like being in no man's land. Cheers Boss

[@naeemakram6126]

Could you please provide this PDF file for practice purposes? Thanks

[@shorifulislam923]

amazing

[@DB2_Oracle]

Thank you! Cheers!

[@huynhtruong5072]

If we do not have (pfile and password file ## lost on source db), we have rman backup file, can we store db to another server? thanks

[@DB2_Oracle]

Yes, you can. Oracle Provides sample pfile in ORACLE_HOME directory. You can copy it and modify it as per your requirements. Also Password file can be re-created any time. You can restore your database even if you do not have pfile and password file. Its just more work.

[@shahnawajshaikh7491]

nicely explained

[@rameshshete927]

Awesome explanation....

[@AbdulmaneaAlmuradi]

Thank you so much

[@nihadawad4681]

الف شكر

[@dsgamingfreefire6392]

Hi pls share your documents for my study purpose

[@stunnersudheer1927]

Excellent and its top

[@DB2_Oracle]

Thank you.

[@tahirm09]

excellent !

[@ivlgames8760]

I'm sorry but this is not a backup this is a transfer of the database to a seperate server. Why do I say this, first of all your rman files are stored on the original server. What will you do when your server bursts in to flames and you can't access the original server? Nothing, so you don't have a backup.

[@DB2_Oracle]

Very nice. Thanks for the comment. However, no organization would be storing backups on their original server. They will be stored on a storage disk which is different than the actual database server. And if they are storing the backups on database server itself, its a bad design. This video is a demo of how to perform backup and restore.

[@dsgamingfreefire6392]

Good explanation and also questions it's helpful for others to understand

[@ramonilameed500]

thanks

[@srinivaskotte8838]

Excellent explanation as expected ! how can i get the pdf doc that you used?

[@srinivaskotte8838]

Excellent explanation as expected ! how can i get the pdf doc that you used?

[@srinivaskotte8838]

Excellent explanation as expected ! how can i get the pdf doc that you used?