ORA-16501: The Oracle Data Guard broker operation failed.

 

ERROR:

CREATE CONFIGURATION my_dg_config AS PRIMARY DATABASE IS bvtb CONNECT IDENTIFIER IS bvtb;
Error: ORA-16501: The Oracle Data Guard broker operation failed.
Error: ORA-16625: cannot reach database "dktb"

SOLUTION:

Check log tại đường dẫn

cat /u01/app/oracle/diag/rdbms/bvtb/bvtb/trace/drcbvtb.log

Nếu báo lỗi

Failed to mount standby database.
Database Resource SetState Error (16746)
SQL Execution error=604, sql=[ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT  NODELAY]. See error stack belo

Thì chạy câu lệnh sau

alter database recover managed standby database using current logfile disconnect from session;

Related posts

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB

ORA-16086: Redo data cannot be written to the standby redo log