Thursday, 2 February 2012

ORA-38760: This database instance failed to turn on flashback database


ORA-38760: This database instance failed to turn on flashback database
As per Oracle :


Error: ORA-38760 


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.


Solution A:


To Enable flashback:


1.Shutdown the database either in immediate or normal mode.


2.Mount the database.


3.Enable flashback. 


SQL>Alter database flashback on;


4.Open the database.


Sometimes even after solution A you are still getting errors:


SQL> startup mount;
ORACLE instance started.


Total System Global Area 1.4798E+10 bytes
Fixed Size 2046472 bytes
Variable Size 671090168 bytes
Database Buffers 1.4110E+10 bytes
Redo Buffers 14729216 bytes
Database mounted.
SQL> alter database flashback off;


Database altered.


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database


SQL> 


Then you should apply solution B.

Solution B:

1. Startup mount.


2. Check db_recovery_file_dest parameter and ensure this directory exists.


3. Check restore points:


select NAME,SCN,GUARANTEE_FLASHBACK_DATABASE,DATABASE_INCARNATION# 
from v$restore_point;


4. Drop restore point:


drop restore point ;


5. alter database flashback off;


6. Shutdown immediate;


7. Startup

1 comment:

Piyush Mishra said...

thanks man----its help me