Ora-38760:this database instance failed to turn on flashback database

Issue

Ora-38760:thisdatabase instance failed to turn on flashback database Background

The flashback of the database is open, test Lengbei and restore

Sql> select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition release 11.2.0.3.0-64bit Production Pl/sql Release 11.2.0.3.0-production CORE 11.2.0.3.0 Production TNS for Linux:version 11.2.0.3.0-production Nlsrtl Version 11.2.0.3.0-production

Sql> select flashback_on from V$database; flashback_on ------------------ YES

Process Backup Script:

#!/bin/bash Sqlplus/as SYSDBA <<eof Shutdown immediate; Ho Cp/u01/app/oracle/oradata/orcl/control01.ctl/rmp/backup/controlfile/contril01.ctl Ho Cp/u01/app/oracle/fast_recovery_area/orcl/control02.ctl/rmp/backup/controlfile/control02.ctl Ho cp/u01/app/oracle/oradata/orcl/*.dbf/rmp/backup/datafile/ Ho cp/u01/app/oracle/oradata/orcl/*.log/rmp/backup/logfile/ Startup Exit EOF;

Recover

After the database operation for a period of time, recovery, restore the backed-up files to the appropriate directory, open the database, there is an error.

Sql> Startup ORACLE instance started. Total System Global area 1603411968 bytes Fixed Size 2228784 bytes Variable Size 973082064 bytes Database buffers 620756992 bytes Redo buffers 7344128 bytes Database mounted. Ora-38760:this database instance failed to turn on flashback database

Alter Log

Allocated 15937344 bytes in shared pool for flashback generation buffer Starti NG background Process RVWR Tue a 15:56:45 2016 RVWR started with pid=20, OS id=6507 Errors in fi LE/U01/APP/ORACLE/DIAG/RDBMS/ORCL/ORCL/TRACE/ORCL_RVWR_6507.TRC: Ora-38739:flashback log file is more recent than control file. Ora-38701:flashback database log 2 seq 2 thread 1: "/u01/app/oracle/fast_recovery_area/orcl/flashback/o1_mf_ C8MWPZ5J_.FLB Database mounted in Exclusive Mode Lost write protection disabled Completed:alter dat Abase Mount Tue the 15:56:52 2016 ALTER DATABASE open Errors in file/u01/app/oracle/diag/rdbms/or CL/ORCL/TRACE/ORCL_ORA_6472.TRC: Ora-38760:this database instance failed to turn on flashback database Ora -38760 signalled during:alter database open ...

Trace Log

Trace FILE/U01/APP/ORACLE/DIAG/RDBMS/ORCL/ORCL/TRACE/ORCL_RVWR_6507.TRC Oracle Database 11g Enterprise Edition release 11.2.0.3.0-64bit Production With the partitioning, OLAP, Data Mining and real application testing options Oracle_home =/u01/app/oracle/product/11.2.0/dbhome_1 System Name:linux Node name:orcl01 Release:2.6.32-358.el6.x86_64 Version: #1 SMP Fri Feb 00:31:26 UTC 2013 Machine:x86_64 Instance NAME:ORCL Redo thread mounted by this instance:1 Oracle Process Number:20 Unix process pid:6507, image:oracle@orcl01 (RVWR) 2016-01-05 15:56:45.248 Session ID: (5.3) 2016-01-05 15:56:45.248 CLIENT ID: () 2016-01-05 15:56:45.248 SERVICE NAME: () 2016-01-05 15:56:45.248 MODULE NAME: () 2016-01-05 15:56:45.248 ACTION NAME: () 2016-01-05 15:56:45.248 Ora-38739:flashback log file is more recent than control file. Ora-38701:flashback database log 2 seq 2 thread 1: "/u01/app/oracle/fast_recovery_area/orcl/flashback/o1_mf_c8mwpz5j_." FLB "

cause

[Oracle@orcl01 ~]$ 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 the database flashback. [Oracle@orcl01 ~]$ [Oracle@orcl01 ~]$ oerr ora 38739 38739, 00000, "Flashback log file is more recent than control file." *cause:the control File change sequence number in the flashback Database log file is greater than the number in the Control file. This is implies the wrong control file was being used. Note which repeatedly causing this error Can make it stop happening without correcting Problem. Every attempt to open the database would advance the Control file change sequence number until it is great enough. *action:flashback DATABASE can only is used with the current Control file. If It is not available, then a restore and an incomplete recovery must is performed instead. [Oracle@orcl01 ~]$ [Oracle@orcl01 ~]$ oerr ora 38701 38701, 00000, "Flashback database log%s seq%s thread%s: \%s\" " *cause:this message reports the filename for details of another. *action:other messages'll accompany this message. The associated Messages for the appropriate action to take.

Solution

Sql> ALTER DATABASE flashback off; Database altered. sql> ALTER DATABASE open; Database altered. sql> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. sql> startup Mount; ORACLE instance started. Total System Global area 1603411968 bytes Fixed Size 2228784 bytes Variable Size 973082064 bytes Database buffers 620756992 bytes Redo buffers 7344128 bytes Database mounted. Sql> ALTER DATABASE flashback on; Database altered. sql> ALTER DATABASE open; Database altered.