oracle 启动报错

dksgqbj

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 8 with name
"_SYSSMU8_849662397$" too small
Process ID: 10748022
Session ID: 63 Serial number: 3

dksgqbj

32 rows selected.

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 6413680640 bytes
Fixed Size                  2233480 bytes
Variable Size            2801798008 bytes
Database Buffers         3590324224 bytes
Redo Buffers               19324928 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oradb/ora570ab/system.dbf'


SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.


SQL>

dksgqbj

有没有人啊？

dksgqbj

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 8 with name
"_SYSSMU8_849662397$" too small
Process ID: 9175122
Session ID: 129 Serial number: 3

renxiao2003

是不是数据文件破坏了。

li0924

1. select FILE_NAME,ONLINE_STATUS from dba_data_files;

复制代码

看是什么状态？

dksgqbj

已经处理好，重建控制文件。贴上方法：
shutdown abort
startup nomount

CREATE CONTROLFILE REUSE DATABASE "OR750AB" RESETLOGS ARCHIVELOG
    MAXLOGFILES 192
    MAXLOGMEMBERS 3
    MAXDATAFILES 1024
    MAXINSTANCES 32
    MAXLOGHISTORY 4672
LOGFILE
  GROUP 5 (
    '/oradb/ora570ab/redo05.log',
    '/oradb/ora570ab/redo15.log'
  ) SIZE 512M BLOCKSIZE 512,
  GROUP 6 (
    '/oradb/ora570ab/redo06.log',
    '/oradb/ora570ab/redo16.log'
  ) SIZE 512M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/oradb/ora570ab/system.dbf',                              
  '/oradb/ora570ab/sysaux.dbf',                              
  '/oradb/ora570ab/undotbs1.dbf',                           
  '/oradb/ora570ab/undotbs2.dbf',                           
   '/oradb/ora570ab/users.dbf',         
。。。。。。。。。。。。。。。。。。。。 这里为你自己创建的表空间                  
CHARACTER SET ZHS16GBK
;

alter database open resetlogs
如果不行，
recover database
或者
recover database using backup controlfile until cancel;

dksgqbj

已经处理好，重建控制文件。贴上方法：
shutdown abort
startup nomount

CREATE CONTROLFILE REUSE DATABASE "OR750AB" RESETLOGS ARCHIVELOG
    MAXLOGFILES 192
    MAXLOGMEMBERS 3
    MAXDATAFILES 1024
    MAXINSTANCES 32
    MAXLOGHISTORY 4672
LOGFILE
  GROUP 5 (
    '/oradb/ora570ab/redo05.log',
    '/oradb/ora570ab/redo15.log'
  ) SIZE 512M BLOCKSIZE 512,
  GROUP 6 (
    '/oradb/ora570ab/redo06.log',
    '/oradb/ora570ab/redo16.log'
  ) SIZE 512M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/oradb/ora570ab/system.dbf',                              
  '/oradb/ora570ab/sysaux.dbf',                              
  '/oradb/ora570ab/undotbs1.dbf',                           
  '/oradb/ora570ab/undotbs2.dbf',                           
   '/oradb/ora570ab/users.dbf',         
。。。。。。。。。。。。。。。。。。。。 这里为你自己创建的表空间                  
CHARACTER SET ZHS16GBK
;

alter database open resetlogs
如果不行，
recover database
或者
recover database using backup controlfile until cancel;

www_xylove

学习了。不错。