Cold backup from 10g Enterprise to 10g Express
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Cold backup from 10g Enterprise to 10g Express

  1. #1
    Join Date
    Nov 2008
    Posts
    1

    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.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width