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

From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 19 Dec 2009 08:50:13 -0800 (PST)
Message-ID: <636729.92736.qm_at_web80606.mail.mud.yahoo.com>

Or you can use RMAN to create datafile image copy without putting the tablespace in backup mode. It can reduce redo that would otherwise be created.

I don't know if this is completely supported. We opened a TAR with Oracle. I vaguely remember the analyst said it was not supported. But we did it many times on fairly busy databases without issues. SQL trace on the RMAN image copy session couldn't reveal any secret. It has "RPC CALL:FUNCTION SYS.DBMS_BACKUP_RESTORE..." etc.

(Credit to my former coworker FLou)

Yong Huang

-----Original Message-----

Chris,

You do NOT need to rebuild the standby. If you the put tablespace that had the issues into backup mode on the primary, and then copy the datafiles to the standby (i.e., replacing the existing datafiles which have the corruption), you can then resume recovery on the standby without issue. Be sure to take the tablespace out of backup mode on the primary after copying.       

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

Received on Sat Dec 19 2009 - 10:50:13 CST