High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Upgrade from 11.1.0.7 to 11.2.0.3 Using Logical Standby

I am planning an upgrade from 11.1.0.7 to 11.2.0.3 on AIX.  To minimize downtime, I am looking at doing the upgrade with a logical standby using SQL Apply.  In reading the procedures for performing the upgrade in chapter 12 of the Data Guard Concepts and Administration manual, I followed the procedure to identify unsupported data types and storage attributes:

SELECT DISTINCT OWNER, TABLE_NAME FROM DBA_LOGSTDBY_UNSUPPORTED;

This query returned the following:

OWNER                          TABLE_NAME
------------------------------ ------------------------------
REPORTDELIVERY                 REPORT
REPORTDELIVERY                 SPECIMEN

Each of the two tables identified above contains three columns (two NUMBER and one VARCHAR2).

I am trying to determine why these tables are showing up in DBA_LOGSTDBY_UNSUPPORTED.  Any suggestions will be appreciated.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center