Backup fails with an error “Can not backup SPFILE because the instance was not started with SPFILE “
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.