Home » RDBMS Server » Backup & Recovery » delete input in RMAN
delete input in RMAN [message #115080] Thu, 07 April 2005 05:56 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
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.
Re: delete input in RMAN [message #115087 is a reply to message #115082] Thu, 07 April 2005 06:21 Go to previous messageGo to next message
srinivenkat
Messages: 7
Registered: April 2005
Location: Bangalore
Junior Member

Hi,

Thank u very much.

I got two solution from u(mahesh),

thank u

By
srinivasan v

[Updated on: Thu, 07 April 2005 06:27]

Report message to a moderator

Re: delete input in RMAN [message #272412 is a reply to message #115082] Fri, 05 October 2007 00:04 Go to previous messageGo to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi Mahesh Rajendran,


The docs which you have pasted for DELETE INPUT AND DELETE ALL INPUT is nice

Thanks it helpled me a lot to understand
thanks
Re: delete input in RMAN [message #272425 is a reply to message #272412] Fri, 05 October 2007 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Moreover it is easy to find it at http://tahiti.oracle.com

Regards
Michel
Re: delete input in RMAN [message #272433 is a reply to message #272425] Fri, 05 October 2007 01:04 Go to previous messageGo to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi Michel

Thanks for the link
Re: delete input in RMAN [message #272436 is a reply to message #272433] Fri, 05 October 2007 01:07 Go to previous message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are many useful links in the OraFAQ Forum Guide.

Regards
Michel
Previous Topic: loss of control files
Next Topic: ora-01031
Goto Forum:
  


Current Time: Fri Nov 28 21:40:32 CST 2014

Total time taken to generate the page: 0.08632 seconds