SOLVED

ORA-38760: This Database Instance Failed To Turn On Flashback Database

Asked by OracleDba••14 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
ORA-38760: This Database Instance Failed To Turn On Flashback Database

PROBLEM:

While starting the database, we got below error.

SQL> startup

ORACLE instance started.

Total System Global Area 1.2549E+10 bytes

Fixed Size 12155024 bytes

Variable Size 6744442736 bytes

Database Buffers 5771362304 bytes

Redo Buffers 21397504 bytes

Database mounted.

ORA-38760: This database instance failed to turn on flashback database.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
1. Check the alert log:

Errors in file /oracle/app/oracle/diag/rdbms/db12cr2/DB12CR2/trace/DB12CR2_rvwr_2776.trc:

ORA-38701: Flashback database log 1 seq 1 thread 1: "/oracle/app/oracle/product/12.2.0/dbhome_1/dbs/arch/FRA/DB12CR2/flashback/o1_mf_djfp4fjd_.flb"

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 7

2017-05-01T09:43:24.075852+03:00

WARNING: Cannot open the flashback thread for this instance due to the above error.

WARNING: Flashback thread open failed - to resolve this, either correct the reported error or turn off database flashback.

2017-05-01T09:43:24.076337+03:00

Database mounted in Exclusive Mode

Lost write protection disabled

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

Completed: ALTER DATABASE MOUNT

2. Check the flashback_mode of the database.

SQL> select name,flashback_on from v$database;

NAME FLASHBACK_ON

--------- ------------------

DBATEST YES ----- > FLASHBACK IS ENABLED...

From the alert log, it is clear that flashback mode is enabled in the database and someone has mistakenly deleted flashback log physically.

So, to fix this issue, the only solution is to disable the flashback mode and open the database.

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

DB12CR2 MOUNTED

SQL> alter database flashback off;

Database altered.

SQL> alter database open;

Database altered.

Hope it Helps!
OracleDba•

Post Your Solution