Re: Applied archives deletion on physical stadby

From: Mladen Gogala <gogala.mladen_at_gmail.com>
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-l
Received on Thu Oct 06 2016 - 13:46:37 CEST

Original text of this message