Use datafile on standby to fix a problem on the primary db.

 Hi all,

   I have a question that related to primary and standby database in RAC.

   I know that the standby db is copy from primary, when operate on primary also effect to standby. I use hot backup at the standby db:

   ---------------------------------------------

   SQL> alter tablespace ABC begin backup;

   SQL> host cp datafile_path/adc_bk.dbf /tmp

   SQL> alter tablespace ABC end backup;

   ---------------------------------------------

   Assume that, on the primary db has a block corrupted. I use BLOCKRECOVER from RMAN:

   

   RMAN> CATALOG DATAFILECOPY '/tmp/abc_bk.dbf';     ----> this is datafile I just copy from  the standby db.

   RMAN> BLOCKRECOVER DATAFILE 7 BLOCK 130;