Online Rego-log
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Online Rego-log

  1. #1
    Join Date
    Jan 2001
    Posts
    153

    Red face Online Rego-log

    NEED AN URGENT HELP BOSS..

    These are the setups and error messages and it is not in archive mode.

    NOS : Novel Netware 5.1

    Oralce : version no is 8.1.7

    Message :

    00314 : log 1 of thread 1 , expected sequence # 40683 doesn't match # 40685

    00312 : online log 1 thread 1 : '%path%' log2orcl.ora

    system is asking for a immediate recovery of the logfile


    i could able to issue STARTUP MOUNT...



    My alter log..

    Fri Mar 14 19:54:40 2003 -
    ALTER DATABASE DISMOUNT
    Completed: ALTER DATABASE DISMOUNT
    archiving is disabled
    Starting up ORACLE RDBMS Version: 8.1.7.2.0.
    System parameters with non-default values:
    processes = 600
    timed_statistics = FALSE
    shared_pool_size = 67108864
    control_files = ORABACK:\OraHome1\ORADATA\ORACLE\ctl1orcl.ora
    db_block_buffers = 2000
    db_block_size = 2048
    compatible = 8.1.0.0.0
    log_buffer = 8192
    log_checkpoint_interval = 10000
    db_files = 1024
    db_file_multiblock_read_count= 8
    remote_login_passwordfile= SHARED
    global_names = TRUE
    db_name = oracle
    open_cursors = 400
    os_authent_prefix =
    job_queue_processes = 1
    parallel_max_servers = 5
    background_dump_dest = ORABACK:\OraHome1\ADMIN\ORACLE\BDUMP
    user_dump_dest = ORABACK:\OraHome1\ADMIN\ORACLE\UDUMP
    max_dump_file_size = 10240
    PMON started with pid=2
    DBW0 started with pid=3
    LGWR started with pid=4
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    SNP0 started with pid=8
    Sat Mar 15 10:44:32 2003 -
    alter database mount
    Sat Mar 15 10:44:36 2003 -
    Successful mount of redo thread 1, with mount id 1361783764.
    Sat Mar 15 10:44:36 2003 -
    Database mounted in Exclusive Mode.
    Completed: alter database mount
    Sat Mar 15 10:44:36 2003 -
    alter database open
    Beginning crash recovery of 1 threads
    Sat Mar 15 10:44:36 2003 -
    Thread recovery: start rolling forward thread 1
    Sat Mar 15 10:44:36 2003 -
    Errors in file ORABACK:\OraHome1\ADMIN\ORACLE\UDUMP\00000248.TRC:
    ORA-00314: log 1 of thread 1, expected sequence# 40683 doesn't match 40685
    ORA-00312: online log 1 thread 1: 'ORABACK:ORAHOME1\ORADATA\ORACLE\LOG2ORCL.ORA'

    ORA-314 signalled during: alter database open ...

    Rgds
    Vijay.s

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Try this,

    Query using

    select first_change#, member from v$log a, v$logfile b
    where a.Group#=b.Group#
    order by 1
    /

    From the output of the query, you can findout which logfile contains the required sequence #. Supply this logfile at the prompt of media recovery. (recover database).

    Pls do follow the requierd steps before starting the activity, like taking a backup of the database, backup controlfile to trace etc.
    -nagarjuna

  3. #3
    If he can clear the logfile , it should be ok.
    Or, try recreate the controlfile, if it is just because controlfile and redo log are inconsistent.

    If neither of the above steps work, he have to restore full db and do incomplete recovery, and open resetlogs that database.
    www.cnoug.org

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    quoted from asktom.oracle.com for your same post

    Reviewer: Vj from india

    These are the setups and error messages and it is not in archive mode.

    NOS : Novel Netware 5.1
    Oracle : version no is 8.1.7

    Message :

    00314 : log 1 of thread 1 , expected sequence # 40683 doesn't match # 40685

    00312 : online log 1 thread 1 : '%path%' log2orcl.ora

    system is asking for a immediate recovery of the logfile

    PLEASE HELP


    i could able to startup mount.

    Rgds


    Followup:
    contact support. insufficient data -- don't panic, file a tar.




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