How to change db_recovery_file_dest_size parameter

Products

• CA eHealth

Issue/Introduction

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

Environment

Release: LHBASC99000-6.2-eHealth-Live Health Upgrade Elements
Component: