oracle 11G undo表空间错误

1.打开数据库时提示undo表空间不存在SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace ‘UNDOTBS01’ does not exist or of wrong type
Process ID: 3236
Session ID: 1 Serial number: 5

解决方法:[oracle@oracle ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 24 10:22:24 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area 776646656 bytes
Fixed Size 2217384 bytes
Variable Size 557845080 bytes
Database Buffers 213909504 bytes
Redo Buffers 2674688 bytes
Database mounted.
SQL> select name from v$datafile;

NAME
———————————————————–免费云主机域名———————
/home/oracle/app/oradata/orcl/system01.dbf
/home/oracle/app/oradata/orcl/sysaux01.dbf
/home/oracle/app/oradata/orcl/undotbs01.dbf –undo表空间的数据文件
/home/oracle/app/oradata/orcl/users01.dbf
/home/oracle/app/oradata/orcl/tong.dbf

SQL> show parameter undo
NAME TYPE VALUE
———————————— ———– ——————————
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1 –undo表空间的名字
SQL> select name from v$tablespace;

NAME
——————————
SYSTEM
SYSAUX
UNDOTBS1 –undo表空间的名字
USERS
TEMP
TONG1
6 rows selected.
SQL>
思路:根据启动oracle的错误可以看出,错误信息的undo表空间的名字与数据库里面的名字不一至,此时要在init.orcl.ora文件中修改undo_tablespace的值,用pfile文件启动数据库.
[oracle@oracle ~]$ cd $ORACLE_HOME/dbs
[oracle@oracle dbs]$ vim initorcl.ora
*.undo_tablespace=’UNDOTBS1′ –修改这行的值[oracle@oracle ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 24 10:26:06 2016
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount pfile=’/home/oracle/app/product/11.2.0/dbhome_1/dbs/initorcl.ora’
ORACLE instance started.

Total System Global Area 776646656 bytes
Fixed Size 2217384 bytes
Variable Size 557845080 bytes
Database Buffers 213909504 bytes
Redo Buffers 2674688 bytes
Database mounted.
SQL> alter database open;

Database altered.
SQL> create spfile=’/home/oracle/app/product/11.2.0/dbhome_1/dbs/spfileorcl.ora’ from pfile;

File created. –pfile文件创建spfile文件
SQL> shutdown immediate –重启数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 776646656 bytes
Fixed Size 2217384 bytes
Variable Size 557845080 bytes
Database Buffers 213909504 bytes
Redo Buffers 2674688 bytes
Database mounted.
Database opened.
SQL>

相关推荐: oracle常用hint是怎样的

oracle常用hint是怎样的，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。 1./*+ ALL_ROWS */希望优化程序给出一种尽快得到全部记录的执行计划，目标是增加系统的吞…