SLTechnology News&Howtos › Database ›

Oracle 12c DG slave library Alert error ORA-01110

Shulou Source: shulou.com Published: 2022-06-01 21:19:08 10月02日 Update

The environment is 12.2.0.1 version. The Oracle Data Guard slave database failed to recover today. After RMAN recovery, it was found that the slave database Alert has been reporting an error, but the master database synchronization is consistent and the data is consistent.

2018-07-05T23:42:22.184048+08:00

Errors in file / u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_m000_129832.trc:

ORA-01110: data file 7:'/ u01 *

2018-07-05T23:42:22.258112+08:00

Errors in file / u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_m000_129832.trc:

ORA-01110: data file 8:'/ u01 apprenticeship oradataUniplicationdwjrstdydbpdbscarpDwjrdbpdbOnSyste01.dbf'

2018-07-05T23:42:22.332476+08:00

Errors in file / u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_m000_129832.trc:

ORA-01110: data file 9:'/ u01 apprenticeship oradataUniplicatedwjrstdydbpdbOnOnSysaux01.dbf'

2018-07-05T23:42:22.406769+08:00

Errors in file / u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_m000_129832.trc:

ORA-01110: data file 10:'/ u01 apprenticeship oradataUndotbs01.dbf'

2018-07-05T23:42:22.481081+08:00

Errors in file / u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_m000_129832.trc:

ORA-01110: data file 11:'/ u01qapachexoradataUniple dwjrstdydbip dwjrdbpdbip users01.dbf'

Refer to the MOS documentation:

ORA-01110 For All Files In Standby Database (document ID 2322290.1)

CHANGES

New or Upgraded Standby on 12.2.0.1

CAUSE

Unpublished Bug 24844841: PHSB:CDB M000 REPORTED ORA-1110 ON ADG WHEN A DATAFILE IS ADDED ON PRIMARY

Is logged for error ORA-1110 being reported incorrectly on the Standby database alert log when a datafile change is made on the primary.

The bug is fixed in 19.1.

Backport requests can be made for 12.1 & 12.2

Rediscovery:

=

Function kcidr_file_header_check_common is File Header check which cause of this issue. If you see this in the Stack Trace and Standby opens Read only successfully then you are most likely encountering this bug.

SOLUTION

To Solve the issue:

Apply fix of Bug 24844841. Please check for backports for your version and operating system.

If patch#24844841 is not available then please open an SR to request.

To Workaround:

Restart the standby database and managed recovery.

For the record, a good memory is not as good as a bad pen.