Converting Physical Standby to Transient Logical Standby 10g for upgrading DB to 11.2
edited Jan 15, 2013 2:27AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
I'm trying to use "Converting Physical Standby to Transient Logical Standby 10g for upgrading DB to 11.2" for Grid Control repository DB. Once the physical standby is converted to logical standby, I noticed that oracle has skipped SYSMAN schema as its internal schema. Is it possible to unskip an internal schema completely? I tried unskipping it using below command and got an error,
SQL> EXEC DBMS_LOGSTDBY.UNSKIP(stmt => 'INTERNAL SCHEMA',schema_name => 'SYSMAN', object_name => '%' );
BEGIN DBMS_LOGSTDBY.UNSKIP(stmt => 'INTERNAL SCHEMA',schema_name => 'SYSMAN', object_name => '%' ); END;
*
ERROR at line 1:
ORA-16104: Invalid Logical Standby parameter
SQL> EXEC DBMS_LOGSTDBY.UNSKIP(stmt => 'INTERNAL SCHEMA',schema_name => 'SYSMAN', object_name => '%' );
BEGIN DBMS_LOGSTDBY.UNSKIP(stmt => 'INTERNAL SCHEMA',schema_name => 'SYSMAN', object_name => '%' ); END;
*
ERROR at line 1:
ORA-16104: Invalid Logical Standby parameter
0