Convert Back to Physical Standby from Snapshot Standby Fails with ORA-38754

(Doc ID 1519030.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.6 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

Resolve ORA-38754 and ORA-38729 while convert from snapshot standby to back to Physical standby.

 

11/23/2012 12:17:34

DMON Registering service chicago_DGB with listener(s)

Broker Configuration:       "boston"

      Protection Mode:            Maximum Performance

      Fast-Start Failover (FSFO): Disabled, flags=0x0, version=24

      Primary Database:           boston (0x01010000)

      Standby Database:           chicago, Enabled Snapshot Standby (0x02010000)

11/23/2012 12:17:37

Creating process RSM0

11/23/2012 12:18:30

Data Guard notifying Oracle Clusterware of database role change

SQL Execution error=604, sql=[alter database convert to physical standby]. See error stack below.

 

  ORA-00604: error occurred at recursive SQL level 1

  ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

  ORA-38762: redo logs needed for SCN 5027980 to SCN 5104030

  ORA-38761: redo log sequence 393 in thread 1, incarnation 2 could

Database Resource SetState Error (38754)

Command CONVERT DATABASE chicago completed with error ORA-38754

 

 

11/27/2012 09:55:07

Data Guard notifying Oracle Clusterware of database role change

conversion to physical standby requires this database be restarted to the mounted state

Command CONVERT DATABASE chicago completed with warning ORA-16570

 

Cause

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 hundreds of Community platforms