Re: Q:Clean archives after apply them to standby
From: David Ballester <ballester.david_at_gmail.com>
Date: Tue, 13 Jan 2009 18:22:21 +0100
Message-Id: <1231867341.6604.2.camel_at_nebuchaddnezzar>
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.
Date: Tue, 13 Jan 2009 18:22:21 +0100
Message-Id: <1231867341.6604.2.camel_at_nebuchaddnezzar>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 13 2009 - 11:22:21 CST