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

Thread: could not get database running normally

Threaded View

  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.

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