RE: Grid control rman backup not deleting old backups or archive logs

We are backing up to a SAN drive and using TSM to backup the files off line. (This is a relatively small database, about 65 gb, so we are not doing incrementals.

• Peter Schauss

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

From: Patterson, Joel [mailto:jpatterson_at_entint.com] Sent: Tuesday, May 28, 2013 12:02 PM
To: Schauss, Peter (ESS); oracle-l_at_freelists.org Subject: EXT :RE: Grid control rman backup not deleting old backups or archive logs

Just to check a couple things. Are you backing up to a Network drive -- (if so I assume the oracle service is not Local System). Are you doing incrementals?

Joel Patterson
Database Administrator
904 928-2790

--

Joel Patterson
Sr. Database Administrator | Enterprise Integration Phone: 904-928-2790 | Fax: 904-733-4916
http://www.entint.com/

http://www.entint.com/

http://www.facebook.com/pages/Enterprise-Integration/212351215444231 http://twitter.com/#!/entint http://www.linkedin.com/company/18276?trk=tyah http://www.youtube.com/user/ValueofIT

This message (and any associated files) is intended only for the use of the addressee and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient, you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. [v.1.1]

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter (ESS) Sent: Tuesday, May 28, 2013 11:19 AM
To: oracle-l_at_freelists.org
Subject: Grid control rman backup not deleting old backups or archive logs

This is Oracle 11.2.0.3 running on Windows Server 2003 v 5.2 SP2 (64 bit), Grid Control 11g.

Under backup settings -> policy I specified:

        Retain at least 2 backups
        Retain archived redo logs after they have been backed up twice.
        I also specified backup of the control file and verified from the log files that it is being backed up.

Under schedule backup I specified a customized backup, checking off datafiles and archived logs.

I am using the control file as the repository.

I tested my backup by cloning the database from the backup set. (Was that a valid test?)

Looking at the folders where the backups and archive logs are stored, I see that the job is not deleting the backups and archive logs older than 2 days. On my UNIX servers my rman script does this automatically. Do I have to create a separate Grid Control job for this?

Thanks,
Peter Schauss

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 29 2013 - 20:13:32 CEST