cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot do "end backup"

0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Sri,

Try this SQL command under SQLPLUS:

alter tablespace SYSTEM end backup;

Good luck!

Serhat

JamesZ
Advisor
Advisor
0 Kudos

Hi Harsha,

Can you please share the oracle alert log?

I think the database would be fine. Because oracle has very strict rule to do the recovery, everything in the recovery must be continuous. The only thing you need to care is what timestamp your database was recovered to.

Best regards,

James