oracle的闪回特性2（The flashback characteristics of Oracle 2）.docVIP

oracle的闪回特性2（The flashback characteristics of Oracle 2） 1, the user has the right to execute the dbms_flashback package! 2, the flashback query must be set up automatically rollback segment management, parameter setting of UNDO_MANAGEMENT=AUTO, the parameters of init.ora UNDO_RETENTION=n, the biggest decision to move the larger flashback, we need more space Undo. Flashback query operation instance Oracle 9i Look at the process analysis of Delete and Commit operations in Oracle Example: Oracle 9is Flashback Query operation. (1) create a flashback query user SQL, create, user, test, identified, by, test; SQL, grant, connect, resource, to, test; SQL, grant, execute, on, dbms_flashback, to, test; SQL connect test/test; (2) create a test table and insert a test record SQL, create, table, test (ID, number (3)); SQL, insert, into, test, values (1); SQL, insert, into, test, values (2); SQL commit; Note: wait 5 minutes before performing step 3 or step 4. (3) delete records SQL, delete, from, test, where, id=1; SQL commit; By doing so, we inserted two records and deleted one of them. In the following operation, we will find the deleted records through flashback query (4) (flashback query by timestamp and SCN query) SQL select * from, test, as, of, timestamp, sysdate - 5/1440; ID ---- One Two or SQL select * from test as of SCN 8173800; ID ---- One Two We can see that although the delete record and submit, but through flashback operations, can still query to delete the two records. It is important to note that Oracle records SCN to SMON_SCN_TIME every 5 minutes, and records the mapping of SCN and corresponding time. If the operating time of the original flashback insert recorded in 5 minutes, the query may not record the time based on the time point of flashback, because based on query is actually transformed into a recent SCN, then began to recover from this SCN. Therefore, if you need a precise query can be used to query SCN flashback based on accurate flashback need recover