Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deletion of archive log using RMAN Target in Oracle 10g

009May 4 2013 — edited May 4 2013

Hi All,
I recently have noticed that the archive logs have occupied 102 GBs out of the drive and I need to free up some space. When I tried to connect RMAN Catalog using

connect catalog user@db

I got error message as

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06445: cannot connect to recovery catalog after NOCATALOG has been used

But I was able to get through using

connect target user@db

My Query is can I use

RMAN> delete noprompt expired archivelog all;

as given in [how to delete archive log file |https://forums.oracle.com/forums/thread.jspa?threadID=2321257&start=0&tstart=0]
Or shall I take any other approach to delete the obsolete archive logs?

Regards,
*009*

This post has been answered by Shivananda Rao on May 4 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2013

Added on May 4 2013

#performance-availability, #recovery-manager-rman

2 comments

3,234 views