ORA-1156 signalled during: alter database add standby logfile
What are the symptoms?
After creating a physical standby from a RMAN/hot backup you notice that the standby redo logs are missing. You attempt to add a log manually but receive the error ORA-1156.
Alert Log:
Errors in file /app/oracle/admin/scr9/udump/scr9_rfs_25426.trc:
ORA-00313: open failed for members of log group 9 of thread 1
ORA-00312: online log 9 thread 1: '/u01/oradata/scr9/redo/stby_redo_g09m01.log'
ORA-27037: unable to obtain file status
.
.
RFS: No standby redo logfiles created
SQL*Plus:
SQL> alter database add standby logfile group 9
2 ('/u01/oradata/scr9/redo/stby_redo_01.log')
3 size 100m
4 /
ERROR at line 1:
ORA-01156: recovery in progress may need access to files
Why is this happening?
You cannot add standby redo log while the database is in managed recovery mode.
How do I fix it?
Exit managed recovery mode, add the logs, and then reinitiate managed recovery:
alter database recover managed standby database cancel;
alter database add standby logfile group <n> (<filename>) size <size>;
alter database recover managed standby database disconnect;
For more useful DBA queries click here.
| 