OraFAQ Forum: Backup & Recovery » How to check backup is proper or not

Home » RDBMS Server » Backup & Recovery » How to check backup is proper or not

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

How to check backup is proper or not [message #135868]

Sat, 03 September 2005 08:18

dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore

Member

Hi,

After taking full database backup using rman, how to check its proper backup or not? Is there any way to find rman utility has taken backup of the database properly?

Thanks,
Praveen

Report message to a moderator

Re: How to check backup is proper or not [message #135872 is a reply to message #135868]

Sat, 03 September 2005 11:19

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can validate it.
http://oraclesvca2.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmquick.htm#441284

But, in reality, the only way to test the backup is to restore it.
For that very same reason, we always test our backup, randomly by duplicating/restoring to a remote machine.

Report message to a moderator

Re: How to check backup is proper or not [message #137787 is a reply to message #135872]

Fri, 16 September 2005 15:43

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

As per the oracle documentation we can check the validity of backup data file by using dbverify utility.

D:\oracle\ora92\bin>dbv FILE=D:\oracle\oradata\hclsunil\backup.dbf blocksize=8192 feedback=100

Always Your Friend
sunil

Report message to a moderator

Previous Topic:	Rman target and catalog
Next Topic:	errror message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:17:56 CDT 2024