ORA-38760: This database instance failed to turn on flashback database 錯誤解決
ORA-38760: This database instance failed to turn on flashback database 錯誤解決過程
問題現象:
一大早起床把資料庫開啟,本來想做個測試,結果不料彈出ORA-38760: This database instance failed to turn on flashback database的錯誤,這個錯誤很顯然是由於flashback導致的錯誤。
錯誤分析:
首先從錯誤現象來看,是由於flashback開啟了,因為flashback檔案丟失而無法使用flashback從而後觸發了這個錯誤。那麼正常情況下應該是不會報錯的。
alter 日誌錯誤資訊如下:
Errors in file c:\oracle\product\10.2.0\admin\wwl\bdump\wwl_rvwr_5416.trc:
ORA-38701: 闂?洖鏁版嵁搴撴棩蹇?7 搴忓垪 43 綰跨▼ 1: "C:\ORACLE\PRODUCT\10.2.0\FLASH_BACK\WWL\FLASHBACK\O1_MF_7T7O9TKT_.FLB"
ORA-27041: 鏃犳硶鎵撳紑鏂囦歡
OSD-04002: unable to open file
O/S-Error: (OS 3) 系統找不到指定的路徑。
解決辦法:
因為刪除了flashback檔案,在資料庫open的時候turn on flashback database失敗,故將database flashback屬性先置為off將資料庫Open,再重新trun on flashback 後資料庫即可開啟.
過程如下:
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2066080 bytes
Variable Size 419432800 bytes
Database Buffers 1174405120 bytes
Redo Buffers 14708736 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database
臨時關閉flashbak 啟動資料庫。
SQL> alter database flashback off;
Database altered.
SQL> alter database open;
Database altered.
再次開啟flashbak後啟動資料庫即可。
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2066080 bytes
Variable Size 419432800 bytes
Database Buffers 1174405120 bytes
Redo Buffers 14708736 bytes
Database mounted.
SQL> alter database flashback on;
Database altered.
SQL> alter database open;
Database altered.
SQL>
同時也可參考metalink文章:Cannot Start Database ORA-38760 [ID 274569.1]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-740175/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-38760: This database instance failed to turn on flashback databaseDatabaseAI
- ORA-38760: This database instance failed to turn on flashback database 第三篇DatabaseAI
- [Flashback]ORA-38760錯誤解決
- 使用flashback database 特性時遇到的錯誤Database
- Flashback DatabaseDatabase
- 【DataGuarad】ORA-1153 trying to turn on Flashback for Physical Standby DatabaseDatabase
- [20210722]ORA-38760與flashback database.txtDatabase
- flashback database 方法Database
- 配置Flashback DatabaseDatabase
- Oracle database instanceOracleDatabase
- The Instance and the Database (285)Database
- flashback技術之---flashback databaseDatabase
- 關於flashback databaseDatabase
- How to enable the flashback database:Database
- 測試flashback databaseDatabase
- flashback database測試Database
- duplicate standby database 報ORA-05507錯誤解決方法Database
- flashback系列文章三(flashback database)Database
- 理解Database和InstanceDatabase
- Oracle10g Flashback database功能恢復使用者錯誤(zt)OracleDatabase
- 使用Oracle10g Flashback database功能恢復使用者錯誤OracleDatabase
- 啟用flashback database 功能Database
- Impact of Database Recovery and Flashback Database on the TDE Wallet_1327519.1Database
- oracle flashback特性(3.2)--Flashback Database操作示例OracleDatabase
- flashback總結一之Flashback_DatabaseDatabase
- flashback database 恢復誤刪除的表空間。Database
- 3.2.1 Mounting a Database to an InstanceDatabase
- Overview of Instance and Database Startup (289)ViewDatabase
- opensips建立資料庫時報database engine not specified錯誤的解決資料庫Database
- 應用oracle flashback--Flashback Database介紹OracleDatabase
- oracle 10g flashback databaseOracle 10gDatabase
- flashback drop/query/table/database/archiveDatabaseHive
- flashback database 結合 data guardDatabase
- Oracle 閃回特性(FLASHBACK DATABASE)OracleDatabase
- 10.2 flashback database 測試!Database
- database和instance的區別Database
- Oracle DataGuard Standby database ID mismatch錯誤OracleDatabase
- [Flashback]Flashback Database閃回資料庫實驗Database資料庫