OraFAQ Forum: Backup & Recovery » delete input in RMAN

Home » RDBMS Server » Backup & Recovery » delete input in RMAN

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

delete input in RMAN [message #115080]

Thu, 07 April 2005 05:56

srinivenkat
Messages: 7
Registered: April 2005
Location: Bangalore

Junior Member

Hi,

Let me know what is the purpose of all delete input in RMAN,

RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;

What is the purpose of giving that,whether it's necessary to give this.

Thanks

By
srinivasan v

[Updated on: Thu, 07 April 2005 05:57]

Report message to a moderator

Re: delete input in RMAN [message #115082 is a reply to message #115080]

Thu, 07 April 2005 06:00

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

quoting docs.

You can specify the DELETE INPUT option in the BACKUP command, which deletes the archived logs after backing them up. Thus, you can back up archived logs to tape and clear disk space of old logs in one step. RMAN only deletes the specific copy of the archived redo log that it backs up, and then deletes only this copy.

If you specify the DELETE ALL INPUT option, then RMAN makes a backup of each specified log sequence number, but deletes logs from all enabled archiving destinations. For example, assume that you archive to /arc_dest1, /arc_dest2, and /arc_dest3, and you run the following command:

BACKUP ARCHIVELOG ALL DELETE ALL INPUT;

RMAN backs up only one copy of each log sequence number that it finds in these directories, and then deletes all copies of all logs that it finds in these directories. If you had specified DELETE INPUT rather than DELETE ALL INPUT, then RMAN would only delete the specific disk copy that it backed up (for example, only the logs in /arc_dest1).

Note that if you issue BACKUP ARCHIVELOG ALL or BACKUP ARCHIVELOG LIKE '...', and if no archived redo logs exist, then RMAN does not signal an error.

Report message to a moderator