ORA-16072: a minimum of one standby database destination is requiredThis error is quite usual when using maximum protection and having only 1 standby database.
LGWR: terminating instance due to error 16072
Instance terminated by LGWR, pid = 13720
select open_mode from v$database;
969752 wrote:No. Oracle recommends to have 2 standby database when you are using Maximum Protection mode.
Hi, thanx for ur reply ,
but i m using oracle 10g release 2, as per my knowledge min standby database require for maximum protection mode is 1.
plz correct me if i m wrong .
recommends is NOT the same word as require
oerr ora 16072 16072, 00000, "a minimum of one standby database destination is required" // *Cause: No standby database archive log destinations were specified. // *Action: Specify a standby archive log destination in the initialization // parameter file.
However it makes no sense to Maximum Protection with only one Standby in my opinion.
To ensure data loss cannot occur, the primary database shuts down if a fault prevents it from writing its redo stream to the standby redo log of at least one transactionally consistent standby database.
Oracle says that you require min of 2 standby so that if the standby 1 is not in sync with primary, then atleast standby 2 remains in sync with primary. If both the standbys are out of sync, then Oracle forcefully brings down your primary database.
Note: Oracle recommends that a Data Guard configuration that is running in maximum protection mode contains at least two standby databases that meet the requirements listed in Table 5-2. That way, the primary database can continue processing if one of the standby databases cannot receive redo data from the primary database.