✌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.
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.
✌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.
Thanks for your valuable time and clear step by step explanation...
This was absolutely amazing
many thanks for this video, it is clear to understand.
Super and nice explanations please share the documents as u used while restoration.
Thank you
Awesome explanation....
i love the "only God can save you" comment haha
nicely explained
Excellent and its top
Thank you.
excellent !
الف شكر
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.
thanks
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.
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
where can we get that document you are referring to sir please let us know
how can i get the pdf doc that you used?
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.
any video on restore with same method on rac setup
Could you please provide this PDF file for practice purposes? Thanks
where can i download the pdf appeared in your video?
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.
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.
Why not using recovery catalog?
Thank you for suggestion. Will record one using recovery catalog
Hi pls share your documents for my study purpose
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 CZcams Comments. You will not find any Email ID or Contact Number on any of my Video.
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
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?