ORA-01275: Operation ADD LOGFILE is not allowed if standby file management is automatic.
Cause:
Adding logfile in physical standby database thrown error saying that operation was halted due to automatic file management of database files. Since setting ‘ standby_file_management ‘ to auto will automatically manage database files by oracle itself, DBA cannot manually intervene
SQL> alter database add logfile '/u01/ORCLDGP/onlinelog/group_10.267.1031504655';
alter database add logfile '/u01/ORCLDGP/onlinelog/group_10.267.1031504655'
*
ERROR at line 1:
ORA-01275: Operation ADD LOGFILE is not allowed if standby file management is
automatic.
Solution:
Modify the auto file management of parameter to manual temporarily
SQL> alter system set standby_file_management='MANUAL';
System altered.
Add the logfiles manually
SQL> alter database add logfile '/u01/ORCLDGP/onlinelog/group_10.267.1031504655' size 50M;
Database altered.
SQL> alter database add logfile '/u01/ORCLDGP/onlinelog/group_11.268.1031504661' size 50M;
Database altered.
SQL> alter database add logfile '/u01/ORCLDGP/onlinelog/group_12.269.1031504669' size 50M;
Database altered.
SQL> alter database add logfile '/u01/ORCLDGP/onlinelog/group_13.270.1031504675' size 50M;
Database altered.
Enable the auto management of database files
SQL> alter system set standby_file_management='AUTO';
System altered.