ORA-16038
ORA
2023-09-14 09:01:14 时间
--发现问题
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'
--分析问题,发现/dsk4居然满了,导致无法完成归档
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->
--解决思路
清除磁盘空间占用,为新归档腾出空间
相关文章
- ORA-15055 ASM Diskgroup Status Showing Dismounted From RDBMS Instance
- 【Oracle】逻辑备份失败ORA-39002,39070,29283,06512
- 【Oracle】ORA-00054 错误解决方法
- 【ORACLE】ORA-00245: control file backup operation failed
- 【ORACLE】ORA-12547: TNS:lost contact
- ORA-00917: missing comma
- ORA-19563: header validation failed for file
- ORA-00988: missing or invalid password(s)
- ORA-12504:TNS:监听程序在CONNECT_DATA中未获得SERVICE_NAME
- ORA-02429: cannot drop index used for enforcement of unique /primary key
- ORA-28002: 7 天之后口令将过期
- ORA-01039
- ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
- ORA-12545: Connect failed because target host or object does not exist
- ORA-02374 ORA-12899 ORA-02372
- 解决ora-01034和ora-27101错误
- ORA-01039
- Ora-00911:无效字符
- 报错"ORA-01861: 文字与格式字符串不匹配"
- 基于ORA-12170 TNS 连接超时解决办法详解
- Oracle ORA-12899
- ORA-**,oracle 12c操作问题
- ORA-28040: No matching authentication protocol Oracle 19c
- ORA-00845: MEMORY_TARGET not supported on this system