以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.如果重做控制文件成功，則恢復數(shù)據庫
recover database;

以上操作具體參數(shù)可能和具體數(shù)據相關，請修改。