Home » RDBMS Server » Backup & Recovery » RMAN DELETE (AIX 10G)
RMAN DELETE [message #356050] Wed, 29 October 2008 03:34 Go to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
Is there a possibility to say "RMAN" every time when begin the backup delete the old backup. This means that every day before he starts the full back up he will delete the old.
Due to lack of space
Re: RMAN DELETE [message #356052 is a reply to message #356050] Wed, 29 October 2008 03:52 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
No, every backup pieces will be at location. If it is expiration, it or them will be marked as EXPIRED, or if it is obsolete, it or them will be marked as OBSOLETE.

Delete it/them by
RMAN> crosscheck backup;
RMAN> delete expired backup;
RMAN> delete obsolete;
Re: RMAN DELETE [message #356057 is a reply to message #356052] Wed, 29 October 2008 04:21 Go to previous messageGo to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
thanks.

if i run "delete oboselte"
and i configure my rman to 7 days
its wil delete just after 7 days? right?
Re: RMAN DELETE [message #356059 is a reply to message #356057] Wed, 29 October 2008 04:32 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
lioracle wrote on Wed, 29 October 2008 16:21
thanks.
and i configure my rman to 7 days
its wil delete just after 7 days? right?


http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/strategy003.htm#sthref138
Re: RMAN DELETE [message #356190 is a reply to message #356057] Wed, 29 October 2008 21:07 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you saying you only have room for ONE backup ?

If so, how are you going to configure 7 days worth ? Are you doing incrementals ?
Previous Topic: backup ran in two different media causing backup failures
Next Topic: Backup fails: "error writing input to command"
Goto Forum:
  


Current Time: Wed May 01 18:26:31 CDT 2024