| Determine whether a datafile backup is valid [message #302381] |
Mon, 25 February 2008 07:24  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
