Standby Redo log File Creation and Error Troubleshoot

SQL> /

ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 'E:\ORACLE\ORADATA\TESTPRD\REDO_ST

BY_04.LOG' SIZE 50M

*

ERROR at line 1:

ORA-01156: recovery or flashback in progress may need access to files 

Cause- Above error came because managed recovery is active

Action - Stop managed recovery

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 'E:\ORACLE\ORADATA\TESTPRD\REDO_STBY_04.LOG' SIZE 50M;

ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 'E:\ORACLE\ORADATA\TESTPRD\REDO_STBY_04.LOG' SIZE 50M

*

ERROR at line 1:

ORA-01184: logfile group 4 already exists

SQL> select group# from v$standby_log;

    GROUP#

----------

         4

         5

         6

Cause - Above error came because file was not present physically but due to controlfile restoration from Primary, it was having Standby Redo Log file 

Action - First Delete  Standby then recreat it.

SQL> ALTER DATABASE drop STANDBY LOGFILE GROUP 4;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 'E:\ORACLE\ORADATA\TESTPRD\REDO_STBY_04.LOG' SIZE 50M;

Database altered.