Home » RDBMS Server » Backup & Recovery » backup policy (10.2.0.2)
backup policy [message #354640] Mon, 20 October 2008 11:42 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
I am taking rman full backup every night.
Retention Policy is configured to redundancy 1.
I want to delete backup sets everyday.This can be done 
If I give command delete obsolete in RMAN script.
Right now I am  using following command for archivelog backup:-
backup archivelog all not backed up 1 times;
delete noprompt archivelog all completed before 'sysdate-3' 
 backed up 1 times to device type disk;
With delete obsolete archivelogs backup will never be deleted
with redundancy 1.
I want RMAN to delete archivelogs backups after 7 days from 
the disk to save the disk space.
Please suggest me how can I acheive this.


Regards,
Varun Punj,


Re: backup policy [message #354655 is a reply to message #354640] Mon, 20 October 2008 12:08 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You could perform the following delete:

delete noprompt backup of archivelog until time 'sysdate-7'; 

[Updated on: Mon, 20 October 2008 12:13]

Report message to a moderator

Re: backup policy [message #354668 is a reply to message #354655] Mon, 20 October 2008 13:15 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thank you Ebrian.
Re: backup policy [message #354669 is a reply to message #354655] Mon, 20 October 2008 13:24 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Ebrian,
With this policy RMAN wiil be aware of archive logs needed
by streams and it wont delete those.Is it right?
Regards,
Varun Punj,
Re: backup policy [message #354680 is a reply to message #354669] Mon, 20 October 2008 16:34 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Ahhhh...that's right, you had the Streams environment.

The delete is in regards to backups of the archivelogs and therefore, will not have any impact on Streams.
Previous Topic: sql to oracle transfer using full convert
Next Topic: Adding datafile to Standby
Goto Forum:
  


Current Time: Sun Apr 28 04:57:48 CDT 2024