RE: Grid control rman backup not deleting old backups or archive logs
- From: "Patterson, Joel" <jpatterson@xxxxxxxxxx>
- To: "Schauss, Peter (ESS)" <peter.schauss@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 May 2013 15:20:29 -0400
Ok, that was just to see if the archive logs needed to go back to the level 0
day..
The user running the oracle service was so that you can write to network drives
which it appears you can, so it is not local system.
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: Schauss, Peter (ESS) [mailto:peter.schauss@xxxxxxx]
Sent: Wednesday, May 29, 2013 2:14 PM
To: Patterson, Joel; oracle-l@xxxxxxxxxxxxx
Subject: RE: Grid control rman backup not deleting old backups or archive logs
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
