Home » RDBMS Server » Backup & Recovery » RMAN - delete archivelogs
RMAN - delete archivelogs [message #73821] Mon, 19 July 2004 13:25 Go to next message
Slow Poke
Messages: 7
Registered: July 2004
Junior Member
When using the "backup archive all delete input" command does this delete archive logs in all locations?

Are there variations to the delete?

 
Re: RMAN - delete archivelogs [message #73823 is a reply to message #73821] Tue, 20 July 2004 03:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
BACKUP ARCHIVELOG ALL DELETE INPUT;

command can delete archived redo logs, datafile copies, and backup sets
after backing them up. RMAN backs up one and only one copy of each log sequence number, and then deletes the file that it backs up.

If you specify the DELETE ALL INPUT option, then RMAN deletes whichever
files match the criteria that you specify, even if there are several
files of the same log sequence number. For example, assume that you
archive to 3 different directories. Then, you issue

BACKUP ARCHIVELOG ALL FROM SEQUENCE 1200 DELETE ALL INPUT;

In this case, RMAN backs up only one copy of each log sequence between 1200 and the most recent sequence, but deletes all logs with these sequence numbers contained in the three archive destinations
Re: RMAN - delete archivelogs [message #73828 is a reply to message #73823] Tue, 20 July 2004 07:46 Go to previous message
Slow Poke
Messages: 7
Registered: July 2004
Junior Member
Thanks for the info. This will help.
Does the DELETE INPUT command delete only from the log_archive_dest_1 specified in the init.ora?
Previous Topic: Why RMAN
Next Topic: How to do point-in-time incomplete recovery with rman?
Goto Forum:
  


Current Time: Wed Nov 27 14:23:45 CST 2024