Failure To Convert To Physical Standby

(Doc ID 2085432.1)

Last updated on DECEMBER 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


 Standby database was converted to Snapshot database for testing using  11g Using Snapshot Standby Database. <Document 443720.1>

 Rman backup validate check logical database was run on the database after converting it to Snapshot database which populated v$database_block_corruption

 Converting the standby database back to Physical standby failed with Below error


RMAN> sql 'alter database convert to physical standby';
sql statement : alter databaes convert to physical standby
RMAN-03009: failure of sql command on default channel at 10/27/2015 17:37:29
RMAN-11003: failure during parse/execution of SQL statement: alter database convert to physical standby
ORA-38769: FLASHBACK DATABASE failed after modifying data.
ORA-38746: error occured while restoring data block (file# 12, block# 274273676)
ORA-10564: tablespace AA_BBBB
ORA-01110: data file 12: '+DATA/xxxx/datafile/'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 913146
ORA-38747: corrupt before image (file# 12, block# 274273676)


Select database_role from v$database shows


Indicating the convert to physical standby was not successful.


 Corruption in the Datafile block and flashback log after the database was converted to Snapshot standby


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