客户只读业务放在备库,发现数据不实时,检查备库alert日志发现如下报错:
Fri Nov 19 19:40:14 2021
ARC0: Error 19502 Closing archive log file '/u01/archivelog/2_20500_994348122.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance dbserver - Archival Error
ORA-16038: log 16 sequence# 20500 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 16 thread 2: '/u01/oradata/dbserver/onlinelog/group_16.310.1011263923'
ORA-16038 ORA-19502 ORA-00312故障一般是由于归档空间满导致,检查磁盘空间
[oracle@hiszb ~]$ df -Th
df: `/root/.gvfs': Permission denied
Filesystem Type Size Used Avail Use% Mounted on
/dev/mapper/vg_hiszb-lv_root
ext4 9.5G 5.3G 3.8G 59% /
tmpfs tmpfs 5.9G 224K 5.9G 1% /dev/shm
/dev/sda1 ext4 976M 42M 884M 5% /boot
/dev/mapper/vg_hiszb-lv_home
ext4 20G 13G 5.7G 69% /home
/dev/mapper/vg_hiszb-lv_oracle
ext4 432G 431G 12M 99% /u01
/dev/mapper/diskdata-lvdata
ext2 294G 191G 89G 69% /u02
清理空间后恢复正常