Overview

You notice that the DB production server runs out of disk and you need to extend it.

Solution

A possible reason why the space in the database server is running out is that the Dataguard host is unreachable and the archive data is not able to be moved to the Dataguard. As a result, the disk space is being filled by the automatic archive log.

If you shut down Dataguard intentionally you can request the Support team to modify the archive redo log to be cleared after a day. 

<supportagent>

To investigate why the Dataguard host is down the agent should escalate the ticket to the Professional Services team.

If the agent got a confirmation that Dataguard was shut down intentionally, or\and the request from the customer to modify the archive redo log to be cleared after a day, then the agent should modify the DEL_ARC_DAYS value in the /procims/usrdefs/profile.sys file to delete arch files that are older than 1 day.

Example:

[pro@h71x00 data3]$ cat /procims/usrdefs/profile.sys
export ORACLE_HOME=/oracle/ora10
export ORACLE_SID=F
export PATH=${PATH}:${ORACLE_HOME}/bin:$PRO/bin:$PRO/cbin0
export EXPDIR=/data/expdir
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1


# for dataguard
export DATAGUARD_DIR=/procims/dataguard
export REPLICATION_LOCK_DIRECTORY=/procims/dataguard/lock
export ERROR_HANDLER=$DATAGUARD_DIR/dgr_err_handler.bat
export HOURS_TO_EXPORT=''
export HOURS_TO_BACKUP=''
export DEL_ARC_DAYS=1
export STANDBY_CONF='F LOCAL'
export PF_ON=ON
export CBIN=${PRO}/cbin

</supportagent>