Re: Archive logs removal question

From: <johnbhurley_at_sbcglobal.net>
Date: Mon, 18 May 2009 15:50:07 -0700 (PDT)
Message-ID: <1a505a5a-b7c3-47f0-ab95-bc937ca18007_at_l28g2000vba.googlegroups.com>

On May 18, 11:29 am, Richard <RSL..._at_gmail.com> wrote:
> This should be fairly common question I hope. I like to know if it is
> safe to remove these old archive log files.  Oracle is 9i RAC (2 nodes
> dr_1,dr_2). It seems to tell me oldest log is 1086. So I can remove
> anything up to and including "....1086.arc" ?  It also has 2 directory
> locations. Please help a newbie. Thank you in advance.
>
> SQL> archive log list
> Database log mode              Archive Mode
> Automatic archival             Enabled
> Archive destination            /oracle/product/92/oradata/archive2
> Oldest online log sequence     1086
> Next log sequence to archive   1087
> Current log sequence           1087
> SQL>
>
>   1*  select 'rm '||substr(name,1,50) from v$archived_log where
> completion_time < (sysdate - 10 ) order by 1
> SQL> /
>
> 'RM'||SUBSTR(NAME,1,50)
> -----------------------------------------------------
> rm /oracle/product/92/dbs/dr/archive1/dr1_1_1066.arc
> rm /oracle/product/92/dbs/dr/archive1/dr1_1_1067.arc
> ....
> rm /oracle/product/92/dbs/dr/archive1/dr1_1_1077.arc
> rm /oracle/product/92/dbs/dr/archive1/dr1_2_1452.arc
> rm /oracle/product/92/dbs/dr/archive1/dr1_2_1453.arc
> ....
> rm /oracle/product/92/dbs/dr/archive1/dr1_2_1463.arc
> rm /oracle/product/92/oradata/archive2/dr1_1_1065.arc
> ....
> rm /oracle/product/92/oradata/archive2/dr1_1_1077.arc
> rm /oracle/product/92/oradata/archive2/dr1_2_1452.arc
> ....
> rm /oracle/product/92/oradata/archive2/dr1_2_1463.arc
>
> 49 rows selected.

With archived logs the question to ask is "do I have a backup that was taken and has been validated and is still available" that is AFTER these archived logs.

If you don't know what to do to answer that question ... then deleting anything would be a very bad idea. Received on Mon May 18 2009 - 17:50:07 CDT