Re: Oracle Recovery

When you did your previous recovery, how did you open the database? With RESETLOGS?
> Can I roll forward logs accross a previous recovery. The previous
> recovery initiated was not what I needed and I need to go back
> further, restore the data files, and then roll forward the logs
> accross the previous recovery.

If you opened the database normally, then you can restore the file(s) you need to from your previous backup and simply apply recovery again.

If you opened the database with RESETLOGS, then your current database is a different incarnation and the old backups from the previous incarnation cannot be used. This is why a full backup should be taken immediately after opening a database with RESETLOGS.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"