ORA-30012

1、数据库启动报如下错误

SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 27 00:27:05 2018

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SP2-0310: unable to open file "pid.sql"
SQL> shutdown immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
SQL> startup pfile='/tmp/pfile826.txt';
LRM-00109: could not open parameter file '/tmp/pfile826.txt'
ORA-01078: failure in processing system parameters
SQL> 
SQL> startup pfile='/tmp/pfile0826.txt';
ORACLE instance started.

Total System Global Area  776646656 bytes
Fixed Size                  2232392 bytes
Variable Size             658509752 bytes
Database Buffers          109051904 bytes
Redo Buffers                6852608 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace 'UNDOTBS01' does not exist or of wrong type
Process ID: 3530
Session ID: 125 Serial number: 5

           

2、查看/tmp/pfile0826.txt中 关于undo表空间的配置

*.sga_target=62914560
*.statistics_level='ALL'
*.streams_pool_size=29360128
*.undo_retention=3600
*.undo_tablespace='UNDOTBS01'
           

3、查看数据字典记录的undo信息

[email protected] backup]$ o

SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 27 00:30:40 2018

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$tablespace where name like '%UNDO%';

NAME
------------------------------
UNDOTBS1
UNDOTBS3

SQL> 
           

4、修改/tmp/pfile0826.txt文件

*.sga_target=62914560
*.statistics_level='ALL'
*.streams_pool_size=29360128
*.undo_retention=3600
*.undo_tablespace='UNDOTBS1'
           

5、重新启动数据库

[[email protected] backup]$ o

SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 27 00:31:05 2018

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

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


Database dismounted.
ORACLE instance shut down.
SQL> startup mount pfile='/tmp/pfile0826.txt';
ORACLE instance started.

Total System Global Area  776646656 bytes
Fixed Size                  2232392 bytes
Variable Size             658509752 bytes
Database Buffers          109051904 bytes
Redo Buffers                6852608 bytes
Database mounted.
SQL> alter database open;

Database altered.