SQL> ALTER SYSTEM SET CONTROL_FILES ='D:\oracle\oradata\HGY\control01.ctl',
2 'D:\oracle\oradata\HGY\control02.ctl','D:\oracle\oradata\HGY\CONTROL03.CTL',
3 'D:\oracle\oradata\H\control03.ctl',
4 SCOPE=SPFILED:\oracle\oradata\H\control03.ctl是我要创建的副本文件,不知道为什么出错
ALTER SYSTEM SET CONTROL_FILES ='D:\oracle\oradata\HGY\control01.ctl',
*
ERROR 位于第 1 行:
ORA-01034: ORACLE not available
2 'D:\oracle\oradata\HGY\control02.ctl','D:\oracle\oradata\HGY\CONTROL03.CTL',
3 'D:\oracle\oradata\H\control03.ctl',
4 SCOPE=SPFILED:\oracle\oradata\H\control03.ctl是我要创建的副本文件,不知道为什么出错
ALTER SYSTEM SET CONTROL_FILES ='D:\oracle\oradata\HGY\control01.ctl',
*
ERROR 位于第 1 行:
ORA-01034: ORACLE not available
2.格式不对吧
ALTER SYSTEM SET CONTROL_FILES =('D:\oracle\oradata\HGY\control01.ctl',
'D:\oracle\oradata\HGY\control02.ctl','D:\oracle\oradata\HGY\CONTROL03.CTL',
'D:\oracle\oradata\H\control03.ctl')
SCOPE=SPFILE