你好,游客 登录 注册 搜索
背景:
阅读新闻

ORA-38760错误解决

[日期:2013-07-22] 来源:Linux社区  作者:Linux [字体: ]

修改 db_recovery_file_dest 导致 flashback off

启动的时候报错

[Oracle@node3 dbs]$ srvctl start instance -d momorac -i momo1

PRCR-1013 : Failed to start resource ora.momorac.db

PRCR-1064 : Failed to start resource ora.momorac.db on node node1

CRS-5017: The resource action "ora.momorac.db start" encountered the following e                                                                                                rror:

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

. For details refer to "(:CLSN00107:)" in "/u01/app/grid/11.2.3/log/node1/agent/                                                                                                crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.momorac.db' on 'node1' failed

[oracle@node3 dbs]$

SQL> startup

ORACLE instance started.

Total System Global Area  297119744 bytes

Fixed Size                  1344540 bytes

Variable Size            163580900 bytes

Database Buffers          125829120 bytes

Redo Buffers                6365184 bytes

Database mounted.

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

SQL>

[oracle@node3 dbs]$ oerr ora 38760

38760, 00000, "This database instance failed to turn on flashback database"

// *Cause: Database flashback is on but this instance failed to

//        start generating flashback data. Look in alert log for more

//        specific errors.

// *Action: Correct the error or turn off database flashback.

[oracle@node3 dbs]$

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  297119744 bytes

Fixed Size                  1344540 bytes

Variable Size            163580900 bytes

Database Buffers          125829120 bytes

Redo Buffers                6365184 bytes

Database mounted.

SQL> alter database flashback off;

Database altered.

SQL> alter database flashback on;

Database altered.

SQL>

 

日志输出:

SUCCESS: diskgroup FRA was mounted
Errors in file /u01/app/oracle/diag/rdbms/momorac/momo1/trace/momo1_rvwr_7916.tr                                                                                                c:
ORA-38701: Flashback database log 25 seq 7 thread 1: "+FRA/momorac/flashback/log                                                                                                _25.291.819172823"
ORA-17503: ksfdopn:2 Failed to open file +FRA/momorac/flashback/log_25.291.81917                                                                                                2823
ORA-15012: ASM file '+FRA/momorac/flashback/log_25.291.819172823' does not exist
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Completed: ALTER DATABASE  MOUNT
Thu Jul 11 10:49:30 2013
alter database flashback off
Deleted Oracle managed file +FRA/momorac/flashback/log_4.280.819270229
Deleted Oracle managed file +FRA/momorac/flashback/log_6.278.819910985
Deleted Oracle managed file +FRA/momorac/flashback/log_8.493.819159477
Deleted Oracle managed file +FRA/momorac/flashback/log_9.439.818442041
Deleted Oracle managed file +FRA/momorac/flashback/log_25.291.819172823
Deleted Oracle managed file +FRA/momorac/flashback/log_48.320.819090057
Flashback Database Disabled
Completed: alter database flashback off
Thu Jul 11 10:49:48 2013
alter database flashback on
Thu Jul 11 10:49:51 2013
RVWR started with pid=34, OS id=7938
SUCCESS: diskgroup FRA1 was mounted
Thu Jul 11 10:50:01 2013
NOTE: dependency between database momorac and diskgroup resource ora.FRA1.dg is                                                                                                  established
Thu Jul 11 10:50:08 2013
Flashback Database Enabled at SCN 22553715
Completed: alter database flashback on

重启

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL>

[oracle@node3 dbs]$ srvctl start instance -d momorac -i momo1

[oracle@node3 dbs]$ srvctl status database -d momorac

Instance momo1 is running on node node1

Instance momo2 is not running on node node2

Instance momo3 is not running on node node3

[oracle@node3 dbs]$

[oracle@node3 dbs]$ srvctl start instance -d momorac -i momo2,momo3

[oracle@node3 dbs]$ srvctl status database -d momorac

Instance momo1 is running on node node1

Instance momo2 is running on node node2

Instance momo3 is running on node node3

[oracle@node3 dbs]$

相关阅读:

ORA-38760: This database instance failed to turn on flashback database 错误解决过程 http://www.linuxidc.com/Linux/2012-08/67515.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux
相关资讯       ORA-38760 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款