SMON: found rollback segment # 11 at address 67fd103c to take offline.
来源:互联网 发布:小南海水电站知乎 编辑:程序博客网 时间:2024/06/06 13:08
From: Ed Laugel 08-Sep-04 16:05
Subject: UNDO and trace files with SMON: found rollback segment
RDBMS Version: 9.2.0.4.0
Operating System and Version: HP-Ux 11.0
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): RDBMS
Product Version:
UNDO and trace files with SMON: found rollback segment
I have many trace files generated with this error "SMON: found rollback segment # ## at address ### to take offline." I understand they are generated when a redo segment is taken off line while it still contains active transactions.
But I only use UNDO with Automatic Undo Management (AUM). I don't have redo segments.
The alert log entry for about this time frame shows: SMON offlining US=11
I'm running this version of oracle on about 20 other systems with no problems. It's just thest 4 databases for this application that have this problem.
My issues are: Why is it generating trc files? How do I stop it from generating the trc files? And, is my database O.K.
From: Seshagiri Gangupantulu 08-Sep-04 16:35
Subject: Re : UNDO and trace files with SMON: found rollback segment
I have seen this messages even though we are using Oracle 9i and Automatic UNDO tablespaces.
Oracle didn't update this kind of error messages in trace files with undo segments but refer rollback segments only as Oracle 9i supports both manual as well as automatic undo management.
Your database is fine.
Thanks,
Sesha.
- SMON: found rollback segment # 11 at address 67fd103c to take offline.
- rollback segment
- Oracle中的ORA-01548: active rollback segment '_SYSSMU1$' found
- ORA-01548: active rollback segment '_SYSSMU1_3138885392$' found, terminate
- SMON: ABOUT TO RECOVER UNDO SEGMENT %s messages in alert log
- drop tablespace ORA-01548: active rollback segment '_SYSSMU6$' found, terminate dropping
- 【Oracle问题集6】ORA-01548: active rollback segment XX found, terminate dropping tablespace
- 删除回滚表空间时出错ORA-01548: active rollback segment ‘_SYSSMUxx_xxxx’ found
- Oracle中的ORA-01548: active rollback segment '_SYSSMU1$' found
- Error:No CFI table found at address 0x00000000
- ORA-1650: unable to extend rollback segment RBS1 by 128 in tablespace RBS
- 使用T-SQL将数据设置为在线或者离线(SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online)
- unable to handle kernel null pointer dereference at virtual address
- Cannot open channel to 1 at election address(待续)
- Unable to handle kernel paging request at virtual address f600030a
- Unable to handle kernel paging request at virtual address
- Unable to handle kernel paging request at virtual address
- Oracle性能优化之Rollback Segment优化
- 用线程实现动态改变图标
- 不规则对话框的又一实现
- hotmail升级啦!
- CRM项目实施-需求调查
- VC启动窗口画面制作方法研究
- SMON: found rollback segment # 11 at address 67fd103c to take offline.
- Java Reflection (JAVA反射)
- 追女孩最好时机啊
- 双网卡实现自动负载均衡
- C#实现大文件分块发送到客户端
- 昨天晚上看了一场经典的放水大战
- 最近的工作安排
- 使用Oracle Wrap工具加密你的代码
- C++ Primer学习笔记-第七章杂记