PowerProtect: Data Manager Oracle disaster recovery in UI failed to restore spfile with Oracle 11gR2

Summary: PowerProtect Data Manager | Oracle disaster recovery in UI failed to restore spfile with Oracle 11gR2.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

The restore for spfile fails with the following error: 
RMAN> connect ********
2> 
3> CREATE SPFILE 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "spfile": expecting one of: "catalog, global, restore, script, virtual"
RMAN-01007: at line 3 column 8 file: /tmp/rman_script_xxxx_8368

Cause

The issue is with the Oracle version.
For Oracle 11g, the RMAN clause is required to add sql in the clause.
For Oracle 12c and 19c, it is not required. For example:

RMAN> connect ********
2>
3> sql "CREATE SPFILE"

 

Resolution

This is permanently fixed in PowerProtect Data Manager 19.15.
The current workaround is to use CLI to restore SPFILE first and then do the rest Alternative restore in UI without SPFILE.
The current workaround is to use CLI to restore SPFILE first and then do the rest Alternative restore in GUI without SPFILE.
 

Affected Products

PowerProtect Software
Article Properties
Article Number: 000217633
Article Type: Solution
Last Modified: 19 Sep 2025
Version:  3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.