ORALCE 在 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