Skip to main content


 

 

How can we help you?

 

 
Druva Documentation

Backup fails with an error “Can not backup SPFILE because the instance was not started with SPFILE “

Heads up!

We've transitioned to a new documentation portal to serve you better. Access the latest content by clicking here.

Problem Description

This issue can  happen when you try to take backup of oracle server using Phoenix Oracle DTC agent and the backup fails with the message “Can not backup SPFILE because the instance was not started with SPFILE “

Cause

A backup command requested a backup of the SPFILE, but no SPFILE was used to startup the instance.

Traceback

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/09/2022 22:20:31
RMAN-06062: can not backup SPFILE because the instance was not started with SPFILE

Resolution

  • Start the database from an SPFILE in order to backup an SPFILE with RMAN. Use the below command to check SPFILE:-
  • In sqlplus run this command:

sqlplus> show parameter spfile

  • If SPFILE is not present, create an SPFILE and re-start the instance using the SPFILE(Please contact Oracle team to follow this action plan)

Note: If SPFILE does not exist then you can create one as SYS user.To create SPFILE contact DBA.

  • Was this article helpful?