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
Sunday, July 27, 2008
RMAN TSPITR + ORA-25153
Subscribe to:
Post Comments (Atom)
1 comment:
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.
Post a Comment