Re: Applied archives deletion on physical stadby
- From: "Laimis Nd" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "laimisnd" for DMARC)
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 Oct 2016 10:56:03 +0000 (UTC)
read about FRA (flashback recovery area)
For the automation to work (decently) the logs have to sit on FRA.
The documentation is quite messy but it can be sorted out eventually.
/Laimis
On Thursday, August 25, 2016 11:42 PM, Seth Miller
<sethmiller.sm@xxxxxxxxx> wrote:
delete force noprompt archivelog until time 'sysdate-1';
Do not do that!
Run this command in RMAN on your primary and all your standbys. Standard RMAN
delete commands will not delete archivelogs on the primary or the standbys that
have not yet been applied.
configure archivelog deletion policy to applied on all standby;
Seth Miller
On Thu, Aug 25, 2016 at 3:35 PM, Bheemsen Aitha <baitha@xxxxxxxxxxxxxxxxx>
wrote:
Here you go. $ORACLE_HOME/bin/rman target / nocatalog 2>&1 <<EOFrun{delete
force noprompt archivelog until time 'sysdate-1';}EOF ThanksBheem AithaFrom:
oracle-l-bounce@xxxxxxxxxxxxx [
mailto:oracle-l-bounce@ freelists.org]On Behalf ;
Of nilesh kumar
Sent: Thursday, August 25, 2016 1:16 PM
To: ORACLE-L
Subject: Applied archives deletion on physical stadby Hello Gurus, We have
built the physical standby database 11.2.0.4 on windows 2012 R2.We have backups
configured only at Primary site.I am looking for any script which can be put as
a Batch/bat file and get executed on intervals and deletes the applied archives
from the physical standby database.Could you please share any such script.
-- Thanks & Regards
Nilesh
Other related posts:
