Skip to Content
1
Aug 05, 2015 at 08:26 PM

Cannot do "end backup"

16 Views

Hi Guru's

Need some help here.Online Flashcopy backup was triggered from DB13 and it was successful.then the backup team will mount it on the validating server we have to validate the backup in mount mode by doing a recovery.ive started sqlplus and kept the db in mount mode and started command 'alter database end backup '.it was not successful .the output of the command was 'data file is an old version - not accessing current version'

i bypassed the message and caaried on with the recovery command "RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL ;" and given "AUTO" .it recovered what files need to, and came out of the session.so then before doing the actual recovery ive tried again giving "alter database end backup" which was successfull and ended with "database altered".then ive carried on doing the recovery again ,this time giving the latest redo log,which got applied and recovery was succesful.but my question is im not too sure about the procedure ive followed is correct or not.as this is on a production environment im bit nervous.

Need your valuable suggestions.

Thankyou,

Harsha