ORA-38760: This database instance failed to turn on flashback database 第三篇
ORA-38760: This database instance failed to turn on flashback database 第三篇
第一篇
第二篇
問題現象:
在資料庫alert告警日誌中看見如下資訊:
-
Completed: ALTER DATABASE MOUNT
-
Wed Nov 19 04:57:28 2014
-
alter database open
-
Errors in file /DBSoft/diag/rdbms/woo/woo/trace/woo_ora_5936.trc:
-
ORA-38760: This database instance failed to turn on flashback database
- ORA-38760 signalled during: alter database open...
問題分析:
該錯誤透過檢視Metalink 後得知是因為Flash back資訊不完整導致。
-
[oracle@db01 ~]$ oerr or 38760
oerr: Unknown facility 'or'
[oracle@db01 ~]$ oerr ora 38760
38760, 00000, "This database instance failed to turn on flashback database"
// *Cause: Database flashback is on but this instance failed to
// start generating flashback data. Look in alert log for more
// specific errors.
// *Action: Correct the error or turn off database flashback.
這個時候,我想需要去檢視下閃回的狀態的了
-
SQL> select flashback_on from v$database;
-
FLASHBACK_ON
-
------------------
-
RESTORE POINT ONLY
-
-
再接著檢視恢復檢查點:
-
SQL> select * from v$restore_point;
-
-
SCN DATABASE_INCARNATION# GUA STORAGE_SIZE TIME RESTORE_POINT_TIME PRE NAME
-
---------- --------------------- --- ------------ ----------------------------------- ------------------------- --- --------------------
- 1187867 2 YES 3056812032 04-OCT-14 02.41.43.000000000 AM YES MACLEAN_ROLLBACK
-
1、刪除恢復點MACLEAN_ROLLBACK
-
SQL> drop restore point MACLEAN_ROLLBACK;
-
-
Restore point dropped.
-
-
SQL> select * from v$restore_point;
-
-
no rows selected
-
-
2、啟動資料庫,並檢視flashback狀態
-
SQL> alter database open;
-
-
Database altered.
-
-
SQL> select flashback_on from v$database;
-
-
FLASHBACK_ON
-
------------------
- NO
這個問題時控制檔案與閃回去日誌檔案中所記錄的資訊不一致導致的。因此,冷備份的時候,最好將閃回去一併進行備份。
當然該問題還可以透過使用冷備分加上對於閃回去的備份,可以直接啟動資料庫例項。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8494287/viewspace-1405567/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-38760: This database instance failed to turn on flashback databaseDatabaseAI
- ORA-38760: This database instance failed to turn on flashback database 錯誤解決DatabaseAI
- 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
- flashback系列文章三(flashback database)Database
- 理解Database和InstanceDatabase
- 啟用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
- 3.2.1 Mounting a Database to an InstanceDatabase
- Overview of Instance and Database Startup (289)ViewDatabase
- 應用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
- [Flashback]Flashback Database閃回資料庫實驗Database資料庫
- Flashback database與flashback table使用條件區別Database
- 【徵文】應用oracle flashback(3.2)--Flashback Database操作示例OracleDatabase
- Flashback Database 閃回資料庫Database資料庫
- flashback database的一點總結Database
- 【Flashback】Flashback Database閃回資料庫功能實驗Database資料庫
- flashback database如何選擇需要應用的flashback logDatabase
- 全面學習oracle flashback特性(3.2)--Flashback Database操作示例OracleDatabase
- 【Flashback】啟用Flashback Database閃回資料庫功能Database資料庫