Restoring An Oracle Database 1

[MrBass]

I'm attempting to restore an Oracle database from a previous nights backup and then roll forward to any time during the current day. I've restored the datafiles and redo log files, started the database in mount mode and used the RECOVER DATABASE UNTIL TIME 'yyyy-mm-dd:hh:mm:ss; command to roll the database forward to a specific time. This starts off working fine, I get prompted to apply several archive logs, which I do, then after a while I get an error message similar to the following:

ORA-00314: log 2 of thread 1, expected sequence# 878 doesn't match 774
ORA-00312: online log 2 thread 1: 'E:\ORALIVE\REDOLOGS\LOGLIVE2.ORA'

Does anybody know what is causing this and how I can get around it???

 

[carp]

This sounds like your redo log file didn't get archived. Consequently, when the recovery process goes to the next log group, it finds an older redo log sequence then it's supposed to.

 

[karluk]

I think it was a mistake to restore the redo logs from last night's backup. The backup can't possibly have a record of today's activity. Any redo log data past the point of the last archive log will be lost, so the creation time of the last archive log is the latest you will be able to recover.

To recover to that point, I would use the "recover database until cancel" syntax.