oracle TSPITR with IOT
在做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部落格 ” ,連結:http://blog.itpub.net/271063/viewspace-1031121/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle tspitrOracle
- ORACLE TSPITR 介紹Oracle
- oracle IOT表學習Oracle
- oracle-tom-table-iotOracle
- Oracle 索引組織表(IOT)Oracle索引
- Oracle Index-organized table (IOT)概述OracleIndexZed
- oracle iot索引組織表(一)Oracle索引
- oracle iot索引組織表(二)Oracle索引
- TSPITR測試!
- Oracle RMAN實現“一鍵式”表空間TSPITROracle
- 簡述Oracle IOT(Index Organized Table)(上)OracleIndexZed
- 簡述Oracle IOT(Index Organized Table)(下)OracleIndexZed
- 簡述Oracle IOT(Index Organized Table)(中)OracleIndexZed
- Oracle表空間時間點恢復技術TSPITROracle
- Oracle OCP 1Z0 053 Q370(TSPITR)Oracle
- 利用RMAN做TSPITR
- RMAN全自動TSPITR
- ORACLE 11g TSPITR恢復被刪除的表空間Oracle
- RMAN: Tablespace Point In Time Recovery (TSPITR)
- Backup And Recovery User's Guide-TSPITR 約束、特定情形、限制-TSPITR的限制GUIIDE
- oracle小知識點10--表空間時間點恢復(TSPITR)Oracle
- Enhanced Tablespace Point-In-Time Recovery (TSPITR)
- index table (IOT)Index
- 表空間TSPITR恢復-實驗
- 根據表空間的TSPITR恢復
- Backup And Recovery User's Guide-RMAN TSPITR模型GUIIDE模型
- IOT相關協議協議
- iot 對接科星
- NB-IoT網路是什麼?NB-IoT具有哪些特點?
- 實戰10g新特性之RMAN TSPITR特性
- 利用rman的TSPITR技術找回刪除的表!
- 什麼是物聯網 (IoT) ? IoT驅動的CRM是怎樣的?
- 阿里雲IoT初試阿里
- ESP32-RESTful IoT教程REST
- 採用Dapr 的IoT 案例
- [20170627]使用TSPITR恢復表空間.txt
- 對刪除分割槽的分割槽表執行TSPITR
- 對分割槽表的部分分割槽執行TSPITR