备库转移数据文件需要将Auto转换为Manual模式

环境:

OS:Red Hat Linux As 5

DB:10.2.0.4

DG:物理DG

 

1. 备库是在mount状态

SQL> select status from v$instance;

STATUS
------------
MOUNTED

 

2.操作系统上迁移数据文件

[oracle@hxlbak oracl]$ mv '/u02/app/oracle/oradata/oracl/hxl06.dbf' '/u02/app/oracle/oradata/oraclbak/hxl06.dbf'

 

3.迁移数据文件

SQL> alter database rename file '/u02/app/oracle/oradata/oracl/hxl06.dbf' to
'/u02/app/oracle/oradata/oraclbak/hxl06.dbf';  2 
alter database rename file '/u02/app/oracle/oradata/oracl/hxl06.dbf' to
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01275: Operation RENAME is not allowed if standby file management is
automatic.

4. 查看standby_file_management的模式

SQL> show parameters standby

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest                 string      ?/dbs/arch
standby_file_management              string      AUTO

 

5.修改为手工模式

SQL> alter system set standby_file_management=manual scope=both;

System altered.

 

6. 迁移成功

SQL> alter database rename file '/u02/app/oracle/oradata/oracl/hxl06.dbf' to
'/u02/app/oracle/oradata/oraclbak/hxl06.dbf'; 

 

Database altered.

 

7.数据库可以打开

SQL> alter database open read only;

 

Database altered.

 

注意迁移完成后需要将备库管理模式修改为自动模式.

 

-- The End --