OracleUNDO表空间重建与恢复

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了OracleUNDO表空间重建与恢复，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2750字，纯文字阅读大概需要4分钟。

内容图文

UNDO表空间的数据文件从OS直接删除了，数据库还没shutduwn，UNDO需要恢复。

UNDO表空间的数据文件从OS直接删除了，数据库还没shutduwn，，UNDO需要恢复。

1，数据库正常运行状态中；

2，rm - fundotbs02.dbf， 数据库在不知情的情况下接着运行，直到有日志错误告警。

Fri Apr 19 13:27:03 2013
[3942] ORA-01554 reason: failed to get txn-enqueue TX-0x000d0000-0x00000000
Errors in file /u01/app/Oracle/diag/rdbms/ora11g/ORA11G/trace/ORA11G_smon_3942.trc:
ORA-01595: error freeing extent (17) of rollback segment (13))
ORA-01554: transaction concurrency limit reached reason:failed to get TX-enqueue params:851968, 0
Fri Apr 19 13:27:51 2013
Errors in file /u01/app/oracle/diag/rdbms/ora11g/ORA11G/trace/ORA11G_j000_10253.trc:
ORA-12012: error on auto execute of job 43
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/u01/app/oracle/ORA11G/undotbs02.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/ora11g/ORA11G/trace/ORA11G_j000_10253.trc:
ORA-12012: error on auto execute of job 43
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/u01/app/oracle/ORA11G/undotbs02.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

3，此时创建spfile也会报错。
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/u01/app/oracle/ORA11G/undotbs02.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
4，此时，注意保留现场，不要随意关闭数据库，查询有哪里UNDO的段正在使用。
SQL> select * from v$rollname;
USN NAME
---------- ------------------------------
0 SYSTEM
11 _SYSSMU11_2087506584$
12 _SYSSMU12_1903386335$
13 _SYSSMU13_3816552520$
14 _SYSSMU14_2728152801$
15 _SYSSMU15_2082928664$
16 _SYSSMU16_1938921541$
17 _SYSSMU17_3062294638$

8 rows selected.
如果数据库已经强行关闭了，可以查询如下。
SQL> select segment_name,status,tablespace_name from dba_rollback_segs where status='NEEDS RECOVERY';
SEGMENT_NAME STATUS TABLESPACE_NAME
------------------------------ ---------------- ------------------------------

11 _SYSSMU11_2087506584$ NEEDS RECOVERY UNDOTBS2
12 _SYSSMU12_1903386335$ NEEDS RECOVERY UNDOTBS2
13 _SYSSMU13_3816552520$ NEEDS RECOVERY UNDOTBS2
14 _SYSSMU14_2728152801$ NEEDS RECOVERY UNDOTBS2
15 _SYSSMU15_2082928664$ NEEDS RECOVERY UNDOTBS2
16 _SYSSMU16_1938921541$ NEEDS RECOVERY UNDOTBS2
17 _SYSSMU17_3062294638$ NEEDS RECOVERY UNDOTBS2

内容总结

以上是互联网集市为您收集整理的OracleUNDO表空间重建与恢复全部内容，希望文章能够帮你解决OracleUNDO表空间重建与恢复所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---