在做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
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博客 ” ，链接：https://blog.itpub.net/271063/viewspace-1031121/ ，如需转载，请注明出处，否则将追究法律责任。
