Re: 11g RMAN backup archive logs, delete options

  • From: Edgar Chupit <chupit@xxxxxxxxx>
  • To: exriscer@xxxxxxxxx
  • Date: Thu, 19 May 2011 12:34:41 +0200

I tried using environment variables in my rman scripts before and it never
worked. I remember that I even found metalink note that environments
variables are not supported from rman.

is it really working on your side?

$ export RETENTION_ARCH=7
$ echo ${RETENTION_ARCH}
7
$ rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Thu May 19 12:33:20
2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights
reserved.

connected to target database: TEST (DBID=711092535)

RMAN>  list ARCHIVELOG ALL BACKED UP 1 TIMES TO DISK COMPLETED BEFORE
'SYSDATE - ${RETENTION_ARCH}';

using target database control file instead of recovery catalog

DBGSQL:     TARGET> select SYSDATE - ${RETENTION_ARCH} from sys.dual
DBGSQL:        sqlcode = 911
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 05/19/2011 12:33:24
ORA-01858: a non-numeric character was found where a numeric was expected


Best regards,
 Edgar Chupit
 callto://edgar.chupit


On Wed, May 18, 2011 at 9:22 PM, LS Cheng <exriscer@xxxxxxxxx> wrote:

> DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DISK COMPLETED BEFORE
> 'SYSDATE - ${RETENTION_ARCH}';
>
>
> On Wed, May 18, 2011 at 9:12 PM, CRISLER, JON A (ATTCORP) 
> <JC1706@xxxxxxx>wrote:
>
>>  I want to combine the functions of deleting archive logs based on date
>> AND that they have been backed up already.  Is this possible ?
>>
>>
>>
>> For instance this will delete all the archive logs backed up (regulated by
>> rman archive log deletion policy)
>>
>>
>>
>> Run {
>>
>> backup as compressed backupset
>>
>> archivelog all
>>
>> delete all input;
>>
>> }
>>
>>
>>
>> This would delete archive logs-
>>
>>
>>
>> delete archivelog all completed before 'sysdate -7';
>>
>>
>>
>> What I am looking for is deleting them based on date, and that they have
>> been backed up.
>>
>
>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2011