RE: Help needed in 8i Retention Period
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'arunrao_oradba@xxxxxxxxxxx'" <arunrao_oradba@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 14 Oct 2004 11:08:28 -0400
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@xxxxxxxxxxx]
Sent: Thursday, October 14, 2004 9:44 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
