✌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.
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
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.
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.
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.
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.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
✌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.
Thank you for pointing out. Will correct in future.
Many thanks for this video. It's very crispy and clear..... 👍👍👍👍
Thanks, but ask. if there is no database on the destination, what did you enter in db2 from minute 14:16 to sqlplus?
The instance can be started in no mount mode even if database is not present. You need spfile or pfile for the same.
This was absolutely amazing
Thanks for your valuable time and clear step by step explanation...
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
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.
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.
So if you have specified multiple locations on the source DB for tablespaces, where are the tablespace files placed on the target DB?
You can restore db to different location.
Use set newname for datafile clause in the restore rman run block.
Super and nice explanations please share the documents as u used while restoration.
Thank you
Thank you sir fabulous 😍
Excellent explanation as expected ! how can i get the pdf doc that you used?
In which step u created instance ora19 in db2? I want to understand that
Can the restore be done from a backup that didn't use rman?
Yes, but not using RMAN. If you want to use other backup and restore methods, its fine. However RMAN does not recognize those backups.
many thanks for this video, it is clear to understand.
How can i restore database on a other server for example one minut before failure on source server?
You have to do point in time restore. When you restore you need to specify the time of the restore. It's possible.
where can we get that document you are referring to sir please let us know
Spoon feeding?!
how can i get the pdf doc that you used?
amazing
Thank you! Cheers!
Why not using recovery catalog?
Thank you for suggestion. Will record one using recovery catalog
Awesome explanation....
Sir this video is rman refresh and restore?
Or rman refrssh is separate topics ??
Refresh and restore is same. You can use any keywords. So this video covers both.
@@DB2_Oracle sir how I contact you for further doubt and interview preparation questions?
You can only reach via RUclips Comments. You will not find any Email ID or Contact Number on any of my Video.
where can i download the pdf appeared in your video?
i love the "only God can save you" comment haha
That part was scary. It's like being in no man's land. Cheers Boss
any video on restore with same method on rac setup
Thank you so much
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
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.
Excellent and its top
Thank you.
nicely explained
الف شكر
Could you please provide this PDF file for practice purposes? Thanks
excellent !
thanks
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.
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.
Good explanation and also questions it's helpful for others to understand
Hi pls share your documents for my study purpose
Excellent explanation as expected ! how can i get the pdf doc that you used?
Excellent explanation as expected ! how can i get the pdf doc that you used?
Excellent explanation as expected ! how can i get the pdf doc that you used?