连接数据库报错:
查询数据库的归档盘,发现归档磁盘被写满了。
清理归档日志。
登录恢复正常。
归档报错:
Tue Oct 02 16:48:01 2018
Thread 2 advanced to log sequence 122718 (LGWR switch)
Current log# 15 seq# 122718 mem# 0: +DATA/scprd/onlinelog/group_15.374.982183663
Tue Oct 02 16:48:01 2018
LNS: Standby redo logfile selected for thread 2 sequence 122718 for destination LOG_ARCHIVE_DEST_2
Tue Oct 02 16:48:01 2018
ARC0: Error 19504 Creating archive log file to '+FRA'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance SCPRD2 - Archival Error
ORA-16038: log 14 sequence# 122717 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 14 thread 2: '+DATA/scprd/onlinelog/group_14.373.982183653'
Tue Oct 02 16:48:01 2018
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance SCPRD2 - Archival Error
ORA-16014: log 14 sequence# 122717 not archived, no available destinations
ORA-00312: online log 14 thread 2: '+DATA/scprd/onlinelog/group_14.373.982183653'
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22996654/viewspace-2215475/ ,如需转载,请注明出处,否则将追究法律责任。