My Oracle Support Banner

Convert Back to Physical Standby from Snapshot Standby Fails with ORA-38754 (Doc ID 1519030.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1]
Information in this document applies to any platform.


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





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.