ORA-38760: This database instance failed to turn on flashback database
来源:互联网 发布:usb转232数据接口驱动 编辑:程序博客网 时间:2024/06/05 19:37
SYS@d3vip> startup
ORACLE instance started.
Total System Global Area 8589934592 bytes
Fixed Size 7663544 bytes
Variable Size 5335154760 bytes
Database Buffers 3221225472 bytes
Redo Buffers 25890816 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database
SYS@d3vip> alter database flashback off;
Database altered.
SYS@d3vip> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
redo log没有了,数据不一致啦
SYS@d3vip> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database flashback off;
SQL> alter database backup controlfile to trace noresetlogs;
SQL> shutdown immediate;
SQL>select * from v$diag_info;
查找trace位置,view alert.log
将生成的trace更名为 .sql
SQL> startup nomount
SQL>@trace_file.sql ---重建控制文件
SQL> recover database;
SQL> shutdown immediate;
SQL> startup; ------使用新的控制文件
ORACLE instance started.
Total System Global Area 8589934592 bytes
Fixed Size 7663544 bytes
Variable Size 5335154760 bytes
Database Buffers 3221225472 bytes
Redo Buffers 25890816 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database
SYS@d3vip> alter database flashback off;
Database altered.
SYS@d3vip> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
redo log没有了,数据不一致啦
SYS@d3vip> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database flashback off;
SQL> alter database backup controlfile to trace noresetlogs;
SQL> shutdown immediate;
SQL>select * from v$diag_info;
查找trace位置,view alert.log
将生成的trace更名为 .sql
SQL> startup nomount
SQL>@trace_file.sql ---重建控制文件
SQL> recover database;
SQL> shutdown immediate;
SQL> startup; ------使用新的控制文件
阅读全文
0 0
- 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
- 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
- ORA-38760: This database instance failed to turn on flashback database
- ORA-38760: This database instance failed to turn on flashback database
- OORA-38760: This database instance failed to turn on flashback database
- STARTUP Database failed ORA-38760 to turn on Flashback Database (Doc ID 1554596.1)
- ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
- ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
- ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38709: Recovery Area is not enabled.
- ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38709: Recovery Area is not enabled.
- Flashback Database!
- flashback database.
- Flashback Database
- Flashback Database
- List<Map>排序
- vi 移动光标
- vs2012打开提示加载失败(该项目需要用户输入)
- iframe根据内容自适应高度
- 信息熵
- ORA-38760: This database instance failed to turn on flashback database
- NC凭证接口
- PAT-A 1004. Counting Leaves (30)
- 创建ssk_key,A机器通过SSH连接到B机器
- idea前后端联调 更新后端jar包可能出现的问题和解决方法
- 7.springmvc与struts2不同
- opencv14-图像分割--超像素分割与形态学分割
- gcc 编译选项 及其 详解
- zigbee发送功率设置及发送距离过短解决方案