太懒
分类: Oracle
2013-07-11 11:08:23
修改 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]$