风哥教程

培训 . 交流 . 分享
Make progress together!

oracle dataguard Renaming a Datafile in the Primary Database

[复制链接]
内容发布:paulyi| 发布时间:2014-1-22 22:04:13
oracle dataguard Renaming a Datafile in the Primary Database

Renaming a Datafile in the Primary Database
When you rename one or more datafiles in the primary database, the change is not
propagated to the standby database. Therefore, if you want to rename the same
datafiles on the standby database, you must manually make the equivalent
modifications on the standby database because the modifications are not performed
automatically, even if the STANDBY_FILE_MANAGEMENT initialization parameter is set
to AUTO.
The following steps describe how to rename a datafile in the primary database and
manually propagate the changes to the standby database.
1. To rename the datafile in the primary database, take the tablespace offline:
SQL> ALTER TABLESPACE tbs_4 OFFLINE;
2. Exit from the SQL prompt and issue an operating system command, such as the
following UNIX mv command, to rename the datafile on the primary system:
% mv /disk1/oracle/oradata/payroll/tbs_4.dbf
/disk1/oracle/oradata/payroll/tbs_x.dbf
3. Rename the datafile in the primary database and bring the tablespace back online:
SQL> ALTER TABLESPACE tbs_4 RENAME DATAFILE
2> '/disk1/oracle/oradata/payroll/tbs_4.dbf'
3> TO '/disk1/oracle/oradata/payroll/tbs_x.dbf';
SQL> ALTER TABLESPACE tbs_4 ONLINE;
4. Connect to the standby database, query the V$ARCHIVED_LOG view to verify all
of the archived redo log files are applied, and then stop Redo Apply:
SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
Primary Database Changes That Require Manual Intervention at a Physical Standby
Managing Physical and Snapshot Standby Databases 9-9
--------- ---
8 YES
9 YES
10 YES
11 YES
4 rows selected.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
5. Shut down the standby database:
SQL> SHUTDOWN;
6. Rename the datafile at the standby site using an operating system command, such
as the UNIX mv command:
% mv /disk1/oracle/oradata/payroll/tbs_4.dbf /disk1/oracle/oradata/payroll/tbs_
x.dbf
7. Start and mount the standby database:
SQL> STARTUP MOUNT;
8. Rename the datafile in the standby control file. Note that the STANDBY_FILE_
MANAGEMENT initialization parameter must be set to MANUAL.
SQL>alter system set STANDBY_FILE_MANAGEMENT =manual;
SQL> ALTER DATABASE RENAME FILE '/disk1/oracle/oradata/payroll/tbs_4.dbf'
2> TO '/disk1/oracle/oradata/payroll/tbs_x.dbf';
9. On the standby database, restart Redo Apply:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
2> DISCONNECT;

If you do not rename the corresponding datafile at the standby system, and then try to
refresh the standby database control file, the standby database will attempt to use the
renamed datafile, but it will not find it. Consequently, you will see error messages
similar to the following in the alert log:
ORA-00283: recovery session canceled due to errors
ORA-01157: cannot identify/lock datafile 4 - see DBWR trace file
ORA-01110: datafile 4: '/Disk1/oracle/oradata/payroll/tbs_x.dbf'


上一篇:oracle 11g数据库在不同平台异构搭建dataguard安装文档
下一篇:oracle 11g新特性dataguard real time apply +real time query
回复

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

热门文章教程

  • 实战PHP与MySQL权威指南PDF电子书下载
  • 大数据技术与应用入门培训教程(电子版下载
  • Oracle 12cR2 九大新功能全面曝光_详解云数
  • Oracle OCP认证考试IZ0-053题库共712题数据
  • MySQL5权威指南(第3版)PDF电子版下载
  • 风哥Oracle数据库巡检工具V1.0(附2.6网页
快速回复 返回顶部 返回列表