STANDBY- ORA-01275: Operation RENAME is not allowed if standby file management is automatic

Issue:-

While re-locating oracle datafile’s below error we are getting.

SQL> alter database rename file ‘/u01/oradata/SAMPLE/data10.dbf’ to ‘/u04/oradata/SAMPLE/data10.dbf’;
alter database rename file ‘/u01/oradata/SAMPLE/data10.dbf’ to ‘/u04/oradata/SAMPLE/data10.dbf’
*
ERROR at line 1:
ORA-01275: Operation RENAME is not allowed if standby file management is
automatic.

Cause:-

The standby file_management is set to auto on standby database.

Solution:

Run below command and try to re-run the query

alter system set standby_file_management=manual

once re-locating of datafile completed you can change back to “AUTO”

alter sytem set standby_file_management=auto

  • October 9, 2017 | 37 views
  • Comments