Inside Oracle dbms_flashback
The System Change Number is captured from
the packaged function
dbms_flashback.get_system_change_number.
Get the current SCN at the source database.
Next, use the Oracle dbms_flashback package to get
the current SCN. This value will be used
during instantiation at the destination
site, as well as by rman when duplicating
the database.
SET
SERVEROUTPUT ON
DECLARE
until_scn NUMBER;
BEGIN
until_scn:=
DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER;
Before
Oracle dbms_flashback Query functionality can be used by
ordinary users, some actions are required
from the database administrators:
Alter system set UNDO_MANAGEMENT=AUTO;
Alter system set UNDO_RETENTION=86400;
Grant execute on DBMS_FLASHBACK to username;
Oracle
dbms_flashback Query is enabled and disabled
using the DBMS_FLASHBACK package. The point
in time of the flashback can be specified
using the SCN or the actual time.
EXECUTE dbms_Flashback.Enable_At_Time('28-AUG-02
11:00:00');
|
|
|
