OraFAQ Forum: Backup & Recovery » Verify Success of DB Backups

Home » RDBMS Server » Backup & Recovery » Verify Success of DB Backups (Oracle 10g, Sun Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Verify Success of DB Backups [message #436160]

Mon, 21 December 2009 22:11

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

Report message to a moderator

Re: Verify Success of DB Backups [message #436161 is a reply to message #436160]

Mon, 21 December 2009 22:26

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Verify Success of DB Backups [message #436170 is a reply to message #436161]

Tue, 22 December 2009 00:16

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

Report message to a moderator

Re: Verify Success of DB Backups [message #436172 is a reply to message #436170]

Tue, 22 December 2009 00:22

ramoradba
Messages: 2456
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

Report message to a moderator

Re: Verify Success of DB Backups [message #436201 is a reply to message #436160]

Tue, 22 December 2009 01:47

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If it is a RMAN backup execute the RESTORE VALIDATE command.

Regards
Michel

Report message to a moderator

Re: Verify Success of DB Backups [message #436258 is a reply to message #436160]

Tue, 22 December 2009 08:23

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 17:55:27 CDT 2024