My Oracle Support Banner

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

Last updated on OCTOBER 09, 2019

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

 

 

 

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 <service_name> with listener(s)

Broker Configuration:       "<primary_db_unique_name>"

      Protection Mode:            Maximum Performance

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

      Primary Database:           <primary_db_unique_name> (0x01010000)

      Standby Database:           <standby_db_unique_name>, 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 <standby_db_unique_name> 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 <standby_db_unique_name> completed with warning ORA-16570

 

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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