Home » RDBMS Server » Backup & Recovery » Determine whether a datafile backup is valid (10.2.0.3)
Determine whether a datafile backup is valid [message #302381] Mon, 25 February 2008 07:24 Go to next message
agadir
Messages: 1
Registered: February 2008
Junior Member
Hi,
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?

TIA
Stephan
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
kudur_kv
Messages: 75
Registered: February 2005
Member
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: Thu Dec 08 00:41:50 CST 2016

Total time taken to generate the page: 0.06628 seconds