Dataguard SKip Handlers with multiple DIsk groups

From: Fuad Arshad <fuadar@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 18 Aug 2010 07:31:42 -0700 (PDT)

I'm trying to figure out how i can add a  skip handler  to account for the 
following Situation

I have 2 Disk Groups 

DATA01
FLASH01

Need them to go in DATA02  on my logical Dataguard environment
I know i can do one to one mapping  by writing the procedure before and 
registering it . Just not sure how to do 2 Disk groups to One Disk group combo.
This Is Oracle 10.2.0.4 on both sides.

CREATE OR REPLACE PROCEDURE SYS.HANDLE_NEWTBS_DDL (
  OLD_STMT  IN  VARCHAR2,
  STMT_TYP  IN  VARCHAR2,
  SCHEMA    IN  VARCHAR2,
  NAME      IN  VARCHAR2,
  XIDUSN    IN  NUMBER,
  XIDSLT    IN  NUMBER,
  XIDSQN    IN  NUMBER,
  ACTION    OUT NUMBER,
  NEW_STMT  OUT VARCHAR2
) AS
BEGIN

-- All primary file specification that contains a directory
-- /usr/local/oracle/database/
-- should go to /usr/orcl/stdby directory specification
   NEW_STMT := REPLACE(OLD_STMT,'+DATA01', '+DATA02');
   ACTION := DBMS_LOGSTDBY.SKIP_ACTION_REPLACE;
 EXCEPTION
  WHEN OTHERS THEN
    ACTION := DBMS_LOGSTDBY.SKIP_ACTION_ERROR;
    NEW_STMT := NULL;
END HANDLE_NEWTBS_DDL;
/
--
//www.freelists.org/webpage/oracle-l

Dataguard SKip Handlers with multiple DIsk groups

Other related posts: