Home » RDBMS Server » Backup & Recovery » Verify Success of DB Backups (Oracle 10g, Sun Solaris)
Verify Success of DB Backups [message #436160] Mon, 21 December 2009 22:11 Go to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi

Is there any way that I can verify success of database archiving backup to tape drives from database level.

Version : Oracle 10g
OS - Sun solaris 10

Prashanth
Re: Verify Success of DB Backups [message #436161 is a reply to message #436160] Mon, 21 December 2009 22:26 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Is there any way that I can verify success of database archiving backup to tape drives from database level.

Native Oracle knows nothing about any "tape" device.
If the tape management/administration software keeps information in Oracle, then you can query that information; otherwise answer is NO
Re: Verify Success of DB Backups [message #436170 is a reply to message #436161] Tue, 22 December 2009 00:16 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
you can set up alert Backup job if it finished or not !!!

-RB
Re: Verify Success of DB Backups [message #436172 is a reply to message #436170] Tue, 22 December 2009 00:22 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
What do you mean by "finished" here ? Successful ? Or failure? Or both (Just a message finished) Wink

sriram Smile
Re: Verify Success of DB Backups [message #436201 is a reply to message #436160] Tue, 22 December 2009 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is a RMAN backup execute the RESTORE VALIDATE command.

Regards
Michel
Re: Verify Success of DB Backups [message #436258 is a reply to message #436160] Tue, 22 December 2009 08:23 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Examining the RMAN log file for errors would at least let you know if the tapes were written succesfully or not.

Unfortunately you would still need to execute the RESTORE VALIDATE as Michel suggested in order to actually verify the integrity of the backup.
Razz
Previous Topic: Oracle DB move from Linux server running 9i to a windows server running 10g
Next Topic: Apply archive log in physical standby slow
Goto Forum:
  


Current Time: Thu Dec 08 01:52:57 CST 2016

Total time taken to generate the page: 0.11452 seconds