问题描述:
ORA-00376: file 175 cannot be read at this time
ORA-01110: data file 175: '/database4/oradata/undotbs02.dbf'
数据库无法启动
解决办法:
startup mount
----------------------------------------------------------------------------
-- 一、准备工作
----------------------------------------------------------------------------
select * from v$tablespace;
-- 查看表空间对应的回滚段,在mount状态下无法执行。
select segment_name, segment_id, status from dba_rollback_segs where tablespace_name='UNDOTBS1';
create pfile from spfile
-- pfile在$ORACLE_HOME/dbs目录下
----------------------------------------------------------------------------
-- 二、开始处理
----------------------------------------------------------------------------
-- 1、调整pfile,然后重启数据库,创建回滚段表空间
vi initbjgpnms.ora
*.undo_management='MANUAL'
*.undo_tablespace='SYSTEM'
startup pfile='/opt/ora9/oracle/product/9.2.1/dbs/initbjgpnms.ora';
drop tablespace UNDOTBS1 including contents and datafiles;
-- 这时会提示哪个回滚段正在使用,不能删除。(不能删除的回滚段,在初始化参_OFFLINE_ROLLBACK_SEGMENTS)设置。
-- 创建新的回滚表空间
create undo tablespace undotbs datafile
'/database4/oradata/undo01.dbf' size 500m autoextend on next 100m maxsize 30720m;
-- 2、调整pfile, 添加回滚段, 如果有多个用逗号分隔, 然后启动数据库
shutdown immediate
vi initbjgpnms.ora
*.undo_management='MANUAL'
*._OFFLINE_ROLLBACK_SEGMENTS=(_SYSSMU1$)
*.undo_tablespace='undotbs'
startup pfile='/opt/ora9/oracle/product/9.2.1/dbs/initbjgpnms.ora';
drop rollback segment "_SYSSMU1$";
drop tablespace undotbs1 including contents and datafiles;
-- 3、调整pfile, 添加回滚段, 然后重启数据库
shutdown immediate
vi initbjgpnms.ora
*.undo_management='AUTO'
*.undo_tablespace='undotbs'
startup pfile='/opt/ora9/oracle/product/9.2.1/dbs/initbjgpnms.ora';
create spfile from pfile='/opt/ora9/oracle/product/9.2.1/dbs/initbjgpnms.ora'
-- 4、重启数据库,问题解决。
shutdown immediate
startup
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/720091/viewspace-1066352/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/720091/viewspace-1066352/