Only objects dropped while the recycle bin is disabled cannot be recovered.
The Flashback Database Command
The flashback database command returns the database to a past time or SCN, providing a fast
alternative to performing incomplete database recovery. Following a flashback database operation,
in order to have write access to the flashed-back database, you must reopen it with an alter
database open resetlogs command. You must have the SYSDBA system privilege in order to use
the flashback database command.
NOTE
The database must have been put in FLASHBACK mode with an alter
database flashback on command. The database must be mounted in
exclusive mode but not open when that command is executed.
The syntax for the flashback database command is as follows:
flashback [standby] database [database]
{ to {scn | timestamp} expr
| to before {scn | timestamp } expr
}
You can use either the to scn or to timestamp clause to set the point to which the entire
database should be flashed back. You can flash back to before a critical point (such as a
transaction that produced an unintended consequence for multiple tables). Use the ORA_
ROWSCN pseudo-column to see the SCNs of the most recent row transactions.
If you have not already done so, you will need to shut down your database and enable
flashback during the startup process using this sequence of commands:
startup mount exclusive;
alter database archivelog;
alter database flashback on;
alter database open;
NOTE
You must enable media recovery via the alter database archivelog
command prior to executing the alter database flashback on
command.
Pages:
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754