Skip to main content
NetApp Knowledge Base

SCO backup fails with error "ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated"

Views:
96
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
SNAPX
Last Updated:
10/21/2024, 7:03:08 AM

Applies to

SnapCenter plug-in for Oracle (SCO)

Issue

SnapCenter plug-in for oracle fails with following error.

DEBUG pool-1189-thread-1 c.n.o.c.j.SoftPreparedStatement - ORACLE-10000: Executing SQL query: SELECT CDB from V$DATABASE
DEBUG pool-1189-thread-1 c.n.o.c.j.SoftPreparedStatement - ORACLE-10007: Finished executing SQL in 0:00:00.010: SELECT CDB from V$DATABASE
DEBUG GtMeta-prepoamC c.n.o.c.s.d.DatabaseSpecificationService - Completed method  isCDB within 0.040170 seconds.
INFO  GtMeta-prepoamC c.n.s.s.p.b.m.DataOnlyDatabaseMetadataBackupMapper - SCO-LOG-1031: DataOnlyDatabaseMetadataBackupMapper - isCDB: true
INFO  GtMeta-prepoamC c.n.s.s.p.b.m.DataOnlyDatabaseMetadataBackupMapper - SCO-LOG-1032: DataOnlyDatabaseMetadataBackupMapper - collecting PDB metadata...
DEBUG GtMeta-prepoamC c.n.o.c.c.ObjectCache - Get invoked on ObjectCache for key DatabaseContext [uniqueConfigurationId=125332, sid=<sid_name>, databaseName=<db_name>, host=<host_name>, port=1521, tnsName=null, rmanCatalogTnsName=, rmanCatalogUserName=, isSysDba=true]
DEBUG GtMeta-prepoamC c.n.o.c.c.ObjectCache - Cache Hit : Getting  object from cache for key DatabaseContext [uniqueConfigurationId=125332, sid=<sid_name>, databaseName=<db_name>, host=<host_name>, port=1521, tnsName=null, rmanCatalogTnsName=, rmanCatalogUserName=, isSysDba=true]
DEBUG GtMeta-prepoamC c.n.o.c.j.JDBCTemplate - SQL Query timeout set to 10800 seconds
DEBUG GtMeta-prepoamC c.n.o.c.j.JDBCTemplate - Plugin SQL Query timeout set to 10800 seconds
DEBUG pool-1190-thread-1 c.n.o.c.j.SoftPreparedStatement - ORACLE-10000: Executing SQL query: SELECT PDB.DBID as PDB_DBID, PDB.PDB_ID as PDB_ID, PDB.PDB_NAME as PDB_NAME, PDB.STATUS as PDB_STATUS, TS.NAME as TS_NAME, CDBTS.CONTENTS as DBATS_CONTENTS, CDBTS.STATUS as DBATS_STATUS, CDBTS.BLOCK_SIZE as DBATS_BLOCK_SIZE, DF.NAME AS DF_NAME, DF.STATUS as DF_STATUS, DF.ENABLED as DF_ENABLED, DF.BYTES as DF_BYTES, DF.FILE# as DF_FILE# FROM V$DATAFILE DF, V$TABLESPACE TS, CDB_PDBS PDB, CDB_TABLESPACES CDBTS WHERE DF.TS# = TS.TS# AND DF.CON_ID = TS.CON_ID AND DF.CON_ID = PDB.CON_ID AND DF.CON_ID = CDBTS.CON_ID AND TS.NAME = CDBTS.TABLESPACE_NAME AND TS.CON_ID = CDBTS.CON_ID ORDER BY PDB_ID, TS.NAME

2024-09-24T09:17:20.0000095+01:00 DEBUG pool-1190-thread-1 c.n.o.c.j.SoftPreparedStatement - caught SQLException ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated

 

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.