ORA-38760错误解决

ORA-38760错误解决，修改 db_recovery_file_dest 导致 flashback off

首页 → 数据库技术

背景：

阅读新闻

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 错误解决过程