Resolve Adding redolog issues in RAC db: ORA-01156, ORA-01275

Issue Not allowing to add new redolog

SQL> ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 3 ('+FRA/PROD/ONLINELOG/redo3a.log') size 200M reuse;
ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 3 ('+FRA/PROD/ONLINELOG/redo3a.log') size 200M reuse
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files


Solution:

Cancel the recovery mode if you are recovering your standby database.

SQL> alter database recover managed standby database cancel;

Database altered.

Then you may face the below issue...

SQL> ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 3 ('+FRA/PROD/ONLINELOG') size 200M;
ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 3 ('+FRA/PROD/ONLINELOG') size 200M
*
ERROR at line 1:
ORA-01275: Operation ADD LOGFILE is not allowed if standby file management is automatic.


Change standby_file_management value "AUTO" to MANUAL.

SQL> alter system set standby_file_management=MANUAL;

System altered.


When I did the above, then my below commands worked.

SQL> ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 3 ('+FRA/PROD/ONLINELOG/redo3a.log') size 200M;

Database altered.

SQL> ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 4 ('+FRA/PROD/ONLINELOG/redo4b.log') size 200M;

Database altered.

SQL>