Database Administration (MOSC)

MOSC Banner

Using the Database Scheduler to run ADRCI commands

edited Mar 20, 2013 9:14AM in Database Administration (MOSC) 4 commentsAnswered
Hey Folks,
Here's my challenge: I want to automate some ADR maintenance tasks using the Database Scheduler.   Of course I can easily script and schedule ADRCI commands at the OS level but let's say that I have the following restrictions:

- Can't use any external OS scheduling tools or Grid Control
- Can't use any permanent OS resident objects such as scripts or SQL files

For example, maybe the command I want to execute is:  adrci exec="set homepath diag/rdbms/orcl/ORCL; purge -age 60 -type TRACE"

Now yes of course I know about the automatic cleanup and the SHORTP_POLICY and LONGP_POLICY but for sake of argument say I want my scheduler job to over-ride those.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center