更改standby库的数据文件路径

更改standby库的数据文件路径

[oracle@bldc02 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 26 10:44:57 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.

--查看standby_file_management参数
SQL> show parameter standby_file_management;

NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
standby_file_management       string  AUTO

--standby_file_management参数值为AUTO，首先要将该参数置为MANUAL，才能更改数据文件路径，否则会出现
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.
这个信息

SQL> alter system set standby_file_management='MANUAL';

System altered.

SQL> shutdown immediate;

将数据文件复制至新目录
cp /u02/oradata/orcl01.dbf /oradata/orcl01.dbf

删除旧的数据文件

SQL> startup mount;

SQL> alter database rename file '/u02/oradata/orcl01.dbf' to '/oradata/orcl01.dbf'

SQL> alter database open;

查看数据文件是否更改到相应的文件目录下

SQL> select name from v$datafile;

SQL> create pfile='/home/oracle/initorcl.ora' from spfile;

更改pfile文件(initorcl.ora)
将standby_file_management由manual设置为auto
添加或修改db_file_name_convert='/u02/oradata/','/oradata/'

SQL> shutdown immediate;

SQL> create spfile from pfile='/home/oracle/initorcl.ora'

SQL> startup momount;

SQL> alter database mount standby database;

SQL> alter database open read only;

--应用归档日志
SQL> alter database recover managed standby database disconnect from session;