诊断:ORA-38760: This database instance failed to turn on flashback database
2024-09-01 23:45:12
$ 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.
Solution A:
To Enable flashback:
1.Shutdown the database either in immediate or normal mode.
2.Mount the database.
3.Enable flashback.
SQL>Alter database flashback on;
4.Open the database.
Sometimes even after solution A you are still getting errors:
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.4798E+10 bytes
Fixed Size 2046472 bytes
Variable Size 671090168 bytes
Database Buffers 1.4110E+10 bytes
Redo Buffers 14729216 bytes
Database mounted.
SQL> alter database flashback off;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
SQL>
此时可以尝试方案B。
Solution B:
1. Startup mount.
2. Check db_recovery_file_dest parameter and ensure this directory exists.
3. Check restore points:
select NAME,SCN,GUARANTEE_FLASHBACK_DATABASE,DATABASE_INCARNATION# from v$restore_point;
4. Drop restore point:
drop restore point <restore point>;
5. alter database flashback off;
6. Shutdown immediate;
7. Startup
最新文章
- Lind.DDD敏捷领域驱动框架~Lind.DDD各层介绍
- oracle导入导出数据
- Android NestedScrolling与分发机制 二
- [译]JavaScript:将字符串两边的双引号转换成单引号
- 【Git】标签管理
- 导出word使用模版
- Ruby零星笔记
- Python数据
- Tomcat 404
- Linux之磁盘管理
- VC++编程中获取系统时间
- 学习CentOS7笔记(一)
- Weex详解:灵活的移动端高性能动态化方案
- An NIO.2 primer--reference
- 小学生玩ACM----深搜
- 简单的表单验证(js、jquery)
- 实现浏览器遗漏的原件 jQuery.selectCheckbox
- C++源码的调用图生成
- java大数判断相等
- python之OpenCv(四)---人脸识别
热门文章
- http ssl
- Node.js+Express搭建博客系统基本环境安装
- poj 2762(tarjan缩点+判断是否是单链)
- 4. extjs中form中的frame:true表示什么
- hdu4292 Food 最大流模板题
- P1606 [USACO07FEB]荷叶塘Lilypad Pond(最短路计数)
- Android项目模块化遇到的问题
- hdu1166 敌兵布阵(树状数组)
- keystore找回密码
- Ajax学习笔记之一----------第一个Ajax Demo[转载]