RE: RMAN Retention Policy

2003-12-18 Thread Mercadante, Thomas F
Ian, I think retention policy is new in 9i. I purge my repository of backups that are older than 90 days (because our tape systems rotates and reuses tapes after that time) using the change backuppiece 330783 delete; command. I run a sql script againts the rman repository looking for pieces

RE: RMAN Retention Policy

2003-12-18 Thread Ramón Estevez
Thomas, You are right it's new in 9i Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Sent: Thursday, December 18, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Ian, I think retention policy is new in 9i. I purge my repository of backups that are older

RE: RMAN Retention Policy

2003-12-18 Thread Ruth Gramolini
Did you connect to the target database first? I know this is a simple thing but sometimes we forget. Regards, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MacGregor, Ian A. Sent: Wednesday, December 17, 2003 5:04 PM To: Multiple

RE: RMAN Retention Policy

2003-12-18 Thread MacGregor, Ian A.
Thanks, for the example script. I had already reached the conclusion that change backuppiece ... was needed, but hadn't yet figured how to query for the proper pieces. Ian MacGregor Stanford linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18,