OraFAQ Forum: Backup & Recovery » How Can Get Which Backup unnesessary to Delete Using RMAN

Home » RDBMS Server » Backup & Recovery » How Can Get Which Backup unnesessary to Delete Using RMAN

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

How Can Get Which Backup unnesessary to Delete Using RMAN [message #254196]

Thu, 26 July 2007 02:28

jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI

Member

Hi all,
Sir i am new in DBA track.
i want to know that which backup is unnesassary to Delete.
for the purposr of use of Reclaimable Space.

is Outdated Backup Delete Manualy or We Can configure RMAN policy to
auto delete outdated backup.

pls help me;

Jai

Report message to a moderator

Re: How Can Get Which Backup unnesessary to Delete Using RMAN [message #254200 is a reply to message #254196]

Thu, 26 July 2007 02:36

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle� Database Backup and Recovery Basics
Chapter 2 Backup and Recovery Strategies
Section 2.3 Planning Backup Strategy
Subsection 2.3.5 Choosing a Backup Retention Policy

Regards
Michel

Report message to a moderator

Re: How Can Get Which Backup unnesessary to Delete Using RMAN [message #254207 is a reply to message #254196]

Thu, 26 July 2007 02:56

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You can keep recent 3 days backup and delete backup older than 3 days by issuing two commands.

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;

DELETE OBSOLETE

Report message to a moderator

Previous Topic:	Rman recovery its urgent
Next Topic:	Rman restore control files with oracle8.1.7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 02 21:05:33 CDT 2024