首页 > 其他 > 详细

ORA-16038

时间:2014-02-24 21:39:23      阅读:568      评论:0      收藏:0      [点我收藏+]

--发现问题

bubuko.com,布布扣
20:16:45 SYS@ BJDB>alter database open;
alter database open
*
ERROR at line 1:
ORA-16038: log 2 sequence# 211 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
ORA-00312: online log 2 thread 1: /dsk1/oradata/bjdb/redo02a.log
ORA-00312: online log 2 thread 1: /dsk2/oradata/bjdb/redo02b.log
bubuko.com,布布扣

--分析问题,发现/dsk4居然满了,导致无法完成归档

bubuko.com,布布扣
bjdb-> df -h
Filesystem                    Size  Used Avail Use% Mounted on
/dev/sda1                      26G  6.5G   18G  28% /
tmpfs                         3.0G  524M  2.5G  18% /dev/shm
/dev/mapper/datavg-lv_data1 12G  6.6G  4.7G  59% /u01
/dev/mapper/datavg-lv_dsk1  5.0G  499M  4.2G  11% /dsk1
/dev/mapper/datavg-lv_dsk2  5.0G  489M  4.2G  11% /dsk2
/dev/mapper/datavg-lv_dsk3  5.0G  139M  4.6G   3% /dsk3
/dev/mapper/datavg-lv_dsk4  2.6G  2.5G   18M 100% /dsk4
bjdb-> 
bubuko.com,布布扣

--解决思路
清除磁盘空间占用,为新归档腾出空间

ORA-16038

原文:http://www.cnblogs.com/arcer/p/3562507.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!