PowerProtect Data Manager | Oracle: Oracle temp tablespace quickly ran out of space ORA-01652
Zusammenfassung: Oracle tablespace ran out of space which affects all PPDM jobs
Dieser Artikel gilt für
Dieser Artikel gilt nicht für
Dieser Artikel ist nicht an ein bestimmtes Produkt gebunden.
In diesem Artikel werden nicht alle Produktversionen aufgeführt.
Symptome
- Oracle Temp tablespace ran out of space due to an Oracle issue which all Oracle Oracle DBs
- We can check the free space available at the TEMP tablespace by running the following on the Oracle box:
- As a result, All PPDM jobs get affected as:
- We can check the free space available at the TEMP tablespace by running the following on the Oracle box:
SQL> select sum(free_blocks) from gv$sort_segment where tablespace_name = 'TEMP';
- As a result, All PPDM jobs get affected as:
- Discovery Issue as we rely on this query: select count ( * ) from v$backup_piece_details;
ddbmcon: 09/30/21 11:29:43.040112 OCIStmtExecute(): failure 1964ddbmcon: 09/30/21 11:29:43.040166 Error - ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
- SQL queries that update backup progress. Backup shows Queued when it starts to run and then completes directly from 'Queued' to 'Complete'
- Backup deletions
- Affected versions: PPDM 19.13 and below
Ursache
Due to an issue from Oracle's side as per Bug:
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=106906340084035&id=2119607.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=nc1l1i21f_4
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=106906340084035&id=2119607.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=nc1l1i21f_4
Lösung
Limitation of Temp space issue is fixed in PPDM 19.14 release
Artikeleigenschaften
Artikelnummer: 000208151
Artikeltyp: Solution
Zuletzt geändert: 31 Mai 2023
Version: 2
Antworten auf Ihre Fragen erhalten Sie von anderen Dell NutzerInnen
Support Services
Prüfen Sie, ob Ihr Gerät durch Support Services abgedeckt ist.