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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply