:

RSSFlashback

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 […]

Continue Reading

ORA-38701: Flashback database log, ORA-27070: async read/write failed

The Problem I had created a guaranteed flashback restore point in my 11g (11.2.0.2 base release) database and I was running in some updates which were very intensive in terms of I/O resource. I should point out that this is on a Windows Server 2003 R2 OS. I noticed that there were disk queues showing […]

Continue Reading

ORA-38785: Media recovery must be enabled for guaranteed restore point

The Problem You want to use the Flashback Database feature and are trying to create a guaranteed restore point before you carry out any work. As you attempt to create the guarantee restore point you get the ORA-38785: Media recovery must be enabled for guaranteed restore point error message. The Cause The database is not […]

Continue Reading

ORA-16433: The database must be opened in read/write mode

ORA-16433: The database must be opened in read/write mode

You’re here because you’re getting the ORA-16433: The database must be opened in read/write mode error message. Below you will find the solution… But first, here is how I got the error. The reason I’m writing this is so that it will help you understand the ORA 16433 error message a little better as it could […]

Continue Reading