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]
[20170302]关于activate standby database [20170302]关于alter database activate standby database.txt --//这是很久以前但是关于alter database activate standby database的讨论: --//链接: http://www.
recover database until cancel和 recover database区别 简单的说 recover database until cancel用于不完全恢复,可以一步一步的跳也就是一个一个归档的应用,也可以AUTO全部应用,当然也可以在恢复完某个archivelog后cancel退出,但是他不会恢复 current logfile如果需要恢复current logfile需要自己指定。
prudentwoo 10g/11g OCP 11g OCM,ITPUB和CSDN专家及专家讲师;有着多年数据库从业经验,资深Oracle数据库专家,现就职于北京海量数据技术股份有限公司担任高级dba职务,为央视,银行,电信等各行业及企业提供过技术支持服务
相关文章
- neo4j备份数据错误:Database does not exist: graph.db,完美解决
- recover database using backup controlfile/until cancel
- database
- The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.
- 【Oracle】-【权限-ORA-04043】- ORA-04043: object "SYS"."V_$DATABASE" does not exist
- Spring 4 Jasper Report integration example with mysql database in eclipse
- MongoDB的Invalid credentials for database
- Physical Standby Database Failover
- 缓存方案 通过SqlDependency实现Cache和Database的同步
- iOS中 DataBase SQL数据库 UI_高级
- DRUPAL-PSA-CORE-2014-005 && CVE-2014-3704 Drupal 7.31 SQL Injection Vulnerability /includes/database/database.inc Analysis
- 7.1 Connecting to a MySql database from Python
- [Windows Azure] Windows Azure SQL Database library
- [odb-users] Create schema error (unknown database schema '')
- mysql主从复制错误:Last_SQL_Error: Error 'Duplicate entry '327' for key 'PRIMARY'' on query. Default database: 'xxx'. Query:
- Intellij Database配置全局数据源
- 异常message:There is no database named cloudera_manager_metastore_canary_test_db_hive_hivemetastore
- FAQ: How to Use AWR reports to Diagnose Database Performance Issues [ID 1359094.1]
- RMAN 'Duplicate From Active Database' Feature in 11G [ID 452868.1]