Cold DB copy-- Create controlfile error

From: Bala <oratips_at_gmail.com>
Date: Mon, 28 May 2007 08:28:03 -0400
Message-ID: <9ea7ad870705280528y70d61334va7cbc4a433e36ac@mail.gmail.com>

Cloning a Instance using Cold database backup

Create controlfile script errors out with the message
--

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed
ORA-01189: file is from a different RESETLOGS than previous files
ORA-01110: data file 25: '/oracle/SID/oradata/users01.dbf'

Oracle 9.2.0.6 on Solaris 2.9
does this mean the file should be not part of the controlfile creation script ? how to get around this ?. the timestamp of the file is 2 months ago. ?? Database was shutdown and backup taken yesterday - 5/27/07

Thanks for your time and any pointers
Bala --

--

Bala Rao

--

http://www.freelists.org/webpage/oracle-l Received on Mon May 28 2007 - 07:28:03 CDT