Re: safe to delete 'old' archive logs?

"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message news:<1084787189.18929.0_at_lotis.uk.clara.net>...
> Oracle 9.2.0.4
> Linux AS
>
> Hi,
>
> I have my retention policy set to 5 days, they actualy end up on tape each night as well as disk, and every couple of weeks or so i
> issue a delete obsolete.
>
> I have just noticed that i have old archive logs lying around that are outside of this retention window.
>
> $ ls -l /u05/archive/xxxxx/
> total 3280116
> -rw-r----- 1 oracle oinstall 104857088 May 12 11:12 1_119.dbf
> -rw-r----- 1 oracle oinstall 104857088 May 13 07:01 1_120.dbf
> -rw-r----- 1 oracle oinstall 104857088 May 13 21:02 1_121.dbf
> -rw-r----- 1 oracle oinstall 104857088 May 14 18:43 1_122.dbf
> -rw-r----- 1 oracle oinstall 104857088 May 16 09:13 1_123.dbf
> -rw-r----- 1 oracle oinstall 104856576 May 17 09:05 1_124.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 18 15:12 1_12.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 19 12:00 1_13.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 20 07:44 1_14.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 20 18:16 1_15.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 21 17:04 1_16.dbf
> -rw-r----- 1 oracle oinstall 104856576 Feb 22 17:22 1_17.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 23 11:43 1_18.dbf
> -rw-r----- 1 oracle oinstall 104856576 Feb 23 22:54 1_19.dbf
> -rw-r----- 1 oracle oinstall 104856576 Feb 24 17:19 1_20.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 25 09:53 1_21.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 25 09:54 1_22.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 25 09:55 1_23.dbf
> -rw-r----- 1 oracle oinstall 104855040 Feb 25 09:57 1_24.dbf
> -rw-r----- 1 oracle oinstall 104850944 Feb 25 09:58 1_25.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 25 09:59 1_26.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 25 10:01 1_27.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 25 12:09 1_28.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 26 08:16 1_29.dbf
> -rw-r----- 1 oracle oinstall 104857088 Feb 26 21:34 1_30.dbf
> -rw-r----- 1 oracle oinstall 104854528 Mar 14 16:49 1_51.dbf
> -rw-r----- 1 oracle oinstall 104857088 Mar 15 10:06 1_52.dbf
> -rw-r----- 1 oracle oinstall 104853504 Mar 15 18:05 1_53.dbf
> -rw-r----- 1 oracle oinstall 104857088 Mar 16 12:52 1_54.dbf
> -rw-r----- 1 oracle oinstall 104853504 Mar 17 04:00 1_55.dbf
> -rw-r----- 1 oracle oinstall 104857088 Mar 17 20:45 1_56.dbf
> -rw-r----- 1 oracle oinstall 104857088 Mar 18 17:44 1_57.dbf
>
> Am i OK to just issue an rm to get rid of these or is there something more elegent?
>
> thanks

1. oinstall is for installing software. reset the default group of the oracle account to dba so that such files are created under the ownership of the dba group. change the ownership of the existing files.
2. you have to explicitly instruct rman to remove the aged files.
3. determine if a single copy on tape is sufficient for your purposes. you might choose to have archived redo logs included in at least 2 backup sets.

I would suggest that you read the relevant rman users guide for your (unspecified) version of Oracle.

Pd Received on Mon May 17 2004 - 13:33:50 CDT