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; ------使用新的控制文件
ORA-38760: This database instance failed to turn on flashback database
最新推荐文章于 2021-04-09 14:16:18 发布