Oracle 在 Linux 下移动控制文件步骤
①.查看控制文件
[oracle@dbserver ~]$ sqlplus / as sysdba
SQL>desc v$controlfile
SQL>select * from v$controlfile;
②.新建目录
$mkdir -p u01/oradata/epps
$mkdir -p u02/oradata/epps
$mkdir -p u03/oradata/epps
③.检查是否以spfile启动
SQL>show parameter spfile;
(VALUE值不为空,为spfile启动)
④.修改控制文件位置
SQL>alter system set control_files=
'u01/oradata/epps/control01.ctl',
'u02/oradata/epps/control02.ctl',
'u03/oradata/epps/control03.ctl'
scope=spfile;
⑤.关闭数据库
SQL>shutdown immediate;
⑥.移动控制文件
SQL> ! mv /u01/app/oracle/oradata/epps/control01.ctl /u01/oradata/epps
SQL> ! mv /u01/app/oracle/oradata/epps/control02.ctl /u02/oradata/epps/
SQL> ! mv /u01/app/oracle/oradata/epps/control03.ctl /u03/oradata/epps/
⑦.启动数据库
SQL>startup
⑧.检查完成
SQL>select * from v$controlfile
[oracle@dbserver ~]$ sqlplus / as sysdba
SQL>desc v$controlfile
SQL>select * from v$controlfile;
②.新建目录
$mkdir -p u01/oradata/epps
$mkdir -p u02/oradata/epps
$mkdir -p u03/oradata/epps
③.检查是否以spfile启动
SQL>show parameter spfile;
(VALUE值不为空,为spfile启动)
④.修改控制文件位置
SQL>alter system set control_files=
'u01/oradata/epps/control01.ctl',
'u02/oradata/epps/control02.ctl',
'u03/oradata/epps/control03.ctl'
scope=spfile;
⑤.关闭数据库
SQL>shutdown immediate;
⑥.移动控制文件
SQL> ! mv /u01/app/oracle/oradata/epps/control01.ctl /u01/oradata/epps
SQL> ! mv /u01/app/oracle/oradata/epps/control02.ctl /u02/oradata/epps/
SQL> ! mv /u01/app/oracle/oradata/epps/control03.ctl /u03/oradata/epps/
⑦.启动数据库
SQL>startup
⑧.检查完成
SQL>select * from v$controlfile