One thing i forgot to tell was, these databases are
not connected to catalog database hence i have to rely
on controlfile itself.
The only way i know is to alter the parameter for
keeping the controlfile record.
But for purging these old records i thought there
might be some way just like setting the 9i retention
period policy and delete the obsolete or expired.
Thanks for the help Thomas
Will run the query which u sent and work on it
Thanks again
Arun
- "Mercadante, Thomas F"
<thomas.mercadante_at_labor.state.ny.us> wrote:
> 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
>
Yahoo! India Matrimony: Find your life partner online
Go to:
http://yahoo.shaadi.com/india-matrimony
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 14 2004 - 14:38:03 CDT
