5 Replies Latest reply: Feb 17, 2014 4:34 AM by user545194 RSS

    ORA-19815: WARNING (ORA-00257)

    user545194

      Hi,

       

      Environment:

      Virtual Machine

      OS: Windows Server 2008 R2 Std. 64bit (5 GB RAM)

      DB: Oracle Database 12c (12.1.0.1.0) 64bit Production

      Oracle Home: C:\

      Archive Log location. E:\

       

      The information in the log.xml:

      Errors in file C:\ORACLE\LINE3\diag\rdbms\line3\line3\trace\line3_arc0_3196.trc: ORA-19815: WARNING:

      db_recovery_file_dest_size of 10737418240 bytes is 100.00% used, and has 0 remaining bytes available.

       

      is somewhat misleading, because their is enough space on the disk.

       

      show parameter recover

       

      NAME                                           TYPE    VALUE

      -------------------------------------------------- ----------- -------------

      db_recovery_file_dest                          string  E:\OraArchive
      db_recovery_file_dest_size                     big integer 10G       
      db_unrecoverable_scn_tracking                  boolean TRUE
      recovery_parallelism                           integer 0

      select dest_name,status,destination from V$ARCHIVE_DEST

      where status = 'VALID';

       

      DEST_NAME       STATUSDESTINATION

      ------------------ --------- -------------------------

      LOG_ARCHIVE_DEST_1  VALID USE_DB_RECOVERY_FILE_DEST

       

      select * from v$flash_recovery_area_usage;

       

      FILE_TYPE           PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES    CON_ID           

      ----------------------- ---------------------- ------------------------- ---------------------- ----------------------

      CONTROL FILE        0                  0                     0                  0                
      REDO LOG            0                  0                     0                  0                
      ARCHIVED LOG        32.99              0                     90                 0                
      BACKUP PIECE        0.17               0                     1                  0                
      IMAGE COPY          0                  0                     0                  0                
      FLASHBACK LOG       0                  0                     0                  0                
      FOREIGN ARCHIVED LOG0                  0                     0                  0                
      AUXILIARY DATAFILE COPY 0                  0                     0                  0                

      8 rows selected

       

      RMAN Retention Policy

       

      CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

       

      We have configured our system to delete all archived logs older than 7 days in order to free up disk space. However, the log.xml still shows the same warning.

      The database was also halted due to an ORA-00257.

       

      We would appreciate any suggestions in order to avoid the ORA-00257 error.

       

      Thanks!