Help needed making a DB copy

From: Vince Laurent <eAddict_at_yahoo.com>
Date: Tue, 16 Mar 2004 12:13:46 -0600
Message-ID: <msge50ltk1rtbfv0ei3r6ilnmrtmojbjhg@4ax.com>

Help! I am trying to clone one database to another and I am running into a brick wall.

1. On source did a: ALTER DATABASE BACKUP CONTROLFILE TO TRACE RESETLOGS;
2. Shutdown source
3. Did a file system backup (source) then restore to target system
4. Modified the trace file info old_sid to new_sid, directories, etc.
5. Changed all the external stuf to the new sid (ie tns)
6. On target system: startup mount @tracefile alter database open resetlogs; At which point I get: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1:
   '/oracle/SND/sapdata2/system_1/system.data1'
   

How can they be inconsistant when they were copied when the DB was down? I even tried a

        recover database until cancel using backup controlfile; but only ended up with

        ORA-00279: change 109582288 generated at 03/16/2004 11:01:21 needed for thread 1

	ORA-00289: suggestion : /oracle/SND/saparch/SNDarch1_2.dbf
	ORA-00280: change 109582288 for thread 1 is in sequence #2
	Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
	cancel
	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:

'/oracle/SND/sapdata2/system_1/system.data1'

Why does the DB think this file is inconsistant? Did I do something out of order to get a clean copy?

Thanks!
Vince
(p.s. Oracle 9.2.0.4 on HP-UX 11i)

---

Come race with us!
www.mgpmrc.org Received on Tue Mar 16 2004 - 12:13:46 CST