RE: Force Logging and Standby's 10g Solaris 64

  • From: FMHabash <fmhabash@xxxxxxxxx>
  • To: <TESTAJ3@xxxxxxxxxxxxxx>, <cjnewman@xxxxxxxxxxxxx>
  • Date: Thu, 17 Dec 2009 18:14:47 -0500

Nologging will invalidate your physical standby since it is no longer a 
block-by-block copy of the primary. 
Fast way is to identify all files that witnessed this operation by checking 
'v$datafile.unrecoverable_time'  and just copy these files over and resume 
recovery.


-----Original Message-----
From: TESTAJ3@xxxxxxxxxxxxxx
Sent: Thursday, December 17, 2009 2:34 PM
To: cjnewman@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
Subject: Re: Force Logging and Standby's 10g Solaris 64

I personally would rebuild it, unfortunately since you're not in 11g, you 
can't just take a copy of the current database but I'l defer my answer as 
a hard/fast rule based on what others say.

joe

_______________________________________
Joe Testa, Oracle Certified Professional 
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.




From:
"Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
To:
<oracle-l@xxxxxxxxxxxxx>
Date:
12/17/2009 02:32 PM
Subject:
Force Logging and Standby's 10g Solaris 64
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx



Hi List,

Quick Q:  We've a dataguard physical standby that we cloned, and the
clone bonked on:

GATHER_STATS_JOB encountered errors.  Check the trace file.
Errors in file
/u01/app/oracle/admin/DSTEST01/bdump/dstest01_j001_10559.trc:
ORA-01578: ORACLE data block corrupted (file # 185, block # 36931)
ORA-01110: data file 185: '/u07/oradata/DSTEST01/edwindx37_4m.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option 

We see this error multiple times, all for various datafiles within one
of our index tablespaces.


I checked the primary and oops, it appears that it was *not* in force
logging mode.  This has since been corrected, but my question is this:
Do we have to rebuild the standby to ensure consistency?  There are zero
errors on the physical standby, and the only indication of a problem is
the above after a cloning operation.

Thanks- Chris

--
//www.freelists.org/webpage/oracle-l





--
//www.freelists.org/webpage/oracle-l


Other related posts: