Hi everyone,
I have a problem with backup Oracle CDB database with one PDB database.
Oracle RDBMS 19.19
Commvault 11.24.94
Result in log:
select distinct 'U,', c.name || ':' || s.tablespace_name from cdb_segments s, v$CONTAINERS c where s.owner in ('SYS', 'SYSTEM') and c.CON_ID = s.CON_ID * ERROR at line 1: ORA-12801: error signaled in parallel query server P003 ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Commvault make 5 sessions on Oracle DB and each one perform:
select distinct 'U,', c.name || ':' || s.tablespace_name from cdb_segments s, v$CONTAINERS c where s.owner in ('SYS', 'SYSTEM') and c.CON_ID = s.CON_ID
UNION select distinct 'U,', c.name || ':' || s.TABLESPACE_NAME from cdb_all_tables, cdb_segments s, v$CONTAINERS c WHERE s.owner in ('SYS', 'SYSTEM') and c.CON_ID = s.CON_ID
UNION select distinct 'U,', c.name || ':' || s.TABLESPACE_NAME from cdb_rollback_segs s, v$CONTAINERS c where s.CON_ID = c.CON_ID
UNION select distinct 'U,',c.name || ':' || tab.tablespace_name from cdb_all_tables tab
join (select CON_ID, owner, container_name from cdb_mviews) mv on tab.OWNER = mv.OWNER and tab.CON_ID = mv.CON_ID
and tab.table_name = mv.container_name
join v$CONTAINERS c on tab.CON_ID = c.CON_ID
UNION select distinct 'U,', c.name || ':' || s.tablespace_name from
(select CON_ID, INDEX_NAME, INDEX_TYPE, TABLE_OWNER, TABLE_NAME from cdb_indexes
where index_type in('DOMAIN','FUNCTION-BASED DOMAIN'))i
join cdb_segments s on( i.CON_ID = s.CON_ID and i.table_owner=s.owner and i.table_name=s.segment_name)
join v$CONTAINERS c on c.CON_ID = i.CON_ID
When I perform this sql via sqlplus get the same error. Of course I check TEMP and it was in fact ended (think that 128GB temp space is enough to perform thos select).
Have any of you this type of problem or have Commvault 11.24.94 with Oracle PDBs and can perform this sql manualy to check if the problem occurs?