How do you verify and validate the Datafile which is backed up?

Questions by prakashpichika   answers by prakashpichika

Showing Answers 1 - 11 of 11 Answers

Abhilash

  • Oct 3rd, 2006
 

use dbverify to validate the backups.thanks

  Was this answer useful?  Yes

prakashpichika

  • Oct 3rd, 2006
 

The DBVERIFY Utility

An OS executable (dbv in $ORACLE_HOME/bin) used to verify datafiles

Works against datafiles, live or backup, But doesnot work on Backup sets...

Works for datafiles on raw devices but you must give it a range of blocks to look at.

In the output, it refers to blocks as ?pages?. Block 5 would be page 5.

RMAN performs its own validation when backing up so dbv is not necessary. It can be used on user backups (aka non-RMAN backups).

If a block is ?influx? then DBV was forced to check it multiple times because it was in use.

Its most asked Interview Question!

Ravi Prakash

http://ravidba-oracle.blogspot.com/

  Was this answer useful?  Yes

Mohammed Abdul Afroze

  • Oct 4th, 2007
 

To verify that the datafile is particularly backed up or not.

Sql>select * from v$backup-->This will shows the status of a particular file.
sql>select * from v$recover_file-->This is show whether any file has to be recovered.

pakusno

  • Feb 5th, 2010
 

Use RMAN Backup validate database.

It will performs a validation of the datafiles by checking for logical and physical block corruption.
No backupsets are created. 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions