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