Cannot open db - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 38

Thread: Cannot open db

  1. #21
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,014
    Originally posted by itwizzkid
    It's exactly what Iam saying. I recover all the datafiles. When I attempt to open the database, I get SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced.

    I then start the db mount.. alter database open; and get ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF'.

    I'm going round in cycles.
    Try going around in a few more cycles,
    and see if it allows you to open the database.

  2. #22
    Join Date
    Feb 2001
    Posts
    107
    Hi,

    I have tried this a few times.

    Database mounted.
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF'


    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF'
    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\CWMLITE01.DBF'
    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DRSYS01.DBF'
    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\EXAMPLE01.DBF'
    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\INDX01.DBF'
    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\ODM01.DBF'
    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\TOOLS01.DBF'
    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\USERS01.DBF'
    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\XDB01.DBF'
    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM120040519091720_DB.DBF'

    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DM_NTDISTRIB20040514033149_DB.DB
    F'
    Media recovery complete.
    SQL> recover datafile 'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM1_INDX1.ORA'
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced

  3. #23
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,014
    "recover database until cancel;", help it find any archive logs that that it needs, including pointing it to the online redor logs. When you get to a point where you can't find what it wants type "cancel", and then "open database resetlogs;"

  4. #24
    Join Date
    May 2001
    Posts
    736
    Final action what I can sujjest is to use _allow_resetlogs_corruption=TRUE

    Do as follows

    1.Shutdown the database.

    2. Add the following parameter in the init.ora file:

    _allow_resetlogs_corruption=TRUE

    3. Startup mount;

    4. Recover database using backup controlfile until cancel;

    5. If prompted for a logfile, type CANCEL.

    6. alter database open resetlogs;

    Since the database is in Noarchive mode this is the last option.u need to be careful while using _allow_resetlogs_corruption parameter as it may make ur database inconsistent.Since as per replies u only wants ur database open so u can use this option.

  5. #25
    Join Date
    Feb 2001
    Posts
    107

    Unhappy

    Hi,

    None of these have worked so far. I am well and truly scuppered.

  6. #26
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,014
    Originally posted by itwizzkid
    Hi,

    None of these have worked so far. I am well and truly scuppered.
    I really don't understand why you are still having problems.
    Is there another DBA that can have a look at the database?

  7. #27
    Join Date
    Feb 2001
    Posts
    107
    We have a couple of dba's on this. Every time we try to open the database we get:

    SQL> alter database open resetlogs;
    alter database open resetlogs
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced

    The alert log has the following entries:-
    Media Recovery Log
    ORA-279 signalled during: ALTER DATABASE RECOVER database using backup cont...
    Wed Oct 13 05:01:28 2004
    ALTER DATABASE RECOVER LOGFILE 'E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG'
    Wed Oct 13 05:01:28 2004
    Media Recovery Log E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG
    Incomplete recovery applied all redo ever generated.
    Recovery completed through change 14491308
    Media Recovery Complete
    Completed: ALTER DATABASE RECOVER LOGFILE 'E:\ORACLE\ORADA
    Wed Oct 13 05:02:38 2004
    alter database open resetlogs
    Wed Oct 13 05:02:38 2004
    RESETLOGS after complete recovery through change 14491308
    Resetting resetlogs activation ID 3724171580 (0xddfa593c)
    Online log 1 of thread 1 was previously cleared
    Wed Oct 13 05:02:48 2004
    Online log 3 of thread 1 was previously cleared
    Wed Oct 13 05:02:51 2004
    Assigning activation ID 3724197347 (0xddfabde3)
    Thread 1 opened at log sequence 1
    Current log# 2 seq# 1 mem# 0: E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG
    Successful open of redo thread 1.
    Wed Oct 13 05:02:52 2004
    SMON: enabling cache recovery
    Wed Oct 13 05:02:52 2004
    Errors in file c:\oracle\admin\train1\udump\train1_ora_2312.trc:
    ORA-00704: bootstrap process failure
    ORA-00604: error occurred at recursive SQL level 2
    ORA-08103: object no longer exists

    Wed Oct 13 05:02:52 2004
    Error 704 happened during db open, shutting down database
    USER: terminating instance due to error 704
    Wed Oct 13 05:02:52 2004
    Errors in file c:\oracle\admin\train1\bdump\train1_pmon_2636.trc:
    ORA-00704: bootstrap process failure

  8. #28
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,014
    Errors in file c:\oracle\admin\train1udump\train1_ora_2312.trc:
    ORA-00704: bootstrap process failure
    ORA-00604: error occurred at recursive SQL level 2
    ORA-08103: object no longer exists
    Have you looked at the "c:\oracle\admin\train1udump\train1_ora_2312.trc" file? Do you want to post it here? Is there another file that is missing? i.e. what do you think that "ORA-08103: object no longer exists" relates to?

  9. #29
    Join Date
    Feb 2001
    Posts
    107
    Hi,

    This is the train1_ora_2312.trc:-
    Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
    Mon Oct 11 06:25:25 2004
    ORACLE V9.2.0.1.0 - Production vsnsta=0
    vsnsql=12 vsnxtr=3
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Instance name: train1

    Redo thread mounted by this instance: 0

    Oracle process number: 12

    Windows thread id: 2312, image: ORACLE.EXE


    *** SESSION ID:(9.1) 2004-10-11 06:25:25.000
    (blkno = 0x8a, size = 276, max = 1, in-use = 0, last-recid= 0)
    (blkno = 0x8b, size = 56, max = 145, in-use = 0, last-recid= 0)
    Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
    Tue Oct 12 07:28:11 2004
    ORACLE V9.2.0.1.0 - Production vsnsta=0
    vsnsql=12 vsnxtr=3
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Instance name: train1

    Redo thread mounted by this instance: 1

    Oracle process number: 12

    Windows thread id: 2312, image: ORACLE.EXE


    *** SESSION ID:(9.3) 2004-10-12 07:28:11.000
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 34s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    *** 2004-10-12 07:30:21.000
    *** 2004-10-12 07:30:42.000
    ORA-00704: bootstrap process failure
    ORA-00604: error occurred at recursive SQL level 2
    ORA-08103: object no longer exists
    Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
    Tue Oct 12 07:33:11 2004
    ORACLE V9.2.0.1.0 - Production vsnsta=0
    vsnsql=12 vsnxtr=3
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Instance name: train1

    Redo thread mounted by this instance: 1

    Oracle process number: 12

    Windows thread id: 2312, image: ORACLE.EXE


    *** SESSION ID:(9.3) 2004-10-12 07:33:11.000
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 2s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 2s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 2s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 2s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 1s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    *** 2004-10-12 08:26:26.000
    KCRA: start recovery claims for 0 data blocks
    *** 2004-10-12 08:26:26.000
    KCRA: buffers claimed = 0/0, eliminated = 0
    ORA-00704: bootstrap process failure
    ORA-00604: error occurred at recursive SQL level 2
    ORA-08103: object no longer exists
    Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
    Wed Oct 13 04:52:20 2004
    ORACLE V9.2.0.1.0 - Production vsnsta=0
    vsnsql=12 vsnxtr=3
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Instance name: train1

    Redo thread mounted by this instance: 0

    Oracle process number: 12

    Windows thread id: 2312, image: ORACLE.EXE


    *** SESSION ID:(9.17) 2004-10-13 04:52:20.000
    Archiving is disabled
    Archiving is disabled
    Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
    Wed Oct 13 04:56:38 2004
    ORACLE V9.2.0.1.0 - Production vsnsta=0
    vsnsql=12 vsnxtr=3
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Instance name: train1

    Redo thread mounted by this instance: 0

    Oracle process number: 13

    Windows thread id: 2312, image: ORACLE.EXE


    *** SESSION ID:(9.3) 2004-10-13 04:56:38.000
    Archiving is disabled
    Archiving is disabled
    Dump file c:\oracle\admin\train1\udump\train1_ora_2312.trc
    Wed Oct 13 05:01:32 2004
    ORACLE V9.2.0.1.0 - Production vsnsta=0
    vsnsql=12 vsnxtr=3
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Instance name: train1

    Redo thread mounted by this instance: 1

    Oracle process number: 13

    Windows thread id: 2312, image: ORACLE.EXE


    *** SESSION ID:(9.3) 2004-10-13 05:01:32.000
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC) = 0Kb/sec => 1 blocks in 30s
    Read buffer = 8192Kb (16384 blocks)
    Longest record = 0Kb
    Record moves = 0/1 (0%)
    ----------------------------------------------
    *** 2004-10-13 05:02:38.000
    ORA-00704: bootstrap process failure
    ORA-00604: error occurred at recursive SQL level 2
    ORA-08103: object no longer exists

    I think that ORA-08103: object no longer exists refers to the undo tablespace.

    regards

  10. #30
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,014
    Ok, do a "alter batabase backup control file to trace;", while the databas eis mounted. Go find the file in the c:\oracle\admin\train1\bdump, or something like it, directory, rename it to something meaningful and post it here.

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