有客户反馈数据库无法使用了,客户手动启动报错如下
SQL> startup;
ORACLE instance started.
Total System Global Area 2.6924E+10 bytes
Fixed Size 2265984 bytes
Variable Size 1.3959E+10 bytes
Database Buffers 1.2952E+10 bytes
Redo Buffers 11202560 bytes
Database mounted.
ORA-16038: log 4 sequence# 90852 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 4 thread 2:
'+DATA/orcl/onlinelog/group_4.266.902227703'
登录查看alert日志,报错
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_8017.trc:
ORA-16038: log 4 sequence# 90852 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 4 thread 2: '+DATA/orcl/onlinelog/group_4.266.902227703'
ORA-16038 signalled during: ALTER DATABASE OPEN /* db agent *//* {1:23032:2} */...
Sun Oct 29 10:20:41 2023
Shutting down instance (abort)
再查看磁盘组的空间,确认是归档空间满了
[grid@db1 ~]$ asmcmd -p lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 512000 6 0 6 0 N FRA/
MOUNTED EXTERN N 512 4096 1048576 10240 9836 0 9836 0 Y CRS/
MOUNTED EXTERN N 512 4096 1048576 512000 322556 0 322556 0 N DATA/
[grid@db1 ~]$
处理办法
su - grid
asmcmd -p
cd +fra/orcl/archivelog
rm -rf 删除部分早期的归档文章来源:https://www.toymoban.com/news/detail-721071.html
重新手动启动数据库文章来源地址https://www.toymoban.com/news/detail-721071.html
到了这里,关于oracle rac-归档满处理的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!