ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 手工删除flashback log引发的ORA-38760

手工删除flashback log引发的ORA-38760

原创 Linux操作系统 作者:myownstars 时间:2011-05-11 13:23:11 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3164480