手工删除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 Size                  2233336 bytes

Variable Size             822086664 bytes

Database Buffers         3439329280 bytes

Redo Buffers               12132352 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 Size                  2101808 bytes

Variable Size             805309904 bytes

Database Buffers         3472883712 bytes

Redo Buffers               14671872 bytes

Database mounted.

SQL> drop restore point before_upgrade;

 

Restore point dropped.

 

SQL> alter databbase open;

alter databbase open

      *

ERROR at line 1:

ORA-00940: invalid ALTER command

 

 

SQL> alter database open;

alter database open

*

ERROR at line 1:

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

 

 

SQL> alter database flashback off;

 

Database altered.

 

SQL> alter database open;

 

Database altered.

 

SQL> exit

可以看到在关闭flashback database功能后 可以正常启动

查看alert log

ALTER DATABASE   MOUNT

Wed May 11 11:44:29 CST 2011

Setting recovery target incarnation to 4

Wed May 11 11:44:29 CST 2011

Successful mount of redo thread 1, with mount id 1278659993

Wed May 11 11:44:29 CST 2011

Allocated 15937344 bytes in shared pool for flashback generation buffer

Starting background process RVWR

RVWR started with pid=14, OS id=27276

Wed May 11 11:44:29 CST 2011

Errors in file /data/oracle/admin/orcl/bdump/orcl_rvwr_27276.trc:

ORA-38701: Flashback database log 177 seq 176 thread 1: "/data/oracle/flashback/STD01/flashback/o1_mf_6wmym550_.flb"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

Wed May 11 11:44:29 CST 2011

Database mounted in Exclusive Mode

Completed: ALTER DATABASE   MOUNT

Guaranteed restore point BEFORE_UPGRADE dropped

Wed May 11 11:44:52 CST 2011

alter database open

Wed May 11 11:44:52 CST 2011

ORA-38760 signalled during: alter database open...

Wed May 11 11:45:00 CST 2011

alter database flashback off

Wed May 11 11:45:00 CST 2011

Stopping background process RVWR

Deleted Oracle managed file /data/oracle/flashback/STD01/flashback/o1_mf_6wklhjqz_.flb

Deleted Oracle managed file /data/oracle/flashback/STD01/flashback/o1_mf_6wkshm05_.flb

Deleted Oracle managed file /data/oracle/flashback/STD01/flashback/o1_mf_6wksql8m_.flb

Deleted Oracle managed file /data/oracle/flashback/STD01/flashback/o1_mf_6wksqvcj_.flb

Deleted Oracle managed file /data/oracle/flashback/STD01/flashback/o1_mf_6wksr1fx_.flb

在数据库open阶段，rvwr进程需要加载闪回日志文件，由于找不到所以无法正常启动，而在关闭flashback后,rvwr进程被关闭，相应的闪回文件也被删除。

原因: 刚刚看到闪回日志占用空间太多，直接统计OS命令rm删除，导致启动时候报错

解决方案:目前oracle还没有针对flashlog的操作，而falshlog满了之后会自动覆盖之前的内容；手工清除办法就是alter database flashback off;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15480802/viewspace-694985/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15480802/viewspace-694985/