If
error is Warning: ORA-16789: standby redo logs not configured
DGMGRL>
DGMGRL> show configuration
Configuration
- abcprd
Protection Mode: MaxPerformance
Databases:
fc_abcprd - Primary database
Warning: ORA-16789: standby redo logs not
configured
dr_abcprd - Physical standby database
Error: ORA-16525: the Data Guard broker
is not yet available
Fast-Start
Failover: DISABLED
Configuration
Status:
ERROR
DGMGRL>
Add
Standby redo log group on to Primary db
as well as DR site:
SQL>
ALTER DATABASE ADD STANDBY LOGFILE '/oradata/ABCPRD/stdby_redo04.log'
size 50M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE
'/oradata/ABCPRD/stdby_redo05.log' size 50M;
SQL>
ALTER DATABASE ADD STANDBY LOGFILE '/oradata/ABCPRD/stdby_redo06.log'
size 50M;
And on DR Site:
SQL>
alter database recover managed standby database cancel;
SQL> ALTER DATABASE ADD STANDBY LOGFILE
'/oradata/ABCPRD/stdby_redo04.log' size 50M;
SQL>
ALTER DATABASE ADD STANDBY LOGFILE '/oradata/ABCPRD/stdby_redo05.log'
size 50M;
SQL>
ALTER DATABASE ADD STANDBY LOGFILE '/oradata/ABCPRD/stdby_redo06.log'
size 50M;
After the above steps completion start DR in managed recovery:
SQL>
alter database recover managed standby database disconnect from session;
On
primary now run the dgmgrl :
DGMGRL> show configuration;
Configuration
- abcprd
Protection Mode: MaxPerformance
Databases:
fc_abcprd - Primary database
dr_abcprd - Physical standby database
(disabled)
Fast-Start
Failover: DISABLED
Configuration
Status:
SUCCESS
If
error is below after above steps then on Primary site
Warning: ORA-16826:
apply service state is inconsistent with the DelayMins property
DGMGRL>
remove database DR_ABCPRD;
Removed
database "dr_abcprd" from the configuration
DGMGRL>
add database DR_ABCPRD as connect identifier is
DR_ABCPRD maintained as physical;
Database
"dr_abcprd" added
Then
Run :
Show
configuration
It should not show any error message after that. But if you are still facing any issue then please leave a message to me, will try to help you.
Regards,
Amaresh
