RE: rman - backup plus archivelog
- From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "peter.schauss@xxxxxxx" <peter.schauss@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 12 Jul 2011 15:35:44 +0000
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@xxxxxxxxxxx]
Sent: Thursday, July 07, 2011 11:27 AM
To: Walker, Jed S; peter.schauss@xxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
