SCO backup fails with error "ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated"
- Views:
- 110
- 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
