Shulou(Shulou.com)06/01 Report--

Simulated fault scenario

Delete all flashback logs and restart the database instance

1. Delete the flashback log

ASMCMD [+ datadg/orcl] > cd flashbackASMCMD [+ datadg/orcl/flashback] > lslog_1.377.964637895log_2.376.964637901log_3.374.964648865ASMCMD [+ datadg/orcl/flashback] > rm log_*ASMCMD [+ datadg/orcl/flashback] >

2. Start the database

SYS@orcl1 > startupORACLE instance started.Total System Global Area 1241513984 bytesFixed Size 2923872 bytesVariable Size 620757664 bytesDatabase Buffers 603979776 bytesRedo Buffers 13852672 bytesDatabase mounted.ORA-38760: This database instance failed to turn on flashback database3, log error SYS@orcl1 > RVWR started with pid=40 OS id=10323 Errors in file / u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_rvwr_10323.trc:ORA-38701: Flashback database log 2 seq 2 thread 1: "+ DATADG/ORCL/FLASHBACK/log_2.376.964637901" ORA-17503: ksfdopn:2 Failed to open file + DATADG/ORCL/FLASHBACK/log_2.376.964637901ORA-15012: ASM file'+ DATADG/ORCL/FLASHBACK/log_2.376.964637901' does not existDatabase mounted in Shared Mode (CLUSTER_DATABASE=TRUE) Lost write protection disabledCompleted: ALTER DATABASE MOUNTALTER DATABASE OPENErrors in file / u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_10324.trc:ORA-38760: This database instance failed to turn on flashback databaseORA-38760 signalled during: ALTER DATABASE OPEN...2018-01-06 07 This database instance failed to turn on flashback databaseORA-38760 signalled during 57 purl 34.698000 + 08:00Decreasing number of real time LMS from 1 to 0

4. Solution

SYS@orcl1 > SYS@orcl1 > alter database flashback off;Database altered.SYS@orcl1 > alter database open;Database altered.SYS@orcl1 > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SYS@orcl1 > startup mount;ORACLE instance started.Total System Global Area 1241513984 bytesFixed Size 2923872 bytesVariable Size 620757664 bytesDatabase Buffers 603979776 bytesRedo Buffers 13852672 bytesDatabase mounted.SYS@orcl1 > alter database flashback on;Database altered.SYS@orcl1 > alter database open;Database altered.SYS@orcl1 > select flashback_on from v$database FLASHBACK_ON-YESSYS@orcl1 >

5. Official document number

(document ID 274569.1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.