oracle flashback清理,手工删除flashback log引发的ORA-38760

10g升级到11g

为了应对升级失败，需要做好回滚计划，比较快的就是开启flashback database

具体步骤

在10g的环境中

Startup mount

Alter database flashback on

Create restore point before_upgrade guarantee flashback database;

Shutdown immediate

然后转到11g环境

Startup upgrade

但是此步报错

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 4275781632 bytes

Fixed Size2233336 bytes

Variable Size822086664 bytes

Database Buffers3439329280 bytes

Redo Buffers12132352 bytes

Database mounted.

ORA-38760: This database instance failed to turn on flashback database

转到10g环境

SQL> startup mount

ORACLE instance started.

Total System Global Area 4294967296 bytes

Fixed Size2101808 bytes

Variable Size805309904 bytes

Database Buffers3472883712 bytes

Red