-
how to delete archive log file (rman 8.1.7.4)
I have been using following code for level0 archive log RMAN backup on oracle 8.1.7.4. All archived log files are backing up on the disk. I would like to know the best way to delete them from the disk.
sql 'alter system archive log current';
backup
filesperset 20
format '/BACKUP/db1/rman/archive/db1_al_t%t_s%s_p%p'
archivelog all
delete input;
I tried following rman commands but these does not delete archive logs files from the disk or changed the status. List backup is showing all pervious backup with available status.
allocate channel for maintenance type disk;
crosscheck backupset of database;
delete expired backupset;
delete expired backup of archivelog all;
release channel;
Any suggestions?
Thanks,
Puneet
-
Search the forum there are lot of questions on this topic and also the scripts.
-
Re: how to delete archive log file (rman 8.1.7.4)
Originally posted by puneet1
backup
filesperset 20
format '/BACKUP/db1/rman/archive/db1_al_t%t_s%s_p%p'
archivelog all
delete input;
This command should delete the archived logs when they are backed up.
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
-
Re: how to delete archive log file (rman 8.1.7.4)
Originally posted by puneet1
I have been using following code for level0 archive log RMAN backup on oracle 8.1.7.4. All archived log files are backing up on the disk. I would like to know the best way to delete them from the disk.
sql 'alter system archive log current';
backup
filesperset 20
format '/BACKUP/db1/rman/archive/db1_al_t%t_s%s_p%p'
archivelog all
delete input;
I tried following rman commands but these does not delete archive logs files from the disk or changed the status. List backup is showing all pervious backup with available status.
allocate channel for maintenance type disk;
crosscheck backupset of database;
delete expired backupset;
delete expired backup of archivelog all;
release channel;
Any suggestions?
Thanks,
Puneet
Example:
change archivelog until time 'sysdate-2' delete;
deletes all archive logs older than 48 hours.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|