Home / Errors/Workarounds12c

Errors/Workarounds12c

How to Find and repair Corrupt block in database

How to Find and repair Corrupt block in database   Step 1: Below query will show if there is any corrupted block SELECT *  FROM   v$database_block_corruption — will show if any corruped block  Step 2: Below query can give …

Read More »

RAC Files and Directories

RAC Files and Directories   $ORA_CRS_HOME/cdata/<cluster_name> OCR backups (default location) $ORA_HOME/log/<hostname>/client/ocrconfig_<pid>.log OCR command log file $ORA_CRS_HOME/crs/log contains trace files for the CRS resources $ORA_CRS_HOME/crs/init contains trace files for the CRS …

Read More »

ORA-16038: log cannot be archived ORA-19809: limit exceeded forrecovery files

  ERROR ARC3: Error 19809 Creating archive log file to ‘+DISKS’ Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc1_6598.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 42687547752 bytes is 100.00% used, and has 0 remaining bytes available. …

Read More »