DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, October 10, 2017

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

No comments: