My Oracle Support Banner

ORA-01219 While Implementing Fast Offline Encryption on 11.2.0.4 Standby Database (Doc ID 2417543.1)

Last updated on JULY 13, 2018

Applies to:

Advanced Networking Option - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Oracle Database 11.2.0.4 with Data Guard:

Trying to offline encrypt a Data Guard standby database using the following white paper:

  "Converting to Transparent Data Encryption with Oracle Data Guard using Fast Offline Conversion
  Oracle Database 12.1 and Oracle Database 11.2"
  http://www.oracle.com/technetwork/database/availability/tde-conversion-dg-3045460.pdf

At the "Convert Data Files" step (on page 9 of the PDF), queries on the standby fail with:
 
 ORA-01219: database not open: queries allowed on fixed tables/views only



Changes

The standby database was put into MOUNT mode.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.