OraFAQ Forum: Backup & Recovery » RMAN RETENTION POLICY FOR ORACLE8I

Home » RDBMS Server » Backup & Recovery » RMAN RETENTION POLICY FOR ORACLE8I

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

RMAN RETENTION POLICY FOR ORACLE8I [message #250931]

Wed, 11 July 2007 21:05

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

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #250988 is a reply to message #250931]

Thu, 12 July 2007 02:23

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There was no retention policy in 8i.
It was a 9i new feature (iirc).

Regards
Michel

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #251038 is a reply to message #250988]

Thu, 12 July 2007 04:25

chara
Messages: 81
Registered: April 2005
Location: th

Member

Thank you for your replied. and how to delete old backup with rman for oracle8i

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #251040 is a reply to message #251038]

Thu, 12 July 2007 04:33

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Recovery Manager User's Guide and Reference
Chapter 10 Recovery Manager Command Syntax
Section change
Option delete

Regards
Michel

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #251858 is a reply to message #250931]

Mon, 16 July 2007 23:59

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

Senior Member

DELETE EXPIRED BACKUP.

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #251983 is a reply to message #251858]

Tue, 17 July 2007 10:50

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Arju wrote on Mon, 16 July 2007 22:59

DELETE EXPIRED BACKUP.

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #251991 is a reply to message #251983]

Tue, 17 July 2007 11:07

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252123 is a reply to message #250931]

Tue, 17 July 2007 22:01

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

Senior Member

I could not understand.........

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252129 is a reply to message #250931]

Tue, 17 July 2007 22:38

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

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252132 is a reply to message #250931]

Tue, 17 July 2007 22:58

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

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252175 is a reply to message #252132]

Wed, 18 July 2007 01:20

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Arju, read my first answer.

Regards
Michel

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252185 is a reply to message #250931]

Wed, 18 July 2007 01:50

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?

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252193 is a reply to message #252185]

Wed, 18 July 2007 02:06

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think the question is clear:

Quote:

How to config RETENTION POLICY for oracle8i

Regards
Michel

Report message to a moderator

Re: RMAN RETENTION POLICY FOR ORACLE8I [message #252236 is a reply to message #252129]

Wed, 18 July 2007 04:54

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.

Report message to a moderator

Previous Topic:	Restoring Database from backup made in noarchivelog mode using RMAN
Next Topic:	exp from D:\ ~ imp to C:\

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 16:35:55 CST 2025