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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s