Re: unrecoverable datafiles ?
Date: Thu, 27 Aug 2015 14:58:15 +0100
Message-ID: <7EDF10D1-492B-4B6E-8057-E4DCE6926200_at_dunbar-it.co.uk>
If you built or rebuilt the standby after the latest unrecoverable time then all is well. Those times will remain on the primary for ever now. There's no way to get rid as far as I'm aware. As long as they are prior to force logging and the creation of the standby, all is well.
Cheers,
Norm.
On 27 August 2015 14:39:03 BST, Chris King <ckaj111_at_yahoo.ca> wrote:
>Am I correct then to assume that if I rebuild the standby database that
>the primary database will no longer list the five datafiles from
>January/February as unrecoverable? Or do I have a potential issue with
>the primary database here?
>
>Some history: When building the standby, I did force logging on the
>primary. I do not recall if that was before or after the Jan/Feb
>timeframe.
>
>I will run the rman verification commands to see what happens..
>Thanks all!
>
>
>>I forgot to mention, sorry, your standby database istrash! >The
>unrecoverable transactions that took place on theprimary, back in
>January and February, were never applied to the standby. Ifyou ever
>>need to run the standby as a primary (switchover or failover) or as
>aread only reporting database, then any transactions that try to read
>the >tablesloaded with the unrecoverable data will error out, probably
>as>follows:
-- Sent from my Android device with K-9 Mail. Please excuse my brevity. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 27 2015 - 15:58:15 CEST