Standby 移动物理文件

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/oracle/oradata/pszx_by/system01.dbf
/oracle/oradata/pszx_by/undotbs01.dbf
/oracle/oradata/pszx_by/sysaux01.dbf
/oracle/oradata/pszx_by/users01.dbf

SQL> startup nomount
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes

SQL> show parameter standby_file

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL> alter system set standby_file_management=MANUAL;

System altered.


SQL> alter database mount;

Database altered.

SQL> alter database rename file '/oracle/oradata/pszx_by/users01.dbf' to '/home/oracle/users01.dbf';

Database altered.

SQL> alter system set standby_file_management=AUTO;

System altered.

SQL> shutdown
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/oracle/oradata/pszx_by/system01.dbf
/oracle/oradata/pszx_by/undotbs01.dbf
/oracle/oradata/pszx_by/sysaux01.dbf
/home/oracle/users01.dbf