适用于10r2及之后版本session
现有环境dg备库 spa
NAME
--------------------------------------------------------------------------------
/oradata/wfta/system01.dbf
/oradata/wfta/sysaux01.dbf
/oradata/wfta/undotbs01.dbf
/oradata/wfta/users01.dbf
/oradata/WFTB/datafile/o1_mf_test_cv4j4ycc_.dbf
我如今是read only,那shutdown先
SQL> shutdown immediate;
物理拷贝到源端更名
cp /oradata/WFTB/datafile/o1_mf_test_cv4j4ycc_.dbf /oradata/wfta/test.dbf
修改一下standb文件管理模式,原来是auto
SQL>alter system set standby_file_management=manual scope=both;
更名(rename)
SQL>alter database rename file '/oradata/WFTB/datafile/o1_mf_test_cv4j4ycc_.dbf' to '/oradata/wfta/test.dbf';io
查看修改是否成功
test
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oradata/wfta/system01.dbf
/oradata/wfta/sysaux01.dbf
/oradata/wfta/undotbs01.dbf
/oradata/wfta/users01.dbf
/oradata/wfta/test.dbf
该回standby file参数
SQL>alter system set standby_file_management=auto scope=spfile;
修改成active dataguard
SQL>shutdown immediate;file
SQL>startup nomount;select
SQL>alter database read only; SQL>alter database recover managed standby database using current logfile disconnect from session;