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

  • From: Yong Huang <yong321@xxxxxxxxx>
  • To: terrysutton@xxxxxxx
  • Date: Sat, 19 Dec 2009 08:50:13 -0800 (PST)

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.


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


Other related posts: