Did you recover the database using backup controlfile? Try that.
HTH,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
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: Ethan.Post_at_ps.net
>
> 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: ListGuru_at_fatcity.com (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: rgramolini_at_tax.state.vt.us
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: ListGuru_at_fatcity.com (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).
Received on Mon Jul 29 2002 - 12:59:15 CDT
