Question

oracle运行一段时间后，就自动停止，怎么回事？连接数据库时报送：ERROR: ORA-01034:

这里是alert_sid.log：
Sat May 14 00:00:12 2011
Thread 1 advanced to log sequence 1277
Current log# 1 seq# 1277 mem# 0: /deve/oracle/app/oracle/oradata/oradb/redo01.log
Sat May 14 00:14:25 2011
Starting background process EMN0
EMN0 started with pid=15, OS id=10899
Sat May 14 00:14:25 2011
Shutting down instance: further logons disabled
Sat May 14 00:14:25 2011
Stopping background process CJQ0
Sat May 14 00:14:25 2011
Stopping background process MMNL
Sat May 14 00:14:26 2011
Stopping background process MMON
Sat May 14 00:14:27 2011
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Sat May 14 00:14:29 2011
ALTER DATABASE CLOSE NORMAL
Sat May 14 00:14:29 2011
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat May 14 00:14:29 2011
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1277
Successful close of redo thread 1
Sat May 14 00:14:29 2011
Completed: ALTER DATABASE CLOSE NORMAL
Sat May 14 00:14:29 2011
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
SQL> show SGA;

Total System Global Area 1207959552 bytes
Fixed Size 1219088 bytes
Variable Size 318768624 bytes
Database Buffers 872415232 bytes
Redo Buffers 15556608 bytes

Answer 1

Oracle DBA神器：PRM-DUL灾难恢复工具可以直接从这种受损的Oracle数据库中将数据拯救出来。
当你的数据库因为ORA-00600/ORA-07445或其他ORA-报错，或丢失关键的system表空间数据文件，或ASM diskgroup损坏时均可以考虑采用PRM-DUL来做恢复。PRM-DUL采用独创的DataBridge恢复技术，直接从数据文件中抽取数据后可以像DBLINK那样直接插入到新建数据库中，而无需数据落地成为DMP文件占用空间。

Answer 2

检查交换区是否耗尽，检查Oracle SGA设置是否过大。

追问

是不是就是共享内存啊，需要设置大一些吗，共享内存是1G
SQL> show SGA;

Total System Global Area 1207959552 bytes
Fixed Size 1219088 bytes
Variable Size 318768624 bytes
Database Buffers 872415232 bytes
Redo Buffers 15556608 bytes

追答

交换区：在windows下也叫虚拟内存或页面文件。
共享内存的设置需要根据操作系统的情况设置，如果机器和系统的可用内存足够，应设置大点。