ORA-16789: missing standby redo logs

DGMGRL> EDIT DATABASEĀ cobra SET PROPERTY ‘LogXptMode’=’SYNC’;

Property “LogXptMode” updated


DGMGRL> EDIT DATABASE cobrastd SET PROPERTY ‘LogXptMode’=’SYNC’;
Error: ORA-16789: missing standby redo logs

SOL: ORA-16789

On standby run following commands:

Cancel managed recovery:
SQL> recover managed standby database cancel ;

create standby redo logs:

SQL>ALTER DATABASE ADD STANDBY LOGFILE GROUP 1 ‘/data02/cobrastd/redo01std.log’ SIZE 300M;

SQL>ALTER DATABASE ADD STANDBY LOGFILE GROUP 2 ‘/data02/cobrastd/redo02std.log’ SIZE 300M;

SQL>ALTER DATABASE ADD STANDBY LOGFILE GROUP 3 ‘/data02/cobrastd/redo03std.log’ SIZE 300M;

Now put standby database in recovery mode:

SQL>alter database recover managed standby database disconnect from session;

NOTEĀ : Standby online redo logs are required in Maximum Protection and Maximum Availability mode.

ORA-16789 ORA-16789

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply