Home » RDBMS Server » Backup & Recovery » 9i RMAN - Recovery Window (What is it in simple words?)
9i RMAN - Recovery Window (What is it in simple words?) [message #73255] Tue, 09 March 2004 12:27 Go to next message
IA
Messages: 91
Registered: March 2004
Member
Hi,

In Oracle 9i manual, it specifies that we can set retention policies.

Example:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;

What does this mean in simple terms? Does this mean we need a backup that is no older than 5 days from the current date? Therefor, should we perform a backup everyday and delete backups older than 5 days?

Thanks ... IA
Re: 9i RMAN - Recovery Window (What is it in simple words?) [message #73259 is a reply to message #73255] Wed, 10 March 2004 04:58 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

It means that RMAN will mark files NOT REQUIRED for a restore (files what will be used if you need to restore the DB to a point in time longer than 5 days ago) and mark them as obsolete. Obsolete files will remain in the catalog, however, you can purge them using the DELETE OBSOLETE command.

Best regards.

Frank
Re: 9i RMAN - Recovery Window (What is it in simple words?) [message #73271 is a reply to message #73259] Sun, 14 March 2004 19:42 Go to previous message
IA
Messages: 91
Registered: March 2004
Member
Thanks Frank ... makes sense!

Cheers IA.
Previous Topic: duplicate prod db w/RMAN
Next Topic: Restore without archive logs
Goto Forum:
  


Current Time: Thu Mar 28 11:42:50 CDT 2024