1、查看现有的控制文件:
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
/home/oracle/oradata/ora11g/control01.ctl
/home/oracle/oradata/ora11g/control02.ctl
2、查看spfile文件:
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /home/oracle/product/11.2.0/db
home_1/dbs/spfileora11g.ora
3、复制spfile为pfile文件:
SQL> create pfile='/home/oracle/pfile.ora' from spfile;
File created.
4、编辑pfile文件:
vi pfile.ora
*.control_files='/home/oracle/oradata/ora11g/control01.ctl','/home/oracle/oradata/ora11g/control02.ctl','/home/oracle/oradata/ora11g/control03.ctl'
5、复制现有的一个控制文件并改名为:control03.ctl
6、关闭数据库:shutdown immediate
7、使用pfile启动数据库:startup pfile='/home/oracle/pfile.ora'
8、重新生成spfile文件:create spfile from pfile='/home/oracle/pfile.ora';