How to change db_recovery_file_dest_size parameter

Document ID : KB000021372
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

How to change db_recovery_file_dest_size parameter

 

Solution:

This is to fix errors seen in the alert log that the recovery file destination is full or nearly so.

Here is the procedure on how to change Oracle db_recovery_file_dest_size parameter

  1. Go to $ORACLE_HOME/database (for window), go to $ORACLE_HOME/dbs(for Unix)

  2. Backup initEhealth.ora file to initEhealth.ora.bak, then set value for db_recovery_file_dest_size to new value in initEhealth.ora file, then do the followings in order:

    nhServer stop
    nhStopDb immediate
    nhStartDb
    nhServer start