jump to navigation

Delete Archive log oracle using RMAN February 15, 2008

Posted by dpermana in DBA.
trackback

i just want to share my case, about having problems with a disk space on R/3 server going full.

so i decided to delete archive log on oracle

step Configuration

the first thing to do is, find where the archive log is put

and after that you must use RMAN to delete the archive

on command promt. type this command RMAN

RMAN> run { allocate channel d1 type disk;

delete archivelog all;

release channel d1;

}

Best Regard’s

Dpermana

Advertisement

Comments»

1. abdullah afifi - September 9, 2008

thanks alot
can i delete archivelog before one week ?

best regards afifics

2. arun n - November 17, 2008

If i delete the archive log files using the above method, next time my rman backup runs, wouldn’t it fail? and then wouldn’t i be forced to do a ‘crosscheck’ before i can successfully get a backup set?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.