Oracle ORA-00600 [krhpfh_03-1209] on convert to SNAPSHOT STANDBY

Hi,

You can get ORA-600 error frequently in Oracle database, this error is internal Oracle error or bug code.

When Convert Standby database to snapshot database you can get below error.

ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

ORA-600 [krhpfh_03-1209]

Solution

Enable flashback and Try to convert again with below steps.

standby>SHUTDOWN IMMEDIATE;
standby>STARTUP MOUNT;
standby>ALTER DATABASE FLASHBACK ON;
standby>ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;