Torename the datafile in the primary database, take the tablespace offline:

1.在主庫中重命名數據文件，先將表空間脫機：

SQL> ALTER TABLESPACE tbs_4 OFFLINE;

Exit from the SQL prompt and issue an operating system command, such as the following UNIXmvcommand, to rename the datafile on the primary system:

退出SQL提示符，使用操作系統命令，像unix的mv命令，在主庫操作系統上重命名數據文件：

% mv /disk1/Oracle/oradata/payroll/tbs_4.dbf

/disk1/oracle/oradata/payroll/tbs_x.dbf

Rename the datafile in the primary database and bring the tablespace back online:

在主庫上發出以下命令來重命名數據文件，然后將表空間聯機：

SQL> ALTER TABLESPACE tbs_4RENAMEDATAFILE 2> '/disk1/oracle/oradata/payroll/tbs_4.dbf'

3> TO'/disk1/oracle/oradata/payroll/tbs_x.dbf';

SQL> ALTER TABLESPACE tbs_4 ONLINE;

Connect to the standby database, query theV$ARCHIVED_LOGview to verify all of the archived redo log files are applied, and then stop Redo Apply:

連接備庫，，查詢V$ARCHIVED_LOG 視圖來驗證所有的歸檔日志已經應用，然后停止重做應用：

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# APP

--------- ---

8 YES

9 YES

10 YES

11 YES

4 rows selected.

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Shut down the standby database:

5.關閉備庫

SQL> SHUTDOWN;

Rename the datafile at the standby site using an operating system command, such as the UNIXmvcommand:

6.在備庫的操作環境使用操作系統命令，如UNIX的mv命令，來重命名數據文件：

% mv /disk1/oracle/oradata/payroll/tbs_4.dbf /disk1/oracle/oradata/payroll/tbs_x.dbf

Start and mount the standby database:

7.啟動并裝載備庫：

SQL> STARTUP MOUNT;

Rename the datafile in the standby control file. Note that theSTANDBY_FILE_MANAGEMENTinitialization parameter must be set toMANUAL.

在備庫上重命名數據文件到控制文件里，注意：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';

On the standby database, restart Redo Apply:

9.在備庫重新啟動重做應用：

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE

2> DISCONNECT FROM SESSION;