Cold DB copy-- Create controlfile error

  • From: Bala <oratips@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 28 May 2007 08:28:03 -0400

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

Other related posts: