首先查一下控制文件存放路径
Set linesize 200
Col name format a55
Select * from v$controlfile;
STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ------------------------------------------------------- --- ---------- --------------
/data/CS/controlfile/o1_mf_cbccts9p_.ctl NO 16384 592
然后关库:shutdown immediate-----切记要先关库再物理拷贝控制文件!!
物理拷贝一个控制文件
cp /data/CS/controlfile/o1_mf_cbccts9p_.ctl /data/CS/controlfile/control02.ctl
然后如果用的spfile就用alter system 如果是用的pfile直接修改文件
spfile:
startup nomount
SQL> alter system set control_files='/data/CS/controlfile/o1_mf_cbccts9p_.ctl','/data/CS/controlfile/control02.ctl' scope=spfile;
System altered.
然后shutdown immediate
startup
就生效了
Set linesize 200
Col name format a55
Select * from v$controlfile;
STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ------------------------------------------------------- --- ---------- --------------
/data/CS/controlfile/o1_mf_cbccts9p_.ctl NO 16384 592
然后关库:shutdown immediate-----切记要先关库再物理拷贝控制文件!!
物理拷贝一个控制文件
cp /data/CS/controlfile/o1_mf_cbccts9p_.ctl /data/CS/controlfile/control02.ctl
然后如果用的spfile就用alter system 如果是用的pfile直接修改文件
spfile:
startup nomount
SQL> alter system set control_files='/data/CS/controlfile/o1_mf_cbccts9p_.ctl','/data/CS/controlfile/control02.ctl' scope=spfile;
System altered.
然后shutdown immediate
startup
就生效了