Re: archive logs

"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. Received on Fri Jan 12 2007 - 15:34:48 CST