掌握Ora-00600 4194错误的解决方法
日期：2007年10月28日 作者： 查看:[大字体 中字体 小字体]-
datafile '/opt/oracle/oradata/conner/undotbs1.dbf' size 10M
Sat Jan 21 14:03:29 2006
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Created Undo Segment _SYSSMU14$
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-00'
Completed: create undo tablespace undotbs1
datafile '/opt/ora
Sat Jan 21 14:03:43 2006
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Undo Segment 14 Onlined
Successfully onlined Undo Tablespace 1.
Undo Segment 1 Offlined
Undo Tablespace 16 successfully switched out.
Sat Jan 21 14:03:43 2006
ALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=MEMORY;
Sat Jan 21 14:07:18 2006
SMON: about to recover undo segment 11
SMON: mark undo segment 11 as needs recovery
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as needs recovery
SMON: about to recover undo segment 13
SMON: mark undo segment 13 as needs recovery
Sat Jan 21 14:08:06 2006
drop tablespace undotbs2
Sat Jan 21 14:08:07 2006
Starting control autobackup
Control autobackup written to DISK device
handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-01'
Completed: drop tablespace undotbs2◆请修改参数文件，变更undo表空间，并取消_corrupted_rollback_segments设置:
*.undo_tablespace='UNDOTBS1'
◆然后由参数文件创建spfile文件。
SQL> create spfile from pfile;
- 上一页 [1] [2] [3] [4] 下一页
-
- 掌握Ora-00600 4194错误的解决方法 相关文章：
- ·掌握SQL Server数据库的实用技巧
- ·掌控PC 如何应对僵尸主机及僵尸网络
- ·快速掌握 MySQL数据库中触发器的应用
- ·IE7浏览器需掌握的十个基本知识
- ·利用DW8掌握网页代码基本格式
- ·掌握Ora-00600 4194错误的解决方法
- ·掌握部署 Access项目的方法
- ·轻松掌握清空数据库的好方法
- ·快速掌握 SQL Server 的任务调度
- ·轻松掌握学习数据库的常用函数的用法
- 掌握Ora-00600 4194错误的解决方法 相关软件
- ·掌上泡泡堂
- ·《合金装备 掌上行动Plus》最新演示动画
- ·《如来神掌Online》开放内测0.8.8客户端
- ·手机游戏：掌游堂
- ·掌握中国人性的管理方法
- ·重庆掌故传说
- ·掌握策略规划的精髓
- ·仙人掌兄弟
- ·高考英语听力突破掌上宝
- ·注安和安评必须掌握试题2
- 特别声明：本站除部分特别声明禁止转载的专稿外的其他文章可以自由转载，但请务必注明出处和原始作
- 者.文章版权归文章原始作者所有.对于被本站转载文章的个人和网站，我们表示深深的谢意。如果本站转
- 载的文章有版权问题请联系编辑人员,我们尽快予以更正. 转载请注明来源：http://www.hackhome.com
下一篇:转换 SQL数据库时的疑难问题