Home » RDBMS Server » Backup & Recovery » How Can Get Which Backup unnesessary to Delete Using RMAN
How Can Get Which Backup unnesessary to Delete Using RMAN [message #254196] Thu, 26 July 2007 02:28 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
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 Go to previous message
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
Previous Topic: Rman recovery its urgent
Next Topic: Rman restore control files with oracle8.1.7
Goto Forum:
  


Current Time: Sat Dec 10 05:02:25 CST 2016

Total time taken to generate the page: 0.27090 seconds