[Troubleshooting]:ORA-15046 – ASM File Name Not In Single-file Creation While Restoring Database In VM DB System (OCI)

This blog post covers the issue & fix which I encountered while performing the Restore of the database in VM DB System In Oracle Cloud Infrastructure.

In Oracle Cloud Infrastructure, there are two types of Database, one is User-Managed & second is Autonomous Database (ADB), within User-Managed Database, we have three types of Databases

1. VM DB System
2. Bare Metal DB System
3. Exadata DB System

Read our blog to know more about each of these databases.

Background

In Oracle Cloud When you configured Databases either on VM DB System, Bare Metal DB System or Exadata DB System,  you can either use Cloud Console To Take the backup of your databases, RMAN or using cloud tools like dbcli to take backup, here dbcli is a command-line utility which comes inbuilt when provisioned your Database VM DB System, Bare Metal DB System or Exadata DB System and using that you can perform complete administration of your database such as patching, cloning, backup & recovery, setting up data-guard, etc.

To know more about dbcli, click here

When you take a backup of the database, you either take to local storage, which is generally not recommended and second is to move your backup to object storage which is recommended by oracle and for that, you have to use service gateway, which privately connects to object storage without exposing to the internet.

Check out our blog to know more about Backup Oracle Database on Cloud.

Note: Oracle Cloud Infrastructure service gateway allows access to Oracle services within the region to protect your data from the internet. To know more click here

I was creating a HOL for our DBA To Cloud DBA Training of Backup & Recovery, where I am adding steps to test the below failover scenario.

• Backup the database to local storage (Flash Recovery Area)
• Manually DROP the Database
• Restore the database from the backup

Note: Oracle Recommends if you are using DBCS then always take backup to Oracle Cloud object storage and use GUI to take the backup, ie cloud console

Issue Encountered

While restoring the Database from backup in  VM DB System in Oracle Cloud Infrastructure (OCI) I  hit with an error as ”

“RMAN-03002: failure of restore command at 01/20/2020 07:45:15
ORA-19870: error while restoring backup piece c-917830566-20200120-02
ORA-32015: unable to restore SPFILE
ORA-17502: ksfdcre:4 Failed to create file +DATA/K21DB_FRA124/PARAMETERFILE/spfile.269.1030171207
ORA-15046: ASM file name ‘+DATA/K21DB_FRA124/PARAMETERFILE/spfile.269.1030171207’ is not in single-file creation form”

Cause

After debugging this, I haven’t found any root cause of this error, it looks like this is a bug with ASM in VM DB System.

Fix

I have Change the restore command  from

run

{

allocate channel c1 device type sbt PARMS ‘SBT_LIBRARY=/home/oracle/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/home/oracle/config)’;

restore spfile from autobackup;

 }

To

run

{

allocate channel c1 device type sbt PARMS ‘SBT_LIBRARY=/home/oracle/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/home/oracle/config)’;

restore spfile to ‘/u01/app/oracle/product/12.2.0.1/dbhome_1/dbs/spfile.ora’

from autobackup;

 }

This will dosen’t look into ASM to restore the spfile, as I have specify the $ORACLE_HOME/dbs location to restore the spfile.

I hope you find the post useful in troubleshooting  “ORA-15046 – ASM File Name Not In Single-file Creation In VM DB System“, if you like the post don’t forget to share with your friends and colleague and post your doubts in the comment section.

Related/Further Readings

• Oracle Cloud Infrastructure: Database Offerings
• Recovering a Database from Object Storage
• Role of Oracle DBA in Cloud: Transition from DBA to Cloud DBA
• DBA To Cloud DBA Training (OCI): Step By Step Activity Guides/Hands-On Lab Exercise

Next Task For You

If you want to upgrade your career from an Oracle DBA to Oracle Cloud DBA, and wants to clear Oracle Cloud Database Service Specialist[1Z0-1093-21] & Oracle Cloud Autonomous Database Certification[1Z0-931-21] with 18 Hands-On labs, then register for a FREE class, and don’t miss an opportunity to gain a plethora of insights on becoming a certified Oracle Cloud DBA.