Re: Restore question
Date: Wed, 31 Dec 2008 15:11:46 -0500
Yes. Standard incomplete PITR of Datafile(s). Check the Backup and Recovery Advanced User's Guide at
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm. Mount the database and start RMAN (connect to catalog if you have one - a current controlfile before the disaster works just as well - it has all the info). If you know the file(s) that were lost, restore those, then recover using the SET UNTIL clause. You'll have to open with resetlogs and immediately take a backup.
On Wed, Dec 31, 2008 at 2:51 PM, J. Dex <cemail_219_at_hotmail.com> wrote:
> Is it possible to restore from a hot backup that was taken prior to a
> database being shutdown. We had an RMAN hot backup running in archivelog
> mode. The database was shutdown and them some files are lost before it was
> restarted Isn't it possible to just point to the oldest controlfile that
> was taken during the last hot backup and restore from that?
> Send e-mail anywhere. No map, no compass. Get your Hotmail(R) account now.<http://windowslive.com/oneline/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_anywhere_122008>