DB或DG出现的ORA-16038解决-日志无法归档（startup时log不能archive）

本文主要是介绍DB或DG出现的ORA-16038解决-日志无法归档（startup时log不能archive），希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

DB：

现象：

SQL> startup
ORACLE instance started.
Total System Global Area  612368384 bytes
Fixed Size                  1292036 bytes
Variable Size             268437756 bytes
Database Buffers          335544320 bytes
Redo Buffers                7094272 bytes
Database mounted.
ORA-16038: log 1 sequence# 51 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1:
'F:ORACLEPRODUCT10.2.0ORADATAORAWINREDO01.LOG'

方案：

SQL> alter database clear unarchived logfile group 1;
Database altered.
SQL> alter database open;
Database altered.
SQL>

==================================================================

==================================================================
DG：
现象：
Errors in file /u01/app/oracle/admin/oratest/bdump/oratest_arc0_29973.trc:
ORA-16038: log 4 sequence# 73 cannot be archived
ORA-16040: standby destination archive log file is locked
ORA-00312: online log 4 thread 1: '/u01/app/oracle/oradata/oratest/standbyredo01.log'

解决方案：

SQL> alter database recover managed standby database cancel;
SQL> alter database clear unarchived logfile group 4;
SQL> alter database recover managed standby database disconnect from session;

这篇关于DB或DG出现的ORA-16038解决-日志无法归档（startup时log不能archive）的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---