DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: redo log files

  1. #1
    Join Date
    Jan 2007
    Posts
    1

    redo log files

    hi:

    I am having a problem when i try to start the database. The problem is as:

    ----------------------
    SQL> startup
    ORACLE instance started.

    Total System Global Area 239075328 bytes
    Fixed Size 788308 bytes
    Variable Size 212596908 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 524288 bytes
    Database mounted.
    ORA-16038: log 3 sequence# 2329 cannot be archived
    ORA-00227: corrupt block detected in controlfile: (block , # blocks )
    ORA-00312: online log 3 thread 1: 'E:\ORACLE\ORADATA\ORACLE1\REDO03.LOG'


    ---


    do i need to drop the log files and create once again.. if yes how do i proceed? or what is the best way to get rid of this problem?

    Note: db wasnot shutdown properly.

    Thanks in adv
    Paras.

  2. #2
    Join Date
    Jan 2007
    Posts
    14
    Always mirror your redo log to avoid such problem. Recover your database to a point in time before the error.

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