以oracle 用户登陆,允许sqlplus "sys/oracle as sysdba"
1.shutdown abort
2.startup nomount pfile=/home/oracle/admin/shlbs/pfile/initshlbs.ora
3.如果startup nomount正常则
重做控制文件
CREATE CONTROLFILE REUSE DATABASE "SHLBS" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 454 LOGFILE GROUP 1 '/home/oracle/oradata/shlbs/redo01.log' SIZE 100M,GROUP 2 '/home/oracle/oradata/shlbs/redo02.log' SIZE 100M,GROUP 3 '/home/oracle/oradata/shlbs/redo03.log' SIZE 100M DATAFILE '/home/oracle/oradata/shlbs/CITYMGR.dbf','/home/oracle/oradata/shlbs/cwmlite01.dbf','/home/oracle/oradata/shlbs/drsys01.dbf','/home/oracle/oradata/shlbs/example01.dbf','/home/oracle/oradata/shlbs/indx01.dbf','/home/oracle/oradata/shlbs/LBS.dbf','/home/oracle/oradata/shlbs/odm01.dbf','/home/oracle/oradata/shlbs/system01.dbf','/home/oracle/oradata/shlbs/tools01.dbf','/home/oracle/oradata/shlbs/undotbs01.dbf','/home/oracle/oradata/shlbs/users01.dbf','/home/oracle/oradata/shlbs/xdb01.dbf' CHARACTER SET ZHS16GBK
4.如果需要,重做口令文件
orapwd file=口令文件路径和文件名 password=test entries=2
5.如果重做控制文件成功,则恢复数据库
recover database;
以上操作具体参数可能和具体数据相关,请修改。