PSAPTEMP is empty

Problema 1:

ORA-12012: error on auto execute of job 8936

ORA-25153: Temporary Tablespace is Empty

Problema 2:

- No alert.log.

WARNING: The following temporary tablespaces contain no files.

This condition can occur when a backup controlfile has

been restored.  It may be necessary to add files to these

tablespaces.  That can be done using the SQL statement:

Referencia

Note 600513 - ORA-25153 after recovery due to missing tempfiles

Solução

- Rode o comando find / -name file para localizar os datafiles referentes a esta tablespace.

Ex:

maqtst@root:/:#find / -name temp.*

/oracle/TST/sapdata1/temp_1/temp.data1

maqtst@root:/:#

- No sqlplus rodar o comando abaixo para cada datafile localizado.

Comando: alter tablespace PSAPTEMP add tempfile '<filename>' reuse;

Ex:

SYS@TST>alter tablespace PSAPTEMP add tempfile '/oracle/TST/sapdata1/temp_1/temp.data1' reuse;

Tablespace altered.

SYS@TST>

- Executar novamente o job na db13 e verificar na db02.

Abraços