How to delete archived log files past one week in RMAN

Hi All,

In RMAN backup script, Once it takes the backup of all Archivelogs, I want to delete archive logs from the server disk, which are older than 7 days.

I know of command 'delete input'. But, this deletes all the files.

Is there any command like 'delete input sysdate-7' or something which serves my purpose?

Thanks in Adv.

Check the september's dba tips of the month at



It show how to delete old archive log file from the os automaticalyhttp://www.quest-pipelines.com/pipel....htm#september

Thanks Steeve. Thats really cool article....

Hi Steve,

Thanks but I need something which can delete from within the RMAN script. Something like 'delete input SYSDATE-n'.

Thanks,

http://download-west.oracle.com/docs...cat.htm#442881

From the docs, this might help you

Quote:

---

Specifying Records by Time: Example This example backs up all logs that could be used to recover to a point one week ago, and then deletes all archived redo logs that were created more than two weeks ago:

BACKUP ARCHIVELOG UNTIL TIME 'SYSDATE-7';
DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-14';

---

Hi Sameer,

Here, what I want is to backup all the current Archive logs available on the server but delete only those which are older than 7 days.

So, is there a command similar to

BACKUP ARCHIVELOG ALL;
DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';

Will it work for me?

Also, pl. tell me how you guys have inserted goody pictures below your names.

Thanks,

Quote:

---

Originally posted by samdba

BACKUP ARCHIVELOG ALL;
DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';

---

Why don't you give it a try and report back to us.

Hi Marist,

Thanks for your advise. I get the syntax error while using above statement.

'syntax error: Found copy expecting one of: "input" at line...'

Thanks,

Hi Sam,

Here is the command which I am using to delete archive logs from the RMAN script:

allocate channel for delete type disk;
change archivelog until time 'SYSDATE-7' delete;
release channel;


Cheers!
Farrukh

Hi FARRUKH,

This is what I was looking for but I got foll. errors.

rmandel.rcv
--------------
run {
allocate channel d1 for delete type disk;
change archivelog until time 'SYSDATE-1' delete;
release channel d1;
resync catalog;
}

RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "for": expecting one of: "name, type"
RMAN-01007: at line 2 column 21 file: rmandel.rcv

Also, can I call rmandel.rcv from another RMAN .rcv file?

Thanks,

Hi Sam,

You don't have to put "d1" after allocate channel, just do the following:

run {
allocate channel for delete type disk;
change archivelog until time 'SYSDATE-7' delete;
release channel;
}

Yes, you can do it from .rcv file as well. Please let me know if you need more information!

Cheers!!
Farrukh

You can also use:

allocate channel for maintenance type disk;
crosscheck backup of archivedlogs completed between 'sysdate - 30' and 'sysdate - 7';
delete expired backup;
release channel;
exit;

In 8i, that still has be run from RMAN> command prompt. In 9i, you can do it from script.


Hope that helps,

clio_usa - OCP 8/8i/9i DBA

Visit our Web Site

Quote:

---

In 8i, that still has be run from RMAN> command prompt. In 9i, you can do it from script

---

Hi clio_usa,

In 8i, you can also do it from script as well.

Cheers!
Farrukh

Have you actually tried? I did, and it's the way as Oracle says:

Quote:

---

Purpose
To determine whether backups stored on disk or tape exist. Backups are either backup sets or media-managed proxy copies.

The crosscheck command checks only backup sets marked AVAILABLE or EXPIRED, either by examining the backup pieces on disk when the channel is type disk, or by querying the media manager when the channel is type 'sbt_tape'. It only processes backups created on the specified channel.

RMAN does not delete any backup pieces that it is unable to find, but updates their repository records to EXPIRED status. If some backup pieces were erroneously marked as EXPIRED, for example, because the media manager was misconfigured, then after ensuring that the files really do exist in the media manager, run the crosscheck backup command again to restore those files to AVAILABLE status.

See Also:
"Maintaining the RMAN Repository".




Requirements
Execute crosscheck backup only at the RMAN prompt.

Allocate a maintenance channel before issuing crosscheck backup.

---

For refernce: CROSSCHECK RMAN's command


Hope that helps,

clio_usa - OCP 8/8i/9i DBA

Visit our Web Site

Hi clio_usa,

Thanks for the info!

Cheers!
Farrukh

Hi Farrukh,

Quote:

---

You don't have to put "d1" after allocate channel, just do the following:
run {
allocate channel for delete type disk;
change archivelog until time 'SYSDATE-7' delete;
release channel;
}

---

I get foll. error if I do not give channel id.

RMANN> run {
allocate channel for delete type disk;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "for": expecting one of: "channel_id, double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 2 column 18 file: standard input

Thanks,

http://download-west.oracle.com/docs...a76990/toc.htm

Hi Sam,

Here is my script. I don't know which OS are you using?

$ cat /u01/scripts/cleanup_rman_arch_test2.sh
#!/bin/ksh
ORACLE_SID=TEST2; export ORACLE_SID
ORACLE_HOME=/u01/oracle8i/product/8.1.7; export ORACLE_HOME
PATH=$ORACLE_HOME/bin; export PATH
$ORACLE_HOME/bin/rman target username/password@TEST2 catalog rman/rman@rcat log=/u01/logs/cleanup_rman_arch_test2_log @/u01/scripts/cleanup_rman_arch_test2.rcv
exit

$ cat /u01/scripts/cleanup_rman_arch_test2.rcv
allocate channel for delete type disk;
change archivelog until time 'SYSDATE-7' delete;
release channel;

Cheers!
Farrukh

Hi Farrukh,

Finally foll. script worked.

run {
allocate channel d1 type disk;
sql 'alter system archive log current';
backup
format 'e:\backup\%d_%s_%p_%t.1al'
archivelog all;
release channel d1;
resync catalog;
}
allocate channel for maintenance type disk;
change archivelog until time 'sysdate-1' delete;

Thanks everybody.