Re: Q:Clean archives after apply them to standby
- From: David Ballester <ballester.david@xxxxxxxxx>
- To: Amihay.Gonen@xxxxxxxxxxx
- Date: Tue, 13 Jan 2009 18:22:21 +0100
El mar, 13-01-2009 a las 11:42 +0200, Amihay Gonen escribió:
> Hi , I’m looking for “best practice ” advices from the real world.
>
>
>
> I’ve a setup with Primary and standby database (unix solaris ,
> 10.2.0.4) .
>
> I want to clean the archives (from primary and standby ) which has
> been applied successfully on the standby .
>
>
>
> If anyone has an script/pl\sql which has work good for him/her . I
> would like to hear.
>
>
>
> Thanks in advance .
>
>
>
> Amihay Gonen,
>
> DBA
On the standby site, as sysdba execute a select to obtain the
max(sequence#) from the v$archived_log where appplied value is
affirmative.
With this value call an rman script that will execute a delete
archivelog until sequence <the max() value returned >
HTH
D.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
