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@xxxxxxxxxxx> 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> >