Opscenter database clone Fails ORA-32002

Question

Hi all,

I was tring to clone a database to another client with Opscenter.

I successfully run pre-clonet check but when I launc the clone I got the error:

&nbsp;

14/09/2015 23:48:01 - begin Restore
	14/09/2015 23:48:01 - Info bpbrm(pid=7320) vbodstest is the host to restore to&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:01 - Info bpbrm(pid=7320) reading file list for client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:01 - connecting
	14/09/2015 23:48:01 - Info bpbrm(pid=7320) starting bptm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:01 - Info bphdb(pid=12090) Restore started&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:01 - connected; connect time: 0:00:00
	14/09/2015 23:48:01 - Info bphdb(pid=12090) Waiting for the child status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Starting Oracle Recovery Manager.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Using: /opt/oracle/11.2/product/dbhome/bin/rman&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Connection info: target /&nbsp; nocatalog&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Start of Recovery Manager input.&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - SET DBID=2359484838&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - # -----------------------------------------------------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - # Create spfile from pfile section&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - # -----------------------------------------------------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - startup force nomount;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - sql "create spfile from pfile=''/opt/oracle/11.2/product/dbhome/dbs/initODS.ora''";&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - shutdown immediate;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - End of Recovery Manager input.&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Start of Recovery Manager output.&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:02 - Info bphdb(pid=12090) INF - Recovery Manager: Release 11.2.0.2.0 - Production on Mon Sep 14 23:48:03 2015
	14/09/2015 23:48:03 - Info bphdb(pid=12090) INF - connected to target database: ODS (not mounted)&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:03 - Info bphdb(pid=12090) INF - using target database control file instead of recovery catalog &nbsp;
	14/09/2015 23:48:07 - Info bphdb(pid=12090) INF - Oracle instance started&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:08 - Error bpbrm(pid=7320) from client vbodstest: ERR - Script exited with status = 1 &lt;the requested operation was partially successful&gt;
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Total System Global Area&nbsp;&nbsp; 14965264384 bytes&nbsp; &nbsp;
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Fixed Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2241040 bytes
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Variable Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7079988720 bytes
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Database Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7851737088 bytes
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Redo Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 31297536 bytes
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - sql statement: create spfile from pfile=''/opt/oracle/11.2/product/dbhome/dbs/initODS.ora''&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - RMAN-00571: ===========================================================&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - RMAN-00571: ===========================================================&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - RMAN-03009: failure of sql command on default channel at 09/14/2015 23:48:09
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - RMAN-11003: failure during parse/execution of SQL statement: create spfile from pfile='/opt/oracle/11.2/product/dbhome/dbs/initODS.ora'
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - ORA-32002: cannot create SPFILE already being used by the instance
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - Recovery Manager complete.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - End of Recovery Manager output.&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - End Oracle Recovery Manager.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:08 - Error bpbrm(pid=7320) from client vbodstest: ERR - bphdb exit status = 5: the restore failed to recover the requested files
	14/09/2015 23:48:08 - Info bphdb(pid=12090) done. status: 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;
	14/09/2015 23:48:08 - Info bphdb(pid=12090) done. status: 5: the restore failed to recover the requested files &nbsp;
	14/09/2015 23:48:08 - Error bpbrm(pid=7320) client restore EXIT STATUS 5: the restore failed to recover the requested files
	14/09/2015 23:48:09 - end Restore; elapsed time: 0:00:08

&nbsp;

Could You help me?

marianne · Answer

I am not an Oracle db, but I see this error :
 RMAN-11003: failure during parse/execution of SQL statement: create spfile from pfile='/opt/oracle/11.2/product/dbhome/dbs/initODS.ora'
14/09/2015 23:48:08 - Info bphdb(pid=12090) INF - ORA-32002: cannot create SPFILE already being used by the instance

Get your dba to investigate perhaps?

ilgizn · Answer

Hello,

Delete file&nbsp;initODS.ora and make clone database again.

&nbsp;

maurog · Answer

I am not a dba too I was tring too.

I was just wondering if a "profane" like me could take some advantage using the clone datatbase function to restore a db without dba intervention.

It looks that netbackup write the file as soon as the restore starts. Then it got something wrong.

When the restore ends with error 5 I found all the db processes UP and the file mentioned restored.

marianne · Answer

You will need logs on destination client to troubleshoot...

dbclient log for starters...
	(Remember 777 permissions)

Forum Discussion

Opscenter database clone Fails ORA-32002

Related Content

OpsCenter database backup

OpsCenter database backup

Database Logins for OpsCenter

opscenter Netbackup IT analytics upgrade

Delete from Opscenter Database

Recent Discussions

Netbackup Catalog backup growing

Instant Access for vmware problem

Need an advise on Backup strategy for long term retention

Did a catalogue restore, but seem to have missing information.

ost datadomain download file