Home » RDBMS Server » Backup & Recovery » RMAN RETENTION POLICY FOR ORACLE8I
RMAN RETENTION POLICY FOR ORACLE8I [message #250931] Wed, 11 July 2007 21:05 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Dear all,

How to config RETENTION POLICY for oracle8i(CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;), same 9i ?

Thanks for advance !
Chara
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #250988 is a reply to message #250931] Thu, 12 July 2007 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There was no retention policy in 8i.
It was a 9i new feature (iirc).

Regards
Michel
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #251038 is a reply to message #250988] Thu, 12 July 2007 04:25 Go to previous messageGo to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Thank you for your replied. and how to delete old backup with rman for oracle8i
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #251040 is a reply to message #251038] Thu, 12 July 2007 04:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recovery Manager User's Guide and Reference
Chapter 10 Recovery Manager Command Syntax
Section change
Option delete

Regards
Michel
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #251858 is a reply to message #250931] Mon, 16 July 2007 23:59 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

DELETE EXPIRED BACKUP.
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #251983 is a reply to message #251858] Tue, 17 July 2007 10:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Arju wrote on Mon, 16 July 2007 22:59
DELETE EXPIRED BACKUP.




Embarassed
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #251991 is a reply to message #251983] Tue, 17 July 2007 11:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DreamzZ wrote on Tue, 17 July 2007 17:50
Arju wrote on Mon, 16 July 2007 22:59
DELETE EXPIRED BACKUP.




Embarassed


Question
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252123 is a reply to message #250931] Tue, 17 July 2007 22:01 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I could not understand.........
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252129 is a reply to message #250931] Tue, 17 July 2007 22:38 Go to previous messageGo to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Thank you for all replied.

If i want to keep rman backup files 3 days and then delete.Could you pls advice!

Thank you
Chara
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252132 is a reply to message #250931] Tue, 17 July 2007 22:58 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

configure in rman

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;


Later use delete obsolete
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252175 is a reply to message #252132] Wed, 18 July 2007 01:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Arju, read my first answer.

Regards
Michel
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252185 is a reply to message #250931] Wed, 18 July 2007 01:50 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Oh!!! I should do that.. I answered only by checking his last one.
Chara do you wanna do it in 8i?
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252193 is a reply to message #252185] Wed, 18 July 2007 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think the question is clear:
Quote:
How to config RETENTION POLICY for oracle8i

Regards
Michel
Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252236 is a reply to message #252129] Wed, 18 July 2007 04:54 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If the OP is on UNIX, they can consider using the script rman1.sh in $O_H/rdbms/demo to manage obsolete backups.
Previous Topic: Restoring Database from backup made in noarchivelog mode using RMAN
Next Topic: exp from D:\ ~ imp to C:\
Goto Forum:
  


Current Time: Tue Dec 06 00:12:03 CST 2016

Total time taken to generate the page: 0.11318 seconds