Messages in the alert.log (ORA-00376 Error 376 encountered while recovering transaction) after partial restore and open resetlogs.
(Doc ID 283846.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206.0 [Release 8.1.7 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Trying to clone the database with a subset of tablespaces from production backup
Offline dropped unwanted datafiles or the controlfile is created without them.
Did SCN/SEQUENCE/TIME based incomplete recovery and opened the database with resetlogs option successfully.
But SMON transaction recovery is failing with the following messages in the alert.log
ORA-00376: file 263 cannot be read at this time
ORA-01111: name for data file 263 is unknown - rename to correct file
ORA-01110: data file 263: '<path>/dbs/MISSING00263'
ORACLE Instance STAGE (pid = 8) - Error 376 encountered while recovering transaction (8, 81) on object 1426463.
This is expected that SMON will report the error if the datafile is offline dropped or the controlfile is created without the datafile. While processing the alter database open resetlogs command all the missing datafiles and tablespaces will be added into the controlfile after checking with dictionary because oracle always thinks that dictionary always contains the right information.Corresponding messages will be written to the alert.log
Creating OFFLINE file 'MISSING00117' in the controlfile.
This file can no longer be recovered so it must be dropped.
Tablespace 'tablespace name' #233 found in data dictionary,
but not in the controlfile. Adding to controlfile.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document