修改dg备库错误路径名的数据文件

适用于10r2及以后版本

现有环境dg备库   

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';

查看修改是否成功

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;

SQL>startup nomount;

SQL>alter database read only; SQL>alter database recover managed standby database using current logfile disconnect from session;