search cancel

How to change db_recovery_file_dest_size parameter

book

Article ID: 21372

calendar_today

Updated On:

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: