ORA-38760错误解决

修改 db_recovery_file_dest 导致 flashback off启动的时候报错[Oracle@node3 dbs]$ srvctl start instance -d momorac -i momo1PRCR-1013 : Failed to start resource ora.momorac.dbPRCR-1064 : Failed to start resource ora.momorac.db on node node1CRS-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> startupORACLE instance started.Total System Global Area 297119744 bytesFixed Size 1344540 bytesVariable Size 163580900 bytesDatabase Buffers 125829120 bytesRedo Buffers 6365184 bytesDatabase mounted.ORA-38760: This database instance failed to turn on flashback databaseSQL>[oracle@node3 dbs]$ oerr ora 3876038760, 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 immediateORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> startup mount;ORACLE instance started.Total System Global Area 297119744 bytesFixed Size 1344540 bytesVariable Size 163580900 bytesDatabase Buffers 125829120 bytesRedo Buffers 6365184 bytesDatabase 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 openDatabase dismounted.ORACLE instance shut down.SQL>[oracle@node3 dbs]$ srvctl start instance -d momorac -i momo1[oracle@node3 dbs]$ srvctl status database -d momoracInstance momo1 is running on node node1Instance momo2 is not running on node node2Instance 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 momoracInstance momo1 is running on node node1Instance momo2 is running on node node2Instance 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=12RedHat Linux 6.4 运行 runcluvfy 错误一例Oracle 11G RAC 修改归档模式相关资讯 ORA-38760

ORA-38760: This database （10/12/2014 12:13:58）

本文评论查看全部评论（0）

评论声明