First page Back Continue Last page Graphics

Flashback Database: Example

Notes:

This is a simple example of using flashback database. Here, I flashback to an SCN which I might have gotten from a flashback version query (or the logminer utility). The database is opened in read-only mode, at which time tables can be queried. If you decide you would like to flashback to a different point in time, shutdown and mount the database, then use flashback database again. When the database is flashed back to the desired point in time, open the database with the RESETLOGS option.
Supplemental Notes
Offline datafiles are not flashed back. However, if there are referential integrity issues because you have not flashed back one or more datafiles, you’ll receive the error:
ORA-01152: file 4 was not restored from a sufficiently old backup
So, essentially, you cannot do this – you will have to either recover or drop the file.
Finally, note that I would normally recommend a full backup be taken after the OPEN RESETLOGS operation. However, Oracle 10g provides a seamless recovery across RESETLOGS so this is not as essential as it used to be. Refer to this lesson for more information.