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

  • From: "Schauss, Peter (ESS)" <peter.schauss@xxxxxxx>
  • To: "Patterson, Joel" <jpatterson@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 29 May 2013 18:13:32 +0000

Joel,

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@xxxxxxxxxx] 
Sent: Tuesday, May 28, 2013 12:02 PM
To: Schauss, Peter (ESS); oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Schauss, Peter (ESS)
Sent: Tuesday, May 28, 2013 11:19 AM
To: oracle-l@xxxxxxxxxxxxx
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


Other related posts: