:

ORA-38792: encountered unknown flashback record

I was attempting to flashback my test database after having created the guaranteed flashback restore point in Oracle version 10g, and subsequently upgrading the DB to 11g.

SQL> flashback database to restore point PRE_CHANGE_DB;
flashback database to restore point PRE_CHANGE_DB
*
ERROR at line 1:
ORA-38792: encountered unknown flashback record from release 11.0.0.0.0

According to the website below, this is because there is both 10g and 11g flashback information in the same log file and when the log is trying to be read there is a mismatch:

http://arjunraja.wordpress.com/2010/07/02/using-flashback-database-to-rollback-from-11g-to-10g/

Perhaps you are coming across another error, ORA-38785: Media recovery must be enabled for guaranteed restore point, which I have also written an article on.

Like it, share it...

Category: Flashback


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *