在自己电脑上测试归档路径满了,导致数据库无法归档的效果。不想费劲把归档路径撑爆,看了下归档路径的大小,改了db_recovery_file_dest_size。重启数据库之后:
SQL> startup
ORACLE instance started.
Total System Global Area 413372416 bytes
Fixed Size 2253784 bytes
Variable Size 327158824 bytes
Database Buffers 79691776 bytes
Redo Buffers 4268032 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 2420
Session ID: 1 Serial number: 5
所以,一定要看好归档路径呀!特别要处理好删除归档与备份软件之间的协调。
处理方法见:
http://blog.csdn.net/ghostliming/article/details/50447598