Home » RDBMS Server » Backup & Recovery » Determine whether a datafile backup is valid (
Determine whether a datafile backup is valid [message #302381] Mon, 25 February 2008 07:24 Go to next message
Messages: 1
Registered: February 2008
Junior Member
we're a running a 10g database on solaris / Netapp (NFS mounts). We do regular online backups using
1. alter database begin backup
2. issue a netapp snapshot command
3. alter database end backup.
Now, being in the need of a restore, we copied all datafile from the snapshot to their original locations and startet the recovery.
Oracle immediately complained that all 5 undo datafile were made not being in online backup mode while all other ~25 datafile were fine. We then used the undo backup of the day before, which worked.

We're now wondering whether our backups are valid at all. The procedure is fine. Is there a chance to detemine whether the datafiles in the snapshot have the online-backup-flags set or not? Oracle suggested to restore every backup one after the other and do a test recover -- but this is a hugh amount of work.

Has anyone a little tool that dumps the file header in readable form or is able to tell where in the file header the online-backup-flags is located?

Re: Determine whether a datafile backup is valid [message #305277 is a reply to message #302381] Mon, 10 March 2008 05:22 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
It would be easy to write such a tool provided you can find documentation about the file header block layout. If not, you will have to do it the hard way.
Re: Determine whether a datafile backup is valid [message #306012 is a reply to message #305277] Wed, 12 March 2008 10:02 Go to previous message
Messages: 75
Registered: February 2005
Is there a way of verifying the usefulness of the files that were copeied using the OS copy command? something like the validate command in RMAN?
Previous Topic: Recovering data from corrupted DMP file
Next Topic: Maintaing the archieve log
Goto Forum:

Current Time: Fri Oct 28 05:39:06 CDT 2016

Total time taken to generate the page: 0.14573 seconds