DB:
现象:
方案:
==================================================================
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
>
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 '
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 >
==================================================================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;
SQL > alter database clear unarchived logfile group 4 ;
SQL > alter database recover managed standby database disconnect from session;