My Oracle Support Banner

[OCI] Launch from Backup Failed: DCS-10001:Internal error encountered: Failed to run NID utility..Failed to run nid utilityError (Doc ID 2723088.1)

Last updated on NOVEMBER 28, 2020

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

Launch OCI DB system from backup failed as following.

For gathering the DCS agent log, dbcli output, the VM should be reachable. Since no IP address was assigned for this case so please file a SR to Oracle Support to get the IP address from backend.

# /opt/oracle/dcs/bin/dbcli list-jobs

ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
......
<JOB_ID> Database service recovery with db name: <DB Name> October 22, 2020 9:30:58 AM UTC Failure

# /opt/oracle/dcs/bin/dbcli describe-job -i <JOB_ID>

Job details
----------------------------------------------------------------
ID: <JOB_ID>
Description: Database service recovery with db name: <DB Name>
Status: Failure
Created: October 22, 2020 9:30:58 AM UTC
Progress: 67%
Message: DCS-10001:Internal error encountered: Failed to run NID utility..Failed to run nid utilityError:

Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
Restore Database October 22, 2020 9:30:59 AM UTC October 22, 2020 10:01:23 AM UTC Failure
Restore Database October 22, 2020 9:30:59 AM UTC October 22, 2020 10:01:23 AM UTC Failure
Restore Database October 22, 2020 9:30:59 AM UTC October 22, 2020 10:01:23 AM UTC Failure
Prepare DB System for Restore October 22, 2020 9:30:59 AM UTC October 22, 2020 9:36:40 AM UTC Success
Configure TDE October 22, 2020 9:36:40 AM UTC October 22, 2020 9:37:11 AM UTC Success
Restore Database October 22, 2020 9:37:11 AM UTC October 22, 2020 10:01:23 AM UTC Failure
task:TaskSequential_4965 October 22, 2020 9:37:11 AM UTC October 22, 2020 10:01:23 AM UTC Failure
Change DBID and/or DBName October 22, 2020 10:00:34 AM UTC October 22, 2020 10:01:22 AM UTC Failure

DCS agent log shown nid failed when changing DBID.

2020-10-22 10:01:21,303 DEBUG [Change DBID and/or DBName : JobId=<JOB ID>] [] c.o.d.c.u.CommonsUtils:
run: cmd= '[su,
-,
oracle,
-c,
export ORACLE_SID=<SID>;
export ORACLE_UNQNAME=<DB Name>;
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1;
export LANG=en_US.UTF-16;
/u01/app/oracle/product/19.0.0.0/dbhome_1/bin/nid target=******** logfile=/tmp/nid_<DB Name>_nrt1zt_2020-10-22_10-00-36.0631.log PDB=ALL]'
2020-10-22 10:01:22,438 DEBUG [Change DBID and/or DBName : JobId=<JOB ID>] [] c.o.d.c.u.c.CommandExecutor: Return code: 1
2020-10-22 10:01:22,438 ERROR [Change DBID and/or DBName : JobId=<JOB ID>] [] c.o.d.a.r.s.r.RecoveryActions: Failed to run nid utility

The nid log is as following, that's meaning there is an offlined datafile.

Control Files in database:
+RECO/<DB Name>/CONTROLFILE/current.256.1054460403

NID-00600: Internal Error - [17] [10] [1] [1]

Change of database ID failed during validation - database is intact.
DBNEWID - Completed with validation errors.

Meanwhile, from Alert log and RMAN log we can see File #10 was OFFLINED.

Alert log: 

<PDB Name>(3):File #10 found in data dictionary but not in controlfile.
<PDB Name>(3):Creating OFFLINE file 'MISSING00010' in the controlfile.

RMAN log:

......
datafile 10 not processed because file is offline
......

 

Changes

 

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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