In addition to using the DELETE INPUT clause to delete archivelogs
immediately after backing them up successfully once, remember that you can
also arrange to delete archivelogs after they have been backed up "N" times.
I schedule an hourly job to run the following command using 9i RMAN:
RMAN>
With RMAN, can I use 'copy archivelog all delete input' to copy each archive redo
logfile to a single file?
-Original Message-
Sent: Wednesday, October 15, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L
Your backup script should be deleting archive logs after they are backed up.
only if your backupset size is more then total_arc_log_file_sizes .
Otherwise there will be more then one pieces , rite ( ??)
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 1:19 PM
> With RMAN, can I use 'copy
hel Carmichael
Sent: Wednesday, October 15, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Archivelog - Disk space issue.
have you backed up those archive logs before you remove them? you
can
remove any archive logs created before you began your most recent
backup, wh
ecome full
and hang the database.
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Rachel Carmichael
Sent: Wednesday, October 15, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Archivelog - Disk space issue.
have you b
Your backup script should be deleting archive logs after they are backed up. With
RMAN, you could do the following, just to backup and delete your archivelogs:
run
{
allocate channel ch1 type disk format '/bkup4/oracle/%d/arc_s%s_p%p_%t';
set limit channel ch1 kbytes=100; # Limit sets to 1
have you backed up those archive logs before you remove them? you can
remove any archive logs created before you began your most recent
backup, which is NOT the same thing as removing any archive log created
before the oldest online log
--- Denham Eva <[EMAIL PROTECTED]> wrote:
> Hello Gurus,
>
You can use the find command to remove archived redo log files older
than x days. The command runs in my hotbackup shell script every other
day and removes files older than 1 day.
find /disk04/oraarch/$ORACLE_SID/log*.arc -mtime +1 -exec rm {} \;
-Original Message-
Sent: Wednesday, Octob