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

2年前 (2022) 程序员胖胖胖虎阿

194 0 0

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:\ORACLE\PRODUCT\10.2.0\ORADATA\ORAWIN\REDO01.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;

版权声明：程序员胖胖胖虎阿发表于 2022年10月4日上午1:08。
转载请注明：【Vegas原创】DB或DG出现的ORA-16038解决-日志无法归档（startup时log不能archive） | 胖虎的工具箱-编程导航