I'm trying to create a standby database. I used RMAN backup and restore. I mostly followed below documentation:
https://dbatricksworld.com/steps-to-configure-oracle-11g-data-guard-physical-standby-data-guard-part-i/
I have tried it a few times and I always get the same problem. Archive logs are shipped to the standby but not applied.
On the primary database alert I do not see any errors.
On the standby database alert I see errors:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/home/oracle/app/fast_recovery_area/DBNAME/onlinelog/redo02b.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
I noticed that online logs were not created on standby. I tried to drop them and recreate them but I'm getting error:
alter database drop logfile group 2
*
ERROR at line 1:
ORA-01623: log 2 is current log for instance rcudb (thread 1) - cannot drop
ORA-00312: online log 2 thread 1: '/oradata/DBNAME/redo02a.log'
ORA-00312: online log 2 thread 1:
'/home/oracle/app/fast_recovery_area/DBNAME/onlinelog/redo02b.log'
alter database clear logfile group 2
*
ERROR at line 1:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 2 thread 1: '/oradata/DBNAME/redo02a.log'
Why is using online logs? I create standby logs.