十二、Oracle启动时报(ORA-01122,ORA-01110,ORA-01207)

king's blog

问题描述

Oracle启动时报ORA-01122,ORA-01110,ORA-01207,如下:
ora-01122

原因分析

出现上面的报错,是由于oracle控制文件被损坏的原因

解决办法

步骤一:启动服务后,将控制文件的trace写到log里,如下:

lsnrctl start
sqlplus / as sysdba
SQL> startup
SQL> alter database backup controlfile to trace as ‘/opt/oracle/aaa’;
SQL> shutdown immediate;
SQL> startup nomount;

ora-01110

步骤二:查看aaa文件,有后续具体的操作步骤

查看第55~77行,如下:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
CREATE CONTROLFILE REUSE DATABASE "REAPSDB" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/opt/oracle/oradata/REAPSDB/redo01.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/opt/oracle/oradata/REAPSDB/redo02.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/opt/oracle/oradata/REAPSDB/redo03.log'  SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/opt/oracle/oradata/REAPSDB/system01.dbf',
  '/opt/oracle/oradata/REAPSDB/sysaux01.dbf',
  '/opt/oracle/oradata/REAPSDB/undotbs01.dbf',
  '/opt/oracle/oradata/REAPSDB/users01.dbf',
  '/opt/oracle/oradata/REAPSDB/HOB_DATA.dbf',
  '/opt/oracle/oradata/REAPSDB/HOB_INDX.dbf',
  '/opt/oracle/oradata/REAPSDB/REAPS_DATA.dbf',
  '/opt/oracle/oradata/REAPSDB/REAPS_INDX.dbf',
  '/opt/oracle/oradata/REAPSDB/RPTENG_DATA.dbf',
  '/opt/oracle/oradata/REAPSDB/RPTENG_INDX.dbf',
  '/opt/oracle/oradata/REAPSDB/SS_DATA.dbf',
  '/opt/oracle/oradata/REAPSDB/SS_INDX.dbf'
CHARACTER SET AL32UTF8
;

步骤三.按上面的步骤,恢复数据库

SQL->执行aaa中52~77行的语句
SQL->RECOVER DATABASE
SQL->ALTER DATABASE OPEN
ora-01207

Tags:
文 / 甲乙丙丁
LEAVE A REPLY

loading