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

GeekInterview.com > Interview Questions > Oracle > Backup and Recovery

Go To First | Previous Question | Next Question

Backup and Recovery | Question 21 of 37

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

Total Answers and Comments: 4

Last Update: June 05, 2008 Asked by: prakashpichika

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 03, 2006 04:01:26

Abhilash

RE: How do you verify and validate the Datafile which ...

use dbverify to validate the backups.thanks

Is this answer useful? Yes | No

0 1

Overall Rating: -1

October 03, 2006 05:22:25

prakashpichika

Member Since: June 2006 Contribution: 12

RE: How do you verify and validate the Datafile which ...

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/

Is this answer useful? Yes | No

October 04, 2007 06:54:23

Mohammed Abdul Afroze

RE: How do you verify and validate the Datafile which ...

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.

Is this answer useful? Yes | No

June 05, 2008 17:45:41

fmiao

Member Since: June 2008 Contribution: 1

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

in rman list recoverable backup of database

Is this answer useful? Yes | No

Go To Top