ORA-00245: control file backup failed; target is likely on a local file system

Posted: April 26, 2016 in Backup and Recovery, CommVault, ORA Errors, RMAN Errors
Tags: , , , ,

Good afternoon, Oracle Aficionados!

This is another installment in response to my post on Making a Test Restore of a RAC DB Using CommVault and Putty SSH Session. Our beloved RMAN tool is a bit fussy at times. If you don’t have every little detail right, it will just quit. Now add CommVault, the GUI of choice for many organizations, and the details become even more critical.

Today’s subject involves another failure message that came up on one of the test restores I have been performing on our Exadata Database RAC Instances. Mr. Tim Dexter, my backup partner in chief, is experimenting on a RAC in place restore. I used his restore to perform this latest test restore.

  • After meticulously following all of the steps to make a test restore, I kicked off the clone job.
  • Within about five minutes, the restore job failed. The abbreviated error stack follows:

ORA-00245: control file backup failed; target is likely on a local file system

  • My first thought was the location of the control file was mixed up. I opened the pfile and looked for the control file location. It was in +DATA/…/… Right where it was supposed to be.
  • Next, I headed out to ASM and looked for that same location. Yep, right where it was supposed to be.
  • This probably didn’t matter, but I next went into RMAN and looked at the configuration settings.

RMAN> SHOW ALL;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+DATA_XDT*/dbm01.f’;

This just didn’t look right. It turns out CommVault didn’t think so either so it decided to fail and assume the snaphot controlfile was on the local file system.

  • I looked into my ASMCMD file system and, sure enough, this was not a valid location. I changed the location to a folder just above the control file location.

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+DATA_XDT*/DBM01/spfiledbm01*.f’;

  • I killed the running clone and started a new one with all of the same settings.
  • Voila! It finished without error and the new test instance was created!

Thanks for reading! Again, please respond with your concerns, findings or challenges.

Warm regards (whatever that means),

Jason Brown

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s