20.1 Performing a Rolling Upgrade with a Logical Standby Database

You can use a logical standby database to perform a rolling upgrade of Oracle Database. To incur minimal downtime on the primary database, you can run different releases of Oracle Database on the primary and logical standby databases while you upgrade your databases, one at a time. Oracle Text takes full advantage of upgrading Oracle Text indexes.

All CTX PL/SQL procedures are fully replicated to the standby database and are upgraded, except with certain limitations for these procedures:

See Also:

Oracle Data Guard Concepts and Administration for information on creating a logical standby database to perform rolling upgrades

20.1.1 CTX_DDL PL/SQL Procedures

Oracle Database uses rowids internally for the construction of indexes. The following CTX_DDL procedures are not fully replicated to the standby:

  • ADD_MDATA

  • REMOVE_MDATA

20.1.2 CTX_OUTPUT PL/SQL Procedures

Only CTX_OUTPUT.ENABLE_QUERY_STATS and CTX_OUTPUT.DISABLE_QUERY_STATS are replicated. If you enable Oracle Text logging on the primary database before you run an operation that causes logging, then the operation runs with logging on the primary database and without logging on the secondary database.

20.1.3 CTX_DOC PL/SQL Procedures

When you use the following CTX_DOC procedures with Oracle Text Result Tables, the data stored in the tables is replicated. When these procedures are used without Result Tables, they are not replicated.

  • CTX_DOC.SET_KEY_TYPE

  • CTX_DOC.FILTER

  • CTX_DOC.GIST

  • CTX_DOC.MARKUP

  • CTX_DOC.TOKENS

  • CTX_DOC.THEMES

  • CTX_DOC.HIGHLIGHT

  • CTX_DOC.FILTER_CLOB_QUERY

  • CTX_DOC.MARKUP_CLOB_QUERY

  • CTX_DOC.HIGHLIGHT_CLOB_QUERY

See Also:

Oracle Data Guard Concepts and Administration for information on performing a rolling upgrade for minimal downtime on the primary database