In Oracle 12c single instance Dataguard environment ,
Standby alert log shows below information;
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Assigned to RFS process (PID:18416050)
RFS[1]: No standby redo logfiles available for T-1
RFS[1]: Opened log for T-1.S-1164 dbid 1226709381 branch 1005380631
Archived Log entry 84 added for thread 1 sequence 1164 rlc 1005380631 ID 0x55f53b9e LAD3 :
Solutions1:
Checked both primary and standby database, the standby redo logs have been created. It is found that the thread id is 1 in both primary and standby db.
Drop all standby online redo logs on standby databases, and recreate then again by excluding “thread 1” .
Finally restart the recovery process, everything is fine.
We have found this kind of error for single instance database in 12c,
which is a new feature or may be bug issue?
Solutions2:
Solutions2:
If you have configured a standby redo log on one or more standby databases in the configuration, ensure the size of the standby redo log files on each standby database exactly matches the size of the online redo log files on the primary database.
At log switch time, if there are no available standby redo log files that match the size of the new current online redo log file on the primary database:
- The primary database will shut down if it is operating in maximum protection mode,or
- The RFS process on the standby database will create an archived redo log file on the standby database and write the following message in the alert log:
No standby log files of size <#> blocks available.
For example, if the primary database uses two online redo log groups whose log files are 100K, then the standby database should have 3 standby redo log groups with log file sizes of 100K.
Also, whenever you add a redo log group to the primary database, you must add a corresponding standby redo log group to the standby database. This reduces the probability that the primary database will be adversely affected because a standby redo log file of the required size is not available at log switch time.
