How to change db_recovery_file_dest_size parameter
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
- Go to $ORACLE_HOME/database (for window), go to $ORACLE_HOME/dbs(for Unix)
- 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: