topic Re: HP SE database ARC file is occupying space in Operating System - HP-UX

HP SE database ARC file is occupying space

Ravi_Shankar — Wed, 11 Mar 2009 14:43:45 GMT

Oracle database is creating archive file in every 15 minute and each file size is 500 MB . Is there any way we can decrease the frequecy of ARC file so that will not run out of space.

We are using RMAN and TSM for backup. Please sugest

Re: HP SE database ARC file is occupying space

T G Manikandan — Wed, 11 Mar 2009 14:49:59 GMT

your oracle database is running on ARCHIVELOG mode and this is creating the arc files.

this is enabled with the init.ora file for parameter

log_archive_dest=

There is no way you can reduce the frequency of these files as once the redo logs gets filled up they are rotated and moved as archive log files.

The one way is to delete these files. If you are using RMAN you can use the "delete input" clause with the backup so that these files will be deleted as they are backed up.

Re: HP SE database ARC file is occupying space

T G Manikandan — Wed, 11 Mar 2009 14:53:16 GMT

Sample RMAN script would be something like

RMAN> run {
2> allocate channel dev1 type disk;
3> backup
4> format '/app/oracle/archback/log_%t_%sp%p'
5> (archivelog all delete input);
6> release channel dev1;
7> }

Check with your DBA.

Re: HP SE database ARC file is occupying space

Ravi_Shankar — Thu, 12 Mar 2009 06:09:46 GMT

Can we set arc file size, database size is only 17 GB and its creating 500 MB arc file in every 15 Minutes, this does not sound good. Its seems something is wrong with the database.

Is there anyway we can set archive file size , its should not create 500 MB archive file everey 15 Minutes.

TSM client is installed on SE server to take full backup. Could you please suggest if we fix this issue by modifying Oracle configuration and will see if anything can be done from TSM side.

Re: HP SE database ARC file is occupying space

Sivakumar MJ._1 — Thu, 12 Mar 2009 06:54:36 GMT

Hi Manikandan,

For the above issue, can we try in disable /enable the RMAN... It would clean it's archive logs.

Will DBADMIN will help somewhere..