Did you recover the database using backup controlfile? Try that. HTH, Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 29, 2002 12:48 PM
> Having some trouble cloning a database. The database was shutdown with the > immediate option and all file where copied to new location. I usually > shutdown immediate, open then shutdown normal myself but this was outside my > control. I did the standard stuff with the trace file, reset logs > etc...done this many times before. When I tried to open the database with > the resetlogs option it told me I needed to do recovery. I have been doing > this a lot lately with hot files so recovery is usually required but it has > been a while since I have used cold files. Any ideas what I have done wrong > here? Was it the shutdown immediate? My bet is if I had switched through > the redo logs before the shutdown I probably wouldn't have this problem but > I also thought that the shutdown immediate would have issued a checkpoint > and all the changes in the redo would have been made to the datafiles. > Thanks! > > 10:15:55 SQL> 10:15:55 SQL> alter database open; > alter database open > * > ERROR at line 1: > ORA-01589: must use RESETLOGS or NORESETLOGS option for database open > > > 10:16:05 SQL> alter database open resetlogs; > alter database open resetlogs > * > ERROR at line 1: > ORA-01194: file 1 needs more recovery to be consistent > ORA-01110: data file 1: '/db04/oracle/DM8/system01.dbf' > > > 10:16:12 SQL> recover database using backup controlfile until cancel > ORA-00279: change 1806063 generated at 07/25/2002 05:18:01 needed for thread > 1 > ORA-00289: suggestion : /archive/DM8arch_0001_0000000095.dbf > ORA-00280: change 1806063 for thread 1 is in sequence #95 > > > 10:16:28 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} > > ORA-00308: cannot open archived log '/archive/DM8arch_0001_0000000095.dbf' > ORA-27037: unable to obtain file status > SVR4 Error: 2: No such file or directory > Additional information: 3 > > > ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error > below > ORA-01194: file 1 needs more recovery to be consistent > ORA-01110: data file 1: '/db04/oracle/DM8/system01.dbf' > > > 10:16:36 SQL> exit > Disconnected > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Post, Ethan > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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).