Cold backup from 10g Enterprise to 10g Express

Hi,

I have been trying to clone the database on 10g Enterprise edition to 10g Express edition. I have taken the cold backup, copied the datafiles and redo logs over to new machine and using the trace file created through the command "database backup controlfile to trace;" created the control files on the new database.
Now, the database gets mounted but when I try to run "alter database open resetlogs;" it gives me the error that "file 1 needs more recovery" following which I run the command "recover database until cancel;" and apply the REDO01.LOG when asked.
This also succeds. But now if I try opening the database it gives me the error :
ORA-01092 - ORACLE instance terminated. Disconnection forced.

When I check the alert.log file, I get the following errors:


Sun Nov 02 15:10:43 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
Mem# 0 errs 0: C:\ORACLEXE\ORADATA\MDSL\REDO01.LOG
Sun Nov 02 15:10:43 2008
Completed redo application
Sun Nov 02 15:10:43 2008
Completed crash recovery at
Thread 1: logseq 1, block 3, scn 45626332
0 data blocks read, 0 data blocks written, 1 redo blocks read
Sun Nov 02 15:10:44 2008
Thread 1 advanced to log sequence 2
Thread 1 opened at log sequence 2
Current log# 2 seq# 2 mem# 0: C:\ORACLEXE\ORADATA\MDSL\REDO02.LOG
Successful open of redo thread 1
Sun Nov 02 15:10:45 2008
SMON: enabling cache recovery
Sun Nov 02 15:10:46 2008
Errors in file c:\oraclexe\app\oracle\admin\mdsl\udump\mdsl_ora_257748.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "EDITION": invalid identifier

Sun Nov 02 15:10:46 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Sun Nov 02 15:10:46 2008
Errors in file c:\oraclexe\app\oracle\admin\mdsl\bdump\mdsl_pmon_257824.trc:
ORA-00704: bootstrap process failure


the mdsl_ora_257748.trc contains:

Dump file c:\oraclexe\app\oracle\admin\mdsl\udump\mdsl_ora_257748.trc
Sun Nov 02 15:10:12 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1662M/2551M, Ph+PgF:1751M/3150M, VA:1316M/2047M
Instance name: mdsl

Redo thread mounted by this instance: 1

Oracle process number: 15

Windows thread id: 257748, image: ORACLE.EXE (SHAD)


*** 2008-11-02 15:10:12.921
*** SERVICE NAME:() 2008-11-02 15:10:12.843
*** SESSION ID:(159.7) 2008-11-02 15:10:12.843
Recovery target incarnation = 4, activation ID = 0
Influx buffer limit = 26197 (50% x 52395)
Start recovery at thread 1 ckpt scn 45606330 logseq 1 block 2
*** 2008-11-02 15:10:13.031
Media Recovery add redo thread 1
*** 2008-11-02 15:10:21.562
Media Recovery Log C:\ORACLEXE\ORADATA\MDSL\REDO01.LOG
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 9.15s => 0.00 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/1 (0%)
Change moves: 0/1 (0%), moved: 0Mb
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0000.02b7e5bb (45606331)
----------------------------------------------
*** 2008-11-02 15:10:22.218
Media Recovery drop redo thread 1
File 1 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 2 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 3 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 4 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 5 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 6 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 7 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 8 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 9 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 10 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 11 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 12 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 13 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 14 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 15 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 16 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 17 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 18 (stop scn 45606332) completed recovery at checkpoint scn 45606332
File 19 (stop scn 45606332) completed recovery at checkpoint scn 45606332
KCBR: Number of read descriptors = 4096
KCBR: Influx buffers flushed = 3 times
KCBR: Reads = 0 reap (0 no-op, 0 one), 6 all
*** 2008-11-02 15:10:42.984
Thread 1 checkpoint: logseq 1, block 2, scn 45606330
start recovery at logseq 1, block 2, scn 45606330
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 0.66s => 0.00 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/1 (0%)
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0000.02b7e5bb (45606331)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2008-11-02 15:10:43.750
KCRA: start recovery claims for 0 data blocks
*** 2008-11-02 15:10:43.765
KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
*** 2008-11-02 15:10:43.859
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "EDITION": invalid identifier


Can anybody please tell me what's this "EDITION": invalid identifier - error is? I have searched on google and I couldn't find anything on this.

I wouldn't even attempt to clone a 10g EE as 10g XE

If I remember it right Oracle XE has a 4 Gig disk space limitation therefore you are talking about a very small database. I would pre-create the database in XE then migrate the data via old-n-good exp/imp or expdp/impdp.