oracle TSPITR with IOT

wmlm發表於2010-02-04

在做tspitr時,發現組織索引表不能被恢復,在TS_PITR_CHECK 檢查失敗

About to export Tablespace Point-in-time Recovery objects...
EXP-00008: ORACLE error 29308 encountered
ORA-29308: view TS_PITR_CHECK failure
ORA-06512: at "SYS.DBMS_PITR", line 810
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
host command complete
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/04/2010 18:58:39
RMAN-03015: error occurred in stored script Memory Script
RMAN-06135: error executing host command: Additional information: 256

[@more@]

SELECT *
FROM SYS.TS_PITR_CHECK
WHERE (
TS1_NAME IN ('EXAMPLE')
AND TS2_NAME NOT IN ('EXAMPLE')
)
OR (
TS1_NAME NOT IN ('EXAMPLE')
AND TS2_NAME IN ('EXAMPLE')
);

own1 name1 subname1 obj1type ts1_na name2 subname2 obj2type own2 ts2_na cname reason
------ ----- -------- -------- ------ ----- -------- -------- ------ ------ ----- -------------------------
HR REGIO TABLE EXAMPL COUNT TABLE HR SYSTEM COUNT constraint between tables
NS E RIES RY_ID not contained in recovery
_NN set

因為hr.countries 表是IOT

如何解決?

先留個問題在這兒

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/271063/viewspace-1031121/,如需轉載,請註明出處,否則將追究法律責任。

相關文章