现在已经有8个G的Oracle的数据库文件,我已经把它们复制进\oracle\oradata\Ora8里面了,并且将原来的三个CONTROL文件删除了。
然后再cmd里面输入进入了SQLPLUS,用的语句是
C:\sqlplus "sys/change_on_install as sysdba"
然后是
SQL>shutdown immediate
然后是
SQL>@s.sql
然后显示出“例程已启动”。然后应该是在\oracle\oradata\Ora8里面有CONTROL文件生成。
但是我现在还是看不了啊,怎么办??拜托各位帮我!!!
导致我从我老师那里拷来的系统都现在不能运行!!!拜托!!!
然后用
SQL>recover database using backup controlfile until cancel;
显示的是:ORA-01507:??????
怎么办啊???
然后再cmd里面输入进入了SQLPLUS,用的语句是
C:\sqlplus "sys/change_on_install as sysdba"
然后是
SQL>shutdown immediate
然后是
SQL>@s.sql
然后显示出“例程已启动”。然后应该是在\oracle\oradata\Ora8里面有CONTROL文件生成。
但是我现在还是看不了啊,怎么办??拜托各位帮我!!!
导致我从我老师那里拷来的系统都现在不能运行!!!拜托!!!
然后用
SQL>recover database using backup controlfile until cancel;
显示的是:ORA-01507:??????
怎么办啊???
STARTUP NOMOUNT pfile=F:\oracle\admin\Ora8\pfile\init.ora;
CREATE CONTROLFILE set DATABASE "Ora8" RESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
-- STANDBY LOGFILE --设置LOGFILE的位置
LOGFILE
GROUP 1 'F:\oracle\oradata\Ora8\REDO01.LOG' SIZE 100M,
GROUP 2 'F:\oracle\oradata\Ora8\REDO02.LOG' SIZE 100M,
GROUP 3 'F:\oracle\oradata\Ora8\REDO03.LOG' SIZE 100M
--设置DATAFILE的位置
DATAFILE
'F:\oracle\oradata\Ora8\APACCT.DBF',
'F:\oracle\oradata\Ora8\APBLDBANK.DBF',
'F:\oracle\oradata\Ora8\APCOMM.DBF',
'F:\oracle\oradata\Ora8\APDIALYSE.DBF',
'F:\oracle\oradata\Ora8\APECONSTAT.DBF',
'F:\oracle\oradata\Ora8\APEQUIPMENT.DBF',
'F:\oracle\oradata\Ora8\APEXAM.DBF',
'F:\oracle\oradata\Ora8\APFOUNDING.DBF',
'F:\oracle\oradata\Ora8\APICU.DBF',
'F:\oracle\oradata\Ora8\APINPADM.DBF',
'F:\oracle\oradata\Ora8\APINPBILL.DBF',
'F:\oracle\oradata\Ora8\APINSURANCE.DBF',
'F:\oracle\oradata\Ora8\APLAB.DBF',
'F:\oracle\oradata\Ora8\APMEDADM.DBF',
'F:\oracle\oradata\Ora8\APMEDREC.DBF',
'F:\oracle\oradata\Ora8\APNURSING.DBF',
'F:\oracle\oradata\Ora8\APORDADM.DBF',
'F:\oracle\oradata\Ora8\APOUTPADM.DBF',
'F:\oracle\oradata\Ora8\APOUTPBILL.DBF',
'F:\oracle\oradata\Ora8\APPHARMACY.DBF',
'F:\oracle\oradata\Ora8\APSURGERY.DBF',
'F:\oracle\oradata\Ora8\APTEMP.DBF',
'F:\oracle\oradata\Ora8\APTEMP2.DBF',
'F:\oracle\oradata\Ora8\DR01.DBF',
'F:\oracle\oradata\Ora8\INDX01.DBF',
'F:\oracle\oradata\Ora8\RBS01.DBF',
'F:\oracle\oradata\Ora8\SYSTEM01.DBF',
'F:\oracle\oradata\Ora8\TEMP01.DBF',
'F:\oracle\oradata\Ora8\TOOLS01.DBF',
'F:\oracle\oradata\Ora8\USERS01.DBF'
--设置字符集
--CHARACTER SET SIMPLIFIED CHINESE_CHINA.ZHS16GBK;
--设置字符集
--CHARACTER SET SIMPLIFIED CHINESE_CHINA.ZHS16GBK;
在运行@s.sql以后说是错误的
CREATE CONTROLFILE set DATABASE "Ora8" RESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
-- STANDBY LOGFILE --设置LOGFILE的位置
LOGFILE
GROUP 1 'F:\oracle\oradata\Ora8\REDO01.LOG' SIZE 100M,
GROUP 2 'F:\oracle\oradata\Ora8\REDO02.LOG' SIZE 100M,
GROUP 3 'F:\oracle\oradata\Ora8\REDO03.LOG' SIZE 100M
--设置DATAFILE的位置
DATAFILE
'F:\oracle\oradata\Ora8\APACCT.DBF',
'F:\oracle\oradata\Ora8\APBLDBANK.DBF',
'F:\oracle\oradata\Ora8\APCOMM.DBF',
'F:\oracle\oradata\Ora8\APDIALYSE.DBF',
'F:\oracle\oradata\Ora8\APECONSTAT.DBF',
'F:\oracle\oradata\Ora8\APEQUIPMENT.DBF',
'F:\oracle\oradata\Ora8\APEXAM.DBF',
'F:\oracle\oradata\Ora8\APFOUNDING.DBF',
'F:\oracle\oradata\Ora8\APICU.DBF',
'F:\oracle\oradata\Ora8\APINPADM.DBF',
'F:\oracle\oradata\Ora8\APINPBILL.DBF',
'F:\oracle\oradata\Ora8\APINSURANCE.DBF',
'F:\oracle\oradata\Ora8\APLAB.DBF',
'F:\oracle\oradata\Ora8\APMEDADM.DBF',
'F:\oracle\oradata\Ora8\APMEDREC.DBF',
'F:\oracle\oradata\Ora8\APNURSING.DBF',
'F:\oracle\oradata\Ora8\APORDADM.DBF',
'F:\oracle\oradata\Ora8\APOUTPADM.DBF',
'F:\oracle\oradata\Ora8\APOUTPBILL.DBF',
'F:\oracle\oradata\Ora8\APPHARMACY.DBF',
'F:\oracle\oradata\Ora8\APSURGERY.DBF',
'F:\oracle\oradata\Ora8\APTEMP.DBF',
'F:\oracle\oradata\Ora8\APTEMP2.DBF',
'F:\oracle\oradata\Ora8\DR01.DBF',
'F:\oracle\oradata\Ora8\INDX01.DBF',
'F:\oracle\oradata\Ora8\RBS01.DBF',
'F:\oracle\oradata\Ora8\SYSTEM01.DBF',
'F:\oracle\oradata\Ora8\TEMP01.DBF',
'F:\oracle\oradata\Ora8\TOOLS01.DBF',
'F:\oracle\oradata\Ora8\USERS01.DBF'
CHARACTER SET ZHS16GBK;
ALTER DATABASE OPEN RESETLOGS;
而且提示说第一行有错误