Database Administration (MOSC)

MOSC Banner

ADR: automatic purge of ADR - how to change the scheduled time

in Database Administration (MOSC) 7 comments

Hi all,

I have executed below command directly under adrci:

adrci> select SHORTP_POLICY,LONGP_POLICY,LAST_AUTOPRG_TIME,LAST_MANUPRG_TIME from ADR_CONTROL;

ADR Home = /opt/oradata/DB85/diag_audit_dest/diag/rdbms/db85_t2/DB85_T2:

*************************************************************************

SHORTP_POLICY    LONGP_POLICY     LAST_AUTOPRG_TIME            LAST_MANUPRG_TIME             

-------------------- -------------------- ---------------------------------------- ---------------------------------------- 

1440         8760         2021-01-08 10:42:24.991353 +01:00    2021-01-08 05:50:25.304013 +01:00    

1 row fetched

As shown in the result set above happened the last purge of the ADR at the 8th of Jan. at 10:42 am. My questions now are: where is this schedule configured? And is it possible to modify this schedule (e.g. to 08:00 am)? I truly would like to understand where this schedule configured.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center