Saturday, January 29, 2011

This database instance failed to turn on flashback database

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/29/2011 00:40:41
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashback database


Solution:



select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

select FLASHBACK_ON from v$database;

FLASHBACK_ON
------------------
YES

SQL> alter database flashback off;


and go!

No comments:

Post a Comment