My Oracle Support Banner

[OCI] Recovery Failed by DCS-10001:Internal error encountered: Failed to run sql in method : mountDatabaseAndRestoreSpAndControlFileOnErr.Failed to mount (Doc ID 2706226.1)

Last updated on APRIL 01, 2021

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

At OCI DB system, recovery job failed as following:

# /opt/oracle/dcs/bin/dbcli list-jobs
......
<JOB_ID> Create recovery-latest for db :<DB_Name> June 17, 2020 6:51:16 PM JST Failure

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

Job details
----------------------------------------------------------------
ID: <JOB_ID>
Description: Create recovery-latest for db : <DB_Name>
Status: Failure
Created: June 17, 2020 6:51:16 PM JST
Message: DCS-10001:Internal error encountered: Failed to run sql in method : mountDatabaseAndRestoreSpAndControlFileOnErr.Failed to mount database:<DB_Name>

DCS debug agent log shown:

2020-06-20 13:54:40,008 DEBUG [Database recovery :JobId=<JobID>] [] c.o.d.c.u.CommonsUtils:
run: cmd= '[su,
-,
oracle,
-c,
export NLS_LANG=AMERICAN;
export ORACLE_SID=<DB Name>1;
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1;
export ORACLE_UNQNAME=<DB Name>;
/u01/app/oracle/product/19.0.0.0/dbhome_1/bin/sqlplus -S -L -n / as sysdba @/tmp/dcsserver/sqlplus/sqlplus2020-06-20_13-54-40-6420786330911783178.sql]'
2020-06-20 13:54:58,647 DEBUG [Database recovery :JobId=<JobID>] [] c.o.d.c.u.c.CommandExecutor: Return code: 0
2020-06-20 13:54:58,647 DEBUG [Database recovery :JobId=<JobID>] [] c.o.d.c.u.CommonsUtils: Output
:
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 3.2212E+10 bytes
Fixed Size 12693752 bytes
Variable Size 4160749568 bytes
Database Buffers 2.7984E+10 bytes
Redo Buffers 54411264 bytes
Database mounted.
......
2020-06-20 13:55:00,817 DEBUG [Database recovery :JobId=<JobID>] [] c.o.d.c.u.c.CommandExecutor: Return code: 0
2020-06-20 13:55:00,817 DEBUG [Database recovery :JobId=<JobID>] [] c.o.d.c.u.CommonsUtils: Output
:
Instance <DB Name>1 is running on node <Hostname>. Instance status: . <

2020-06-20 13:55:00,817 INFO [Database recovery :JobId=<JobID>] []c.o.d.a.r.s.GridResourceManager: mount status:null
2020-06-20 13:55:00,817 ERROR [Database recovery :JobId=<JobID>] [] c.o.d.a.r.s.r.RecoveryActions: Failed to mount database:<DB Name>
2020-06-20 13:55:00,819 ERROR [Database recovery :JobId=<JobID>] []
c.o.d.c.j.JsonRequestProcessor: RPC request invocation failed on request:
{"classz":"******** "
! com.oracle.dcs.commons.exception.DcsException: DCS-10001:Internal error encountered: Failed to run sql in method :mountDatabaseAndRestoreSpAndControlFileOnErr.Failed to mount database:<DB Name>

 

Meanwhile, the instance was mounted by checking with SQL*Plus.

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> select name, open_mode from v$database;

NAME OPEN_MODE
--------- --------------------
<DB Name> MOUNTED

 

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.