7 Replies Latest reply: Apr 16, 2012 9:32 AM by Jgregores-Oracle RSS

    False controlfile "Corrupt block relative dba:0x00000001(file 0, block 1)"

    Jgregores-Oracle
      Hi,
      This is a 4 Node Cluster and we are getting a Controlfile corruption error sporadically since August 2011. Happens always on weekends on different instances randomly. There is no Real Corruption, just need to start the Database, no Control file damage found.
      Also no Hardware Hardware fault found on the Solaris_Sparc Server/Emc DMX storage(Veritas Volume Manager)

      Can this be a Timeout/Performance problem ?
      Can this be a configuration problem ?

      ***
      Corrupt block relative dba: 0x00000001 (file 0, block 1)
      Completely zero block found during control file header read
      Sun Sep 11 01:08:57 2011
      Errors in file /u02/app/oracle/admin/diag/rdbms/cpcjp/cpcjp1/bdump/cpcjp1_ckpt_20004.trc:
      ORA-00202: controlfile: '/dev/vx/rdsk/cpcjprodg/control_01'
      Sun Sep 11 01:08:58 2011
      Errors in file /u02/app/oracle/admin/diag/rdbms/cpcjp/cpcjp1/bdump/cpcjp1_ckpt_20004.trc:
      ORA-00227: corrupt block detected in controlfile: (block 1, # blocks 1)
      ORA-00202: controlfile: '/dev/vx/rdsk/cpcjprodg/control_01'
      Sun Sep 11 01:08:58 2011
      Errors in file /u02/app/oracle/admin/diag/rdbms/cpcjp/cpcjp1/bdump/cpcjp1_lmon_19949.trc:
      ORA-00227: corrupt block detected in controlfile: (block , # blocks )
      Sun Sep 11 01:08:58 2011
      Errors in file /u02/app/oracle/admin/diag/rdbms/cpcjp/cpcjp1/bdump/cpcjp1_lmd0_19951.trc:
      ORA-00227: corrupt block detected in controlfile: (block , # blocks )
      Sun Sep 11 01:08:58 2011
      Errors in file /u02/app/oracle/admin/diag/rdbms/cpcjp/cpcjp1/bdump/cpcjp1_lms0_19976.trc:
      ORA-00227: corrupt block detected in controlfile: (block , # blocks )
      Sun Sep 11 01:08:58 2011
      System state dump is made for local instance
      CKPT: terminating instance due to error 227
      Sun Sep 11 01:08:58 2011
      Errors in file /u02/app/oracle/admin/diag/rdbms/cpcjp/cpcjp1/bdump/cpcjp1_lms7_19994.trc:
      ORA-00227: corrupt block detected in controlfile: (block , # blocks )
      Sun Sep 11 01:08:58 2011
      Trace dumping is performing id=[cdmp_20110911010858]
      Sun Sep 11 01:09:03 2011
      Instance terminated by CKPT, pid = 20004
      Mon Sep 12 06:37:54 2011
      Starting ORACLE instance (normal)
      Mon Sep 12 06:37:54 2011
      Global Enqueue Service Resources = 2296, pool = 32
      Mon Sep 12 06:37:54 2011
      Global Enqueue Service Enqueues = 6116
      LICENSE_MAX_SESSION = 0
      LICENSE_SESSIONS_WARNING = 0
      SCN scheme 3
      Using log_archive_dest parameter default value
      LICENSE_MAX_USERS = 0
      SYS auditing is disabled
      Starting up ORACLE RDBMS Version: 9.2.0.8.0.
      System parameters with non-default values:
      processes = 300
      sessions = 335
      shared_pool_size = 117440512
      shared_pool_reserved_size= 5242880
      large_pool_size = 33554432
      java_pool_size = 33554432
      spfile = /u02/app/oracle/admin/config/spfilecpcjp.ora
      enqueue_resources = 265
      control_files = /dev/vx/rdsk/cpcjprodg/control_01, /dev/vx/rdsk/cpcjprodg/control_02, /dev/vx/rdsk/cpcjprodg/control_03
      db_block_checksum = TRUE
      db_block_size = 8192
      db_writer_processes = 2
      db_cache_size = 218103808
      compatible = 9.2.0.8
      log_archive_start = TRUE
      log_archive_dest_1 = LOCATION=/u03/archive1/cpcjp/
      log_archive_dest_2 = LOCATION=/u03/archive2/cpcjp/
      log_archive_min_succeed_dest= 2
      log_archive_format = cpcjp%t_%T_%S.ARC
      log_buffer = 1310720
      log_checkpoint_timeout = 0
      db_files = 50
      db_file_multiblock_read_count= 8
      cluster_database = TRUE
      cluster_database_instances= 2
      thread = 1
      fast_start_mttr_target = 900
      log_checkpoints_to_alert = TRUE
      recovery_parallelism = 4
      control_file_record_keep_time= 7
      dml_locks = 200
      instance_number = 1
      transaction_auditing = FALSE
      undo_management = AUTO
      undo_tablespace = cpcjp1_UNDO01
      undo_retention = 900
      db_block_checking = TRUE
      max_enabled_roles = 40
      remote_os_roles = TRUE
      O7_DICTIONARY_ACCESSIBILITY= TRUE
      global_names = FALSE
      instance_name = cpcjp1
      service_names = cpcjp
      local_listener = LISTENER_BUTTON
      remote_listener = LISTENER_SCAN
      session_cached_cursors = 0
      job_queue_processes = 3
      cursor_sharing = EXACT
      parallel_min_servers = 0
      parallel_max_servers = 0
      background_dump_dest = /u02/app/oracle/admin/diag/rdbms/cpcjp/cpcjp1/bdump
      user_dump_dest = /u02/app/oracle/admin/diag/rdbms/cpcjp/cpcjp1/udump
      max_dump_file_size = unlimited
      core_dump_dest = /u02/app/oracle/admin/diag/rdbms/cpcjp/cpcjp1/cdump
      audit_trail = NONE
      db_name = cpcjprod
      open_cursors = 1000
      sql_trace = FALSE
      os_authent_prefix =
      optimizer_mode = choose
      parallel_automatic_tuning= FALSE
      pga_aggregate_target = 209715200
      workarea_size_policy = AUTO
      statistics_level = typical
      Mon Sep 12 06:37:56 2011
      cluster interconnect IPC version:Oracle UDP/IP
      IPC Vendor 1 proto 2 Version 1.0