Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using OEM to delete archivelogs

Status
Not open for further replies.

jsb1963

Technical User
Jun 27, 2008
2
US
Is there a way within OEM to automatically execute RMAN commands to delete older archivelogs?

I manually execute this in RMAN:

RMAN> crosscheck archivelog all;
RMAN> delete archivelog all completed before 'sysdate-7';

Regarding the backups, they are already setup and automatically executing within OEM...very nicely I might add. :) Now I need the clean-up to be automatic as well.

Thanks in advance!
 
Could this be set up using dbms_jobs?

I want to be good, is that not enough?
 


Set it up with OEM:

Jobs > Create Job > RMAN Script

[3eyes]


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Excellent. Thanks for the help. I appreciate it. I can now create a Job and schedule it to execute on a regular basis.

Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top