Search This Blog

Sunday, July 27, 2008


Today I come across one problem during testing RMAN TSPITR option.

Database Version: (10gr1)

The problem during TSPITR operation RMAN session disconnected with the following errors

About to export Tablespace Point-in-time Recovery objects...

EXP-00008: ORACLE error 25153 encountered

ORA-25153: Temporary Tablespace is Empty

ORA-06512: at "SYS.DBMS_PITR", line 887

ORA-06512: at line 1

EXP-00000: Export terminated unsuccessfully

host command complete

Above error message we face till

This problem fix in or later version.

Above error occur becuase RMAN automatically not create tempfile. After searching on metalink I found below metalink note: Note:263483.1

1 comment:

Ameenuddin said...

Dear Taj,

Apologize, I do not know from where to post queries to you hence just posting a comment for your kind attention.

I am importing database in Oracle 10g, however the import fails with following error:
IMP-00017: following statement failed with ORACLE error 990:
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege

I have searched on web how to grant MERGE permission but I could not find any workarounds. Hence your help would be truly appreciated. Thanks in advance.