1.修改数据库
alter system set
control_files='C:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL',
'C:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL02.CTL',
'C:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL03.CTL',
'C:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL' SCOPE=SPFILE;
2.shutdown immediate
3.copy
4.startup
5.查看应用状态
select name,status from v$controlfile
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21302630/viewspace-1571820/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21302630/viewspace-1571820/