Greg, How did you do your hot backup? Did you do the following for each tablespace?:
alter tablespace <tbsname> begin backup; !cp datafile1 alter tablespace <tbsname> end backup; Mike >From: "Greg Faktor" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RECOVERY PROBLEM >Date: Wed, 06 Mar 2002 12:48:41 -0800 > >Hi All! >I'm trying recovery TEST database from hot backup. >I create database with a couple tables. Make couple log switches to >generate redo log files (basically it's generate 3 redo log files: >arch.log1_15.dbf >, arch.log1_16.dbf, arch.log1_17.dbf). >Then I run hot backup and backup all dbf files, redo log files, control >files and arch redo log files. Shutdown database and delete all files. >Then I restore all files from hot backup. Then I mount database and run: > >SVRMGR> recover database using backup control file until cancel; >ORA-00279: change 28494 generated at 03/06/02 13:19:24 needed for thread 1 >ORA-00289: suggestion : /u00/app/oracle/admin/TEST/arch/arch.log1_18.dbf >ORA-00280: change 28494 for thread 1 is in sequence #18 >Specify log: {<RET>=suggested | filename | AUTO | CANCEL} > >cancel > >ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error >below >ORA-01195: online backup of file 1 needs more recovery to be consistent >ORA-01110: data file 1: '/ff01uc31/ora_c15d05/TEST/oradata/system01.dbf' > >It's looking for arch.log1_18.dbf files, which is, was not they're when I >run my hot backup. >Any ideas what I did wrong? > >Thanks a lot. >Oracle 8.1.5 on Digital Unix > >Greg. > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Greg Faktor > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).