November 2, 2008 at 9:44 pm
For SQL Server, restore headeronly displays the backup set details including servername, backup startdate/finishdate, etc.
Is there any equivalent command/method to retrieve those info from Oracle database backup? The backups are either via export, on-line/off-line or RMAN.
November 3, 2008 at 3:42 am
Lets go step by step here.
1- Export. Since you cannot recover a database from an export dump, export is not considered a backup. Either way export would write a log file.
2- OnLine/OffLine. Assuming you are talking about hot and cold backups in both cases it's your resposibility to write down a log file.
3- Rman. Rman remembers everything, just check the documentation which is free and public at http://www.oracle.com/pls/db102/portal.all_books
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.November 3, 2008 at 8:49 am
RMAN> list backup summary;
November 3, 2008 at 10:39 pm
Thanks for your help.
I need to find out the information from the backup set itself rather than checking the log from the source server. Is the info self-contained within the backup set? I am looking for the command/method to retrieve them if it is possible.
Yes, online = hot and offline = cold.
November 4, 2008 at 1:39 am
You are talking about three very different things, they are not remotely compatible.
Export -which is not technically a backup would generate a dump file; you are free to see what's inside.
Hot/Cold backups are nothing but copies of the physical datafiles, etc.
Rman - Look at the previous poster answer.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy