SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
CONTROL1.CTL文件复制到CONTROL2.CTL;
ALTER SYSTEM SET CONTROL_FILES='E:\APP\ADMINSTRATOR\ORADATA\ORCL\CONTROL01.CTL' SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
CONTROL1.CTL文件复制到CONTROL2.CTL;
ALTER SYSTEM SET CONTROL_FILES='E:\APP\ADMINSTRATOR\ORADATA\ORCL\CONTROL01.CTL' SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;
转载于:https://www.cnblogs.com/mr-hero/p/5823721.html