could not get database running normally
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: could not get database running normally

  1. #1
    Join Date
    Jun 2006
    Location
    Philippines
    Posts
    4

    could not get database running normally

    hi,

    i'm running oracle 8.0.5.

    whenever i start my database, i have the following entries in my alert log:

    Code:
    Starting up ORACLE RDBMS Version: 8.0.5.0.0.
    System parameters with non-default values:
      processes                = 100
      shared_pool_size         = 8000000
      control_files            = C:\orant\DATABASE\ctl1ORCL.ora
      db_block_buffers         = 30000
      db_block_size            = 2048
      log_buffer               = 3276800
      log_checkpoint_interval  = 10000
      db_files                 = 1024
      db_file_multiblock_read_count= 32
      sequence_cache_entries   = 30
      sequence_cache_hash_buckets= 23
      remote_login_passwordfile= SHARED
      global_names             = TRUE
      distributed_lock_timeout = 300
      distributed_transactions = 5
      open_links               = 4
      db_name                  = ORCL
      text_enable              = TRUE
      job_queue_processes      = 2
      job_queue_interval       = 10
      job_queue_keep_connections= FALSE
      parallel_max_servers     = 5
      background_dump_dest     = %RDBMS80%\trace
      user_dump_dest           = %RDBMS80%\trace
      max_dump_file_size       = 10240
    PMON started with pid=2
    DBW0 started with pid=3
    SMON started with pid=6
    RECO started with pid=7
    SNP0 started with pid=8
    SNP1 started with pid=9
    Tue Jun 27 17:35:02 2006
    alter database  mount
    LGWR started with pid=4
    CKPT started with pid=5
    Tue Jun 27 17:35:08 2006
    Successful mount of redo thread 1, with mount id 1122022988.
    Tue Jun 27 17:35:08 2006
    Database mounted in Exclusive Mode.
    Completed: alter database  mount
    Tue Jun 27 17:35:08 2006
    alter database open 
    Beginning crash recovery of 1 threads
    Recovery of Online Redo Log: Thread 1 Group 4 Seq 222456 Reading mem 0
      Mem# 0 errs 0: C:\ORANT\DATABASE\LOG1ORCL.ORA
    Crash recovery completed successfully
    Tue Jun 27 17:35:09 2006
    Thread 1 advanced to log sequence 222457
    Thread 1 opened at log sequence 222457
      Current log# 1 seq# 222457 mem# 0: C:\ORANT\DATABASE\LOG4ORCL.ORA
    Successful open of redo thread 1.
    Tue Jun 27 17:35:10 2006
    SMON: enabling cache recovery
    SMON: enabling tx recovery
    ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (5, 19) 
    
    on object 4826.
    Tue Jun 27 17:35:11 2006
    Errors in file C:\orant\RDBMS80\trace\orclSMON.TRC:
    ORA-00376: file 5 cannot be read at this time
    ORA-01110: data file 5: 'E:\DATA\ERICDATA'
    with these errors, i could not do any query to my database (ERICDATA) but can see the tables and desc on each table.

    is there a way i can recover my database? the database is running in NO ARCHIEVLOG.

    in addition, my datafile has a "RECOVER" status even after i do an OFFLINE DROP prior to opening the database.
    Last edited by nyagi; 06-28-2006 at 05:17 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    do you have a valid cold backup?

  3. #3
    Join Date
    Jun 2006
    Location
    Philippines
    Posts
    4
    unfortunately.. none. :(

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well you are screwed then, your data is gone - unless you pay oracle a lot of money to use their data unload tool to scrape out the data from the datafile

  5. #5
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Looks like the whole directory is screwed ORA-01110: data file 5: 'E:\DATA\ERICDATA'

    unless of course you named the actual file ericdata which in that case if you did I'd like to know what you were thinking?

    Hey Davey lets say hypothetically this poor sod did name his datafile "ericdata" and the data in that datafile was hypothetically expendable, then he could hypothetically take the datafile off line and blow it away. hypothetically speaking of course.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  6. #6
    Join Date
    Sep 2001
    Posts
    163
    Is there anymore to the error message besides

    Tue Jun 27 17:35:11 2006
    Errors in file C:\orant\RDBMS80\trace\orclSMON.TRC:
    ORA-00376: file 5 cannot be read at this time
    ORA-01110: data file 5: 'E:\DATA\ERICDATA'

    Where is this file? Can you physically see the file from the OS?

  7. #7
    Join Date
    Jun 2006
    Location
    Philippines
    Posts
    4
    just to clarify... this database was just handed down to me. i've been working with this database for the past week. i dont know what the former dba did to this database!

    anyway, ERICDATA is the datafile used. the file is physically visible in the OS. i know its screwed up, just hoping that we can retrieve the data in the said datafile. i was thinking of dropping the tablespace and recreate it just so the application using it will run. am i thinking it right?

    thanks!

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no you are not, the data is gone

  9. #9
    Join Date
    Jun 2006
    Posts
    259
    Davey23uk... the data is gone.

    At least until you perform media recovery. And since you're in no archive log mode, Media recovery is impossible. Hence the data is gone.

    How important is the data? I may be able to perform a partial/incomplete extract of the data from the raw datafile. Please PM, if you are interested in this.

    Ken

  10. #10
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    How important is the data? I may be able to perform a partial/incomplete extract of the data from the raw datafile. Please PM, if you are interested in this.
    And what is the hourly rate for this work?

    Tamil

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