Re: archive logs

From: Scott <nospam_at_nomail.com>
Date: Fri, 12 Jan 2007 16:57:39 -0500
Message-ID: <svTph.76524$9i3.322676@wagner.videotron.net>

"Scott" <nospam_at_nomail.com> wrote in message news:0aTph.75170$9i3.314476_at_wagner.videotron.net...
> "shinobi" <Shinobi59_at_gmail.com> wrote in message
> news:1168632904.992825.188930_at_q2g2000cwa.googlegroups.com...

>>
>> shinobi wrote:
>>> Chuck wrote:
>>> > shinobi wrote:
>>> > > Cris wrote:
>>> > >> shinobi wrote:
>>> > >>
>>> > >>> How can I clear the archive logs
>>> > >> By deleting them or moving them elsewhere?
>>> > >>
>>> > >> --
>>> > >> spamto:cris119_at_operamail.com
>>> > >>
>>> > >> blind faith in your leaders or
>>> > >> in anything will get you killed
>>> > >
>>> > > Ok.  I'm not a dba but I am being asked to take care of this.  How 
>>> > > do I
>>> > > delete archive logs.  Is there a file extension I can search for? 
>>> > > This
>>> > > is on a Red Hat Enterprise Linux system.  Would this be one of the
>>> > > files ending in .trc?
>>> > >
>>> > > Thanks
>>> > >
>>> > > -shinobi
>>> > >
>>> >
>>> > Just delete them. The oldest ones that is. Better yet move them to a
>>> > different disk just in case you need them.
>>> >
>>> > The real issue here though is why are they accumulating with no
>>> > procedure for backing them up and deleting them?
>>>
>>> The log files apparently do not end in .arc and to make it a bit more
>>> complicated they reside on an ASM disk so I am not sure how I can
>>> delete them outside oracle.
>>
>> Morgan, I am in Waco, TX.
>>
>
>

> If you know your way around the dbconsole you can do it with that tool
> or use the command like to invoke rman to backup your archivelogs.

>

> Do this at your own risk as I didn't run these command or know your
> environment.

>

> Connect to the server as the owner of the software

>

> hopefully your oracle home and oracle sid are set as environment
> variables.

>

> cd $ORACLE_HOME
> ./rman target /

>

> run
> {
> allocate channel d1 device type disk;
> backup archivelog
> time between 'sysdate-14' and 'sysdate-7'
> format = '/tmp/archbackup%U' tag='ARC_BAK_EMER1'
> delete input;
> }

>

> Hope that helps you. Adjust the path and other criteria as necessary.

>

> You really need a DBA!

>

> Scott.

>

it should be

./bin/rman target /

my appologies. Received on Fri Jan 12 2007 - 15:57:39 CST