更改oracle数据文件位置实战

— nomount status
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup nomount;

— move Oracle files
[oracle@oracle19 oracle]$ mkdir -p /u01/app/oracle/oradata && /u01/app/oracle/oradata
[oracle@oracle19 oradata]$ mv /u01/orcl/ ./

— change control files
SQL> alter system set control_files=\’/u01/app/oracle/oradata/orcl/control01.ctl\’,\’/u01/app/oracle/oradata/orcl/control02.ctl\’ SCOPE=spfile;

System altered.

SQL> show parameter control_files
NAME TYPE
———————————— ———————————
VALUE
——————————
control_files string
/u01/orcl/control01.ctl, /u01/
orcl/control02.ctl

SQL> startup nomount force;

SQL> select name from v$controlfile;
no rows selected

SQL> show parameter control_files
NAME TYPE VALUE
———————————— ———– —————–