10 Replies Latest reply on Mar 19, 2013 5:21 AM by Danish297

    ORA-00257: archiver error. Connect internal only, until freed.

    Danish297
      Hi,

      I am frequently (every 30 min )getting below error since last 5 days.

      I added 1 redolog group for workaround and manually switch the logfile.

      please help me to fix it permanently as its on PRODUCTION.

      ERROR:
      ORA-00257: archiver error. Connect internal only, until freed.

      SQL> select * from v$log;

      GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
      ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
      1 1 2306 52428800 512 1 NO INACTIVE 58398894 18-MAR-13 58402268 18-MAR-13
      2 1 2300 52428800 512 1 NO INACTIVE 58008599 15-MAR-13 58055544 15-MAR-13
      3 1 2305 52428800 512 1 NO INACTIVE 58378367 18-MAR-13 58398894 18-MAR-13
      4 1 2307 52428800 512 1 NO INACTIVE 58402268 18-MAR-13 58405307 18-MAR-13
      5 1 2308 52428800 512 1 NO CURRENT 58405307 18-MAR-13 2.8147E+14

      SQL>

      SQL> show parameter log_archive_dest_1

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      log_archive_dest_1 string LOCATION=E:\app\Administrator\
      product\11.2.0\CADSDB1\Archive
      log_archive_dest_10 string
      log_archive_dest_11 string


      SQL> show parameter log_archive_format

      NAME TYPE VALUE
      ------------------------------------ ----------- ----------------------------
      log_archive_format string ARC%S_%R.%T
      SQL> show parameter log_archive_

      log_archive_local_first boolean TRUE
      log_archive_max_processes integer 4
      log_archive_min_succeed_dest integer 1
      log_archive_start boolean FALSE
      log_archive_trace integer 0
        • 1. Re: ORA-00257: archiver error. Connect internal only, until freed.
          asahide
          Hi,

          What is DB_RECOVERY_FILE_DEST_SIZE ?
          And show us alert log file.

          Regards,
          • 2. Re: ORA-00257: archiver error. Connect internal only, until freed.
            Danish297
            Hi thanx for your reply.

            only 3912M

            SQL> show parameter dest_size

            NAME TYPE VALUE
            ------------------------------------ ----------- ------------
            db_recovery_file_dest_size big integer 3912M
            • 3. Re: ORA-00257: archiver error. Connect internal only, until freed.
              asahide
              Hi,

              Can you increase this parameter?

              And if you can put your alert log here.

              Regards,
              • 4. Re: ORA-00257: archiver error. Connect internal only, until freed.
                Danish297
                below is the alert.log file.

                ARC3: Log corruption near block 38016 change 58036209 time ?
                CORRUPTION DETECTED: thread 1 sequence 2300 log 2 at block 38016. Arch found corrupt blocks
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc3_4652.trc (incident=46176):
                ORA-00353: log corruption near block 38016 change 58036209 time 03/15/2013 18:12:17
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc3_4652.trc:
                ORA-00354: corrupt redo log block header
                ORA-00353: log corruption near block 38016 change 58036209 time 03/15/2013 18:12:17
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                ARC3: All Archive destinations made inactive due to error 354
                ARCH: Archival stopped, error occurred. Will continue retrying
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc3_4652.trc:
                ORA-16038: log 2 sequence# 2300 cannot be archived
                ORA-00354: corrupt redo log block header
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                Mon Mar 18 14:10:38 2013
                Sweep [inc][46176]: completed
                Mon Mar 18 14:11:34 2013
                ARCH: Archival stopped, error occurred. Will continue retrying
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc0_5796.trc:
                ORA-16014: log 2 sequence# 2300 not archived, no available destinations
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                Mon Mar 18 14:16:36 2013
                ARC1: Log corruption near block 38016 change 58036209 time ?
                CORRUPTION DETECTED: thread 1 sequence 2300 log 2 at block 38016. Arch found corrupt blocks
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc1_2244.trc (incident=52412):
                ORA-00353: log corruption near block 38016 change 58036209 time 03/15/2013 18:12:17
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc1_2244.trc:
                ORA-00354: corrupt redo log block header
                ORA-00353: log corruption near block 38016 change 58036209 time 03/15/2013 18:12:17
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                ARC1: All Archive destinations made inactive due to error 354
                ARCH: Archival stopped, error occurred. Will continue retrying
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc1_2244.trc:
                ORA-16038: log 2 sequence# 2300 cannot be archived
                ORA-00354: corrupt redo log block header
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                Mon Mar 18 14:16:37 2013
                Sweep [inc][52412]: completed
                Mon Mar 18 14:17:34 2013
                ARCH: Archival stopped, error occurred. Will continue retrying
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc3_4652.trc:
                ORA-16014: log 2 sequence# 2300 not archived, no available destinations
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                Mon Mar 18 14:22:36 2013
                ARC0: Log corruption near block 38016 change 58036209 time ?
                CORRUPTION DETECTED: thread 1 sequence 2300 log 2 at block 38016. Arch found corrupt blocks
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc0_5796.trc (incident=52423):
                ORA-00353: log corruption near block 38016 change 58036209 time 03/15/2013 18:12:17
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc0_5796.trc:
                ORA-00354: corrupt redo log block header
                ORA-00353: log corruption near block 38016 change 58036209 time 03/15/2013 18:12:17
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                ARC0: All Archive destinations made inactive due to error 354
                ARCH: Archival stopped, error occurred. Will continue retrying
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc0_5796.trc:
                ORA-16038: log 2 sequence# 2300 cannot be archived
                ORA-00354: corrupt redo log block header
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                Mon Mar 18 14:22:38 2013
                Sweep [inc][52423]: completed
                Mon Mar 18 14:23:39 2013
                ARCH: Archival stopped, error occurred. Will continue retrying
                Errors in file e:\app\administrator\diag\rdbms\cadsdb1\cadsdb1\trace\cadsdb1_arc1_2244.trc:
                ORA-16014: log 2 sequence# 2300 not archived, no available destinations
                ORA-00312: online log 2 thread 1: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\CADSDB1\CADSDB1\REDO02.LOG'
                • 5. Re: ORA-00257: archiver error. Connect internal only, until freed.
                  asahide
                  Hi,

                  Check this links.
                  <<http://oracleacedba.blogspot.jp/2010/10/ora-00354-corrupt-redo-log-block-header.html>>


                  Regards,
                  • 6. Re: ORA-00257: archiver error. Connect internal only, until freed.
                    Danish297
                    Hi,

                    I done this as mention in given link earlier to for workaround, But after some interval of time same problem occurring.... :-(
                    need to fix it permanently.
                    • 7. Re: ORA-00257: archiver error. Connect internal only, until freed.
                      EdStevens
                      Danish297 wrote:
                      Hi,

                      I done this as mention in given link earlier to for workaround, But after some interval of time same problem occurring.... :-(
                      need to fix it permanently.
                      Obviously, you can't just keep increasing the size of the archive destination. You need to perform regular housekeeping on it.
                      You should be takeing daily rman backups, including backup of the archivelogs. As part of that backup procedure, you need to include the deletion of archivelogs once they are backed up. There are various ways to do this, but the simplest is
                      rman> backup archivelog delete all input;
                      • 8. Re: ORA-00257: archiver error. Connect internal only, until freed.
                        Danish297
                        Hi All,

                        I done the follwing things to resolve it.

                        1. Switch the log file.
                        2. added one more redo group.
                        3. drop the corrupted redo group.
                        • 9. Re: ORA-00257: archiver error. Connect internal only, until freed.
                          Danish297
                          Hi All,

                          I done the follwing things to resolve it.

                          1. Switch the log file.
                          2. added one more redo group.
                          3. drop the corrupted redo group.
                          • 10. Re: ORA-00257: archiver error. Connect internal only, until freed.
                            Danish297
                            Hi All,

                            I done the following things to resolve it.

                            1. Switch the log file.
                            2. added one more redo group.
                            3. drop the corrupted redo group.