首页 → 数据库技术
背景：
阅读新闻
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 错误解决过程
0
redhat linux 6.4 运行 runcluvfy 错误一例
oracle 11g rac 修改归档模式
相关资讯 ora-38760
图片资讯
本文评论查看全部评论 (0)
评论声明
最新资讯
本周热门