Re: Applied archives deletion on physical stadby
Date: Thu, 6 Oct 2016 07:46:37 -0400
Message-ID: <0c8a7827-a3a4-074e-715b-2fb22758373a_at_gmail.com>
You want to delete logs which have been applied yet? Why would you want to do it? The script is extremely simple
_*cleanup.txt*_
connect target /
connect catalog rcat/<password>_at_rcat
run {
allocate channel c0 device type disk; delete noprompt archivelog all;
}
When you want to run it from the command line, just do the following: rman cmdfile=/my/dir/cleanup.txt. That should do the trick. Regards
On 08/25/2016 04:15 PM, nilesh kumar wrote:
> 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
>
-- Mladen Gogala Oracle DBA Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 06 2016 - 13:46:37 CEST