RE: rman - backup plus archivelog

From: Walker, Jed S <Jed_Walker_at_cable.comcast.com>
Date: Tue, 12 Jul 2011 15:35:44 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C3B82F126_at_COPDCEXMB08.cable.comcast.com>

Yes, the annoying RMAN-08137. I changed my standby to do the following create global script dg_standby_full
{
backup database plus archivelog;
delete noprompt archivelog all completed before 'sysdate-1'; delete noprompt obsolete;
}

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

From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Thursday, July 07, 2011 11:27 AM
To: Walker, Jed S; peter.schauss_at_ngc.com; oracle-l_at_freelists.org Subject: RE: rman - backup plus archivelog

I'm using the DELETE ALL INPUT option for my backups with Data Guard and it works fine, but I'm running on 10.2.0.4. I think there were some problems in earlier versions where it could cause logs to be deleted before they had been shipped to the standby - not sure exactly what version that was fixed. On my database, if RMAN detects a log is still needed on the standby when the delete command runs, I get this message in the RMAN log:

RMAN-08137: WARNING: archive log not deleted as it is still needed

Regards,
Brandon

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

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Walker, Jed S

backup database plus archivelog delete input;

This will delete the archivelogs that were backed up. If you're running DataGuard then this, in my experience, won't work and you have to use commands like T.J. provided.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

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

Received on Tue Jul 12 2011 - 10:35:44 CDT