1. Alter the SPFILE:
ALTER SYSTEM SET control_files =
'$HOME/ORADATA/u01/ctrl01.ctl',
'$HOME/ORADATA/u02/ctrl02.ctl' SCOPE=SPFILE;
2. Shut down the database:
shutdown immediate
3. Create additional control files:
cp $HOME/ORADATA/u01/ctrl01.ctl
$HOME/ORADATA/u02/ctrl02.ctl
4. Start the database:
startup
注意点:上面alter命令中的$HOME自己要查清楚,不能照搬,否则会出现无法找到control文件错误。
ALTER SYSTEM SET control_files =
'$HOME/ORADATA/u01/ctrl01.ctl',
'$HOME/ORADATA/u02/ctrl02.ctl' SCOPE=SPFILE;
2. Shut down the database:
shutdown immediate
3. Create additional control files:
cp $HOME/ORADATA/u01/ctrl01.ctl
$HOME/ORADATA/u02/ctrl02.ctl
4. Start the database:
startup
注意点:上面alter命令中的$HOME自己要查清楚,不能照搬,否则会出现无法找到control文件错误。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29840459/viewspace-1451305/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29840459/viewspace-1451305/