Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Cloning Problems

Cloning Problems

From: Post, Ethan <>
Date: Mon, 29 Jul 2002 08:48:48 -0800
Message-ID: <>

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

Please see the official ORACLE-L FAQ:
Author: Post, Ethan

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: (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 - 11:48:48 CDT

Original text of this message