ALTER DATABASE CONVERT TO PHYSICAL STANDBY Fails w/ ORA-600 [krhpfh_03-1209]
(Doc ID 2029557.1)
Last updated on APRIL 03, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
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
Information in this document applies to any platform.
Running 'alter database convert to physical standby' on a database that has been flashed back will fail with ORA-600 [krhpfh_03-1209].
The 'flasbhack database to restore point' was issued more than once. The first attempt was successfull but a second attempt would then fail with:
ORA-38795: warning: FLASHBACK succeeded but OPEN RESETLOGS would get error below
ORA-01190: control file or data file 1 is from before the last RESETLOGS
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