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).
