Redo Log Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Redo Log Error

  1. #1
    Join Date
    Jan 2001
    Posts
    153

    Red face Redo Log Error

    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


    Rgds
    Vijay.s

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Re: Redo Log Error

    Any other messages in Oracle database alert log ? If not, why do you care anyway its NOT in ARCHIVE MODE.
    Reddy,Sam

  3. #3
    Join Date
    Jan 2001
    Posts
    153
    sdreddy,

    IN MY alter log also it is showing the same..

    I COULD start the database in STARTUP MOUNT...But if i issue ALTER DATABASE OPEN it is throwing this error, also if i issue SWITCH also it is throwing same error..

    can you give me a steps of what i should i do to bring back my database.

    urgent pls.

    Rgds
    Vijay.s

  4. #4
    Join Date
    Jan 2001
    Posts
    153
    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 ...
    Vijay.s

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