RE: Applied archives deletion on physical stadby

  • From: Bheemsen Aitha <baitha@xxxxxxxxxxxxxxxxx>
  • To: "nileshkum@xxxxxxxxx" <nileshkum@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 25 Aug 2016 20:35:04 +0000

Here you go.

$ORACLE_HOME/bin/rman target / nocatalog 2>&1 <<EOF
run
{
delete force noprompt archivelog until time 'sysdate-1';
}
EOF

Thanks
Bheem Aitha
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2016