Hi guys
I unknowingly deleted all the files from 'fra' directory where ’flashback’ folder was there due to space issues. Now am facing the error.
This is my practicing database.
SQL> startup
ORACLE instance started.
Total System Global Area 608174080 bytes
Fixed Size 1268920 bytes
Variable Size 184550216 bytes
Database Buffers 419430400 bytes
Redo Buffers 2924544 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database
SQL> alter database flashback off;
Database altered.
SQL>SHUT IMMEDIATE;
SQL>STARTUP MOUNT
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
RESTORE POINT ONLY
Am not being able to turn flashback OFF.
SQL> select * from v$restore_point;
select * from v$restore_point
*
ERROR at line 1:
ORA-38701: Flashback database log 1 seq 1 thread 1:
"/u01/fra/PROD/flashback/o1_mf_c1l5n3lq_.flb"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
RESTORE POINT ONLY
I also tried creating a restore point and flashback it.
SQL> create restore point rspt1 guarantee flashback database;
Restore point created.
SQL>select * from v$restore_point;
select * from v$restore_point
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [krfg_get_keepseq_2], [1], [0], [0],
[0], [0], [0], [0]
SQL> flashback database to restore point rspt1;
flashback database to restore point rspt1
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
Please help me in this regard.
Alert Log File :
...
...
...
Successful mount of redo thread 1, with mount id 305866694
Sun Oct 25 10:13:30 2015
Allocated 3981204 bytes in shared pool for flashback generation buffer
Starting background process RVWR
RVWR started with pid=16, OS id=15486
Sun Oct 25 10:13:30 2015
Errors in file /u01/oracle/product/10.2.0/db_1/admin/prod/bdump/prod_rvwr_15486.trc:
ORA-38701: Flashback database log 11 seq 11 thread 1: "/u01/fra/PROD/flashback/o1_mf_c2oqypb0_.flb"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Sun Oct 25 10:13:30 2015
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sun Oct 25 10:13:30 2015
ALTER DATABASE OPEN
ORA-38760 signalled during: ALTER DATABASE OPEN...
Trace File :
...
...
...
*** SERVICE NAME:() 2015-10-25 10:13:30.087
*** SESSION ID:(156.1) 2015-10-25 10:13:30.087
ORA-38701: Flashback database log 11 seq 11 thread 1: "/u01/fra/PROD/flashback/o1_mf_c2oqypb0_.flb"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
- Thanks.