Welcome to oracle_awen's archive blog
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
添加评论

昵称 *

E-mail (防止垃圾信息,此栏留空)