My Oracle Support Banner

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 08, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.2.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.
***Checked for relevance on 26-Oct-2012***

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.


Goal


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.

Solution

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
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.