◆然后由参数文件创建spfile文件。
SQL> create spfile from pfile; File created. SQL>shutdown immediate; Database closed.Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 97588504 bytes Fixed Size 451864 bytes Variable Size 33554432 bytes Database Buffers 62914560 bytes Redo Buffers 667648 bytes Database mounted.Database opened. |
◆然后重起数据库,观察alert文件:
Sat Jan 21 14:08:36 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. |
◆此时数据库恢复正常,通常建议立即全库exp,然后重新建库,再imp恢复数据库。
,'_SYSSMU12◆此时你可以修改init
___FCKpd___3 |
◆然后使用init
___FCKpd___4 |
现在数据库正常Open。
最新相关文章
发表评论