今天打开库时出现问题,原来是空间占满(前两天回家了,回来后发现库起不来,咳,一个小问题反应大思考)
报错如下:
SQL> startup
ORACLE instance started.
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 96470608 bytes
Database Buffers 184549376 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-16038: log 1 sequence# 59 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
Fixed Size 1218992 bytes
Variable Size 96470608 bytes
Database Buffers 184549376 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-16038: log 1 sequence# 59 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
切换到另一个shell下:
[root@xn-test ~]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda3 18175692 17237556 0 100% /
/dev/sda1 101086 10125 85742 11% /boot
tmpfs 517700 0 517700 0% /dev/shm
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda3 18175692 17237556 0 100% /
/dev/sda1 101086 10125 85742 11% /boot
tmpfs 517700 0 517700 0% /dev/shm
呵呵,看来有人偷懒了。
解决办法:
把空间弄出来 就可以了,在这我是把归档删除。
[oracle@xn-test archive-1]$ yes|rm *.arc
[oracle@xn-test archive-1]$ cd ../archive-2
[oracle@xn-test archive-2]$ yes|rm *.arc
[oracle@xn-test archive-2]$ cd ../archive-3/
[oracle@xn-test archive-3]$ yes|rm *.arc
[oracle@xn-test archive-1]$ cd ../archive-2
[oracle@xn-test archive-2]$ yes|rm *.arc
[oracle@xn-test archive-2]$ cd ../archive-3/
[oracle@xn-test archive-3]$ yes|rm *.arc
在这不可以这么干,应该是把已备份的删除
[root@xn-test ~]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda3 18175692 9430784 7806712 55% /
/dev/sda1 101086 10125 85742 11% /boot
tmpfs 517700 0 517700 0% /dev/shm
[root@xn-test ~]#
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda3 18175692 9430784 7806712 55% /
/dev/sda1 101086 10125 85742 11% /boot
tmpfs 517700 0 517700 0% /dev/shm
[root@xn-test ~]#
现在可以了:
SQL> alter database open
2 ;
2 ;
Database altered.
一个小问题,看来什么都不能偷懒啊。
转载于:https://blog.51cto.com/qhd2004/240222