Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help needed in 8i Retention Period

RE: Help needed in 8i Retention Period

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Thu, 14 Oct 2004 11:08:28 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F98E@exchsen0a1ma>


Arun,

Retention Period is a 9i concept. I don't believe it exists in 8i.

What I do is to perform a backup purge using the following query:

select 'change backuppiece ' || bp.bp_key || ' delete;' from rc_backup_piece bp,rc_database db
where db.name = upper('%1')
and bp.db_id = db.dbid
and bp.start_time < sysdate-30
/

Run this connected as the Rman user. It will generate Rman commands to purge backups that are more than 30 days old. Run the resulting script with

allocate channel for maintenance type 'SBT_TAPE' ;

And you are in business.

Good Luck!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: arun chakrapani rao [mailto:arunrao_oradba_at_yahoo.co.in] Sent: Thursday, October 14, 2004 9:44 AM To: oracle-l_at_freelists.org
Subject: Help needed in 8i Retention Period

Hi Rman Gurus,
Can anybody please let me know how to set the retention period in 8i and also what is the default retention period set in 8i.
I have a NT box here where in I have to configure rman for everyday backup which includes full and incremental backup and the damagement wants to keep one week worth of backup only.
Please let me know how to get this enabled Thanks in Advance
Arun



Yahoo! India Matrimony: Find your life partner online Go to: http://yahoo.shaadi.com/india-matrimony
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 14 2004 - 10:04:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US