DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: ORA-01092: ORACLE instance terminated.

  1. #1
    Join Date
    Jan 2007
    Posts
    231

    ORA-01092: ORACLE instance terminated.

    hi,

    i have clone a database from test to newDB created pfile,moved all log files,dbf files (except one dbf file) to clone location.created a controlfile and opened in resetlog it forced to disconnection.
    Again i logged as sysdba mounted then opened it asked for recovery then recoved successfully.when i tried to open it again disconnected.

    Code:
    SQL> startup mount pfile=/opt/ora9/admin/clone/pfile/initnew.ora
    ORACLE instance started.
    
    Total System Global Area  135337420 bytes
    Fixed Size                   452044 bytes
    Variable Size             109051904 bytes
    Database Buffers           25165824 bytes
    Redo Buffers                 667648 bytes
    Database mounted.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: '/opt/ora9/admin/clone/sys01.dbf'
    
    
    SQL> recover database;
    Media recovery complete.
    
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced
    This is my alert log Message.

    Mon Mar 17 12:10:34 2008
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    SCN scheme 2
    Using log_archive_dest parameter default value
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    Starting up ORACLE RDBMS Version: 9.2.0.4.0.
    System parameters with non-default values:
    processes = 150
    timed_statistics = TRUE
    shared_pool_size = 50331648
    large_pool_size = 8388608
    java_pool_size = 33554432
    control_files = /opt/ora9/admin/clone/control01.ctl, /opt/ora9/admin/clone/control02.ctl
    db_block_size = 8192
    db_cache_size = 25165824
    compatible = 9.2.0.0.0
    db_file_multiblock_read_count= 16
    fast_start_mttr_target = 300
    undo_management = AUTO
    undo_tablespace = UNDOTBS1
    undo_retention = 10800
    remote_login_passwordfile= EXCLUSIVE
    db_domain =
    instance_name = new
    dispatchers = (PROTOCOL=TCP) (SERVICE=newXDB)
    job_queue_processes = 10
    hash_join_enabled = TRUE
    background_dump_dest = /opt/ora9/admin/bdump
    user_dump_dest = /opt/ora9/admin/udump
    core_dump_dest = /opt/ora9/admin/cdump
    sort_area_size = 524288
    db_name = new
    open_cursors = 300
    star_transformation_enabled= FALSE
    query_rewrite_enabled = FALSE
    pga_aggregate_target = 25165824
    aq_tm_processes = 1
    PMON started with pid=2
    LGWR started with pid=4
    DBW0 started with pid=3
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    CJQ0 started with pid=8
    QMN0 started with pid=9
    Mon Mar 17 12:10:35 2008
    starting up 1 shared server(s) ...
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
    Mon Mar 17 12:10:35 2008
    ALTER DATABASE MOUNT
    Mon Mar 17 12:10:39 2008
    Successful mount of redo thread 1, with mount id 2131011835.
    Mon Mar 17 12:10:39 2008
    Database mounted in Exclusive Mode.
    Completed: ALTER DATABASE MOUNT
    Mon Mar 17 12:10:47 2008
    ALTER DATABASE RECOVER database
    Mon Mar 17 12:11:10 2008
    Media Recovery Start
    Starting datafile 1 recovery in thread 1 sequence 5
    Datafile 1: '/opt/ora9/admin/clone/sys01.dbf'
    Starting datafile 2 recovery in thread 1 sequence 5
    Datafile 2: '/opt/ora9/admin/clone/undo01.dbf'
    Starting datafile 4 recovery in thread 1 sequence 5
    Datafile 4: '/opt/ora9/admin/clone/rman01.dbf'
    Media Recovery Log
    Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0
    Mem# 0 errs 0: /opt/ora9/admin/clone/redo01.log
    Media Recovery Complete
    Completed: ALTER DATABASE RECOVER database
    alter database open
    Mon Mar 17 12:27:48 2008
    Beginning crash recovery of 1 threads
    Mon Mar 17 12:27:48 2008
    Started first pass scan
    Mon Mar 17 12:27:48 2008
    Completed first pass scan
    1 redo blocks read, 0 data blocks need recovery
    Mon Mar 17 12:27:48 2008
    Started recovery at
    Thread 1: logseq 5, block 2, scn 0.456941
    Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0
    Mem# 0 errs 0: /opt/ora9/admin/clone/redo01.log
    Mon Mar 17 12:27:48 2008
    Completed redo application
    Mon Mar 17 12:27:48 2008
    Ended recovery at
    Thread 1: logseq 5, block 3, scn 0.476942
    0 data blocks read, 0 data blocks written, 1 redo blocks read
    Crash recovery completed successfully
    Mon Mar 17 12:27:48 2008
    Thread 1 advanced to log sequence 6
    Thread 1 opened at log sequence 6
    Current log# 2 seq# 6 mem# 0: /opt/ora9/admin/clone/redo02.log
    Successful open of redo thread 1.
    Mon Mar 17 12:27:48 2008
    SMON: enabling cache recovery
    Mon Mar 17 12:27:48 2008
    Errors in file /opt/ora9/admin/udump/new_ora_22889.trc:
    ORA-00600: internal error code, arguments: [25012], [0], [3], [], [], [], [], []
    Mon Mar 17 12:27:49 2008
    Errors in file /opt/ora9/admin/udump/new_ora_22889.trc:
    ORA-00704: bootstrap process failure
    ORA-00704: bootstrap process failure
    ORA-00600: internal error code, arguments: [25012], [0], [3], [], [], [], [], []
    Mon Mar 17 12:27:49 2008
    Error 704 happened during db open, shutting down database
    USER: terminating instance due to error 704
    Instance terminated by USER, pid = 22889
    ORA-1092 signalled during: alter database open...

    any clue to proceed further..,

    Thanks.,

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Check trace file /opt/ora9/admin/udump/new_ora_22889.trc
    Physical corruption is possible.
    I would open a TAR with Oracle.
    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.

  3. #3
    Join Date
    Jan 2007
    Posts
    231
    if i open that trace file new_ora_22889.trc.it runs nearly five screens then at last it shows as


    ..........
    ....
    AD9B720 00000000 00000000 00000000 00000000 [................]
    Repeat 30 times
    AD9B910 00000000 00000000 00000000 [............]
    qmxdplsuga * qmxdplsuga_p [AD9B91C, AD9B920) = 00000000
    qmpauga * qmpauga_p [AD9B920, AD9B924) = 00000000
    qmxtcug * qmxtcuga_p [AD9B924, AD9B928) = 00000000
    qsmguga * qsmgu_p [AD9B928, AD9B92C) = 00000000
    struct _xsawuga * xsawuga_p [AD9B92C, AD9B930) = 00000000
    struct _xsoquga * xsoquga_p [AD9B930, AD9B934) = 00000000
    ub4 ksmugmg2 [AD9B934, AD9B938) = 0000CDCD
    KSTDUMP: In-memory trace dump
    TIME:SEQ# ORAPID SID EVENT OP DATA
    ========================================================================
    A2473824:00000000 149 0 10280 1 0x00000095
    A2479A4F:00000001 2 0 10280 1 0x00000002
    A2480A4C:00000002 3 0 10280 1 0x00000003
    A2486070:00000003 4 0 10280 1 0x00000004
    A248D0A8:00000004 5 0 10280 1 0x00000005
    A249356C:00000005 6 0 10280 1 0x00000006
    A2499A03:00000006 7 0 10280 1 0x00000007
    A249F16C:00000007 8 0 10280 1 0x00000008
    A24A5593:00000008 9 0 10280 1 0x00000009
    A5CCDB77:0000000D 9 0 10280 1 0x00000009
    B75241E7:0000000E 9 0 10280 1 0x00000009
    C8D7AA75:0000000F 9 0 10280 1 0x00000009
    DA5D1160:00000010 9 0 10280 1 0x00000009
    DD75C537:00000011 9 0 10280 1 0x00000009
    A24AC6FE:00000009 10 0 10280 1 0x0000000A
    A24B1D97:0000000A 11 0 10280 1 0x0000000B
    A24B921A:0000000B 12 0 10280 1 0x0000000C
    A28918EA:0000000C 12 0 10280 1 0x0000000C
    KSTDUMP: End of in-memory trace dump
    ORA-00704: bootstrap process failure
    ORA-00704: bootstrap process failure
    ORA-00600: internal error code, arguments: [25012], [0], [3], [], [], [], [], []

    i tried for the next time the same process repeats..

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Code:
    ORA-00600: internal error code, arguments: [25012], [0], [3], [], [], [], [], []
    ...means you have a problem on tablespace #0, datafile #3
    Since tablespace #0 is usually SYSTEM tablespace I would say you might be in serious troubles.

    Physical corruption is possible.
    I would open a TAR with Oracle.
    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.

  5. #5
    Join Date
    Jan 2007
    Posts
    231
    Thanks Pavb,

    but i have moved all the .dbf files after clean shutdown and then created trace control file (restrict mode) edited then created, and that testDB also working fine now.only clone is making problem. whether there could be a problem that i have removed one datafile in clone DB(newDB).

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    How big is your database?
    If you are just cloning a test database you may want to start from scratch.
    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.

  7. #7
    Join Date
    Jan 2007
    Posts
    231
    its less than 2G only 4 datafiles.
    I have started twice from scratch but same error repeats.

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    I assume you have put source database tablespaces in backup mode before making a copy of them, am I correct?
    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.

  9. #9
    Join Date
    Jan 2007
    Posts
    231
    No,exactly not

    I had shutdown --> copied .log and .dbf (except one file)-->opened in restrict -->created a trace file -->edited recreated controlfile -->then tried to open with resetlogs.

  10. #10
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    it should work.
    may I ask why are you skipping one datafile?
    wouldn't be nicer to move the whole database?
    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