Re: unrecoverable datafiles ?
Date: Thu, 27 Aug 2015 14:03:05 +0000
Message-ID: <454901167.1480019.1440684185084.JavaMail.yahoo_at_mail.yahoo.com>
I ran the backup validate command on the standby. Lots of output, but no corruption found on the standby. Also I did a select from v$database_block_corruption when done and it returned no rows. So I have to conclude that the standby database is okay.... but then why does this query, on both primary and standby, still return five rows with Jan/Feb dates?
select file#,unrecoverable_time, unrecoverable_change# from v$datafile whereunrecoverable_time is not null;
Is it possible that the standby is sound but the production/primary database is not?
Thanks all!
From: Chris King <ckaj111_at_yahoo.ca> To: Oracle-l Digest Users <oracle-l_at_freelists.org>; "oracle_at_dunbar-it.co.uk" <oracle_at_dunbar-it.co.uk> Sent: Thursday, August 27, 2015 9:39 AM Subject: Re: unrecoverable datafiles ?
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:
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 27 2015 - 16:03:05 CEST