Re: safe to delete 'old' archive logs?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 18 May 2004 07:52:10 +1000
Message-ID: <40a933fc$0$31676$afc38c87@news.optusnet.com.au>

Paul Drake wrote:

> "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.

[snip]

>>-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.

Now, I am ready to bow to superior knowledge on Linux at any stage, but I rather think that the group displayed for his archives depends on what group he specified when installing Oracle in the first place. You know, that screen in the installer where it says "Unix Group Name ... please enter a group name that will have permission to update Oracle software on this system"?

Most people stick "dba" in there, it is true. It's not actually advised to do that in the 10g installation notes (they recommend "oinstall"... Lord knows what the 9i installation doco advises, but I would expect it to be vaguely similar). My web pages likewise suggest "oinstall". So it is quite possible, is it not, that the right group is there all along?

Chowning these things would just make things all the more complicated in that case, surely.

Regards
HJR
> 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 - 16:52:10 CDT