Search This Blog

Sunday, July 27, 2008

RMAN TSPITR + ORA-25153

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

Database Version: 10.1.0.2.0 (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 10.1.0.4.0.

This problem fix in 10.1.0.5.0 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:
"GRANT MERGE ON "T_HIERARCHYLEVELS" TO "NGPPLANT""
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.