Streams arch log recover scenario
From: Prabhu Krishnaswamy <prabhu_adam_at_hotmail.com>
Date: Wed, 16 Mar 2011 13:56:24 +0000
Message-ID: <BAY160-w471752530E4AE725DC195985CE0_at_phx.gbl>
Date: Wed, 16 Mar 2011 13:56:24 +0000
Message-ID: <BAY160-w471752530E4AE725DC195985CE0_at_phx.gbl>
Lists,
We have the following scenario to be tested....
How to recover from FULL archive destination situation when
Target is down or streams replication is so slow that RMAN can't delete archives since they needed by streams. RMAN doesn't allow deletion of any archives if they are needed for streams replication
What should be the action from DBAs
- compromise Source db by manually moving or removing archives since RMAN can't delete it, it will allow you to backup though
- compromise the streams setup and Target by disabling streams replication, but will that allow RMAN to delete archives or you need additional steps ? Or additional action needed
Any insight on this will be highly appreciated !!!
Thank You,
Prabhu
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 16 2011 - 08:56:24 CDT