 |
|
Oracle Tips by Burleson |
Oracle 10g Disabling Flashback Database
Issue the following command to disable Flashback
Database:
SQL> ALTER
DATABASE FLASHBACK OFF;
You can also perform the same task in
Enterprise Manager:
Figure 12.2 Disabling Flashback Database in Enterprise Manager
Monitoring Flashback Database
The following displays a selection of the
Flashback Database logs:
SQL> select
begin_time, flashback_data,
2 db_data, redo_data, ESTIMATED_FLASHBACK_SIZE
3 from v$flashback_database_stat;
BEGIN_TIME
FLASHBACK_DATA DB_DATA REDO_DATA ESTIMATED_FLASHBACK_SIZE
-------------------- -------------- ---------- ----------
------------------------
Oct 08 2003
14:17:34 753664 5324800
970752
0
Oct 08 2003
13:17:32 1720320 4751360 3124224
21749760
Oct 08 2003
12:17:31 1802240 4833280 3168256
21774336
Oct 08 2003
11:17:28 1867776 4587520 3146752
21774336
Oct 08 2003
10:17:24 1835008 4800512 3115008
21749760
Oct 08 2003
09:17:22 1785856 4702208 3120128
21749760
Oct 08 2003
08:17:17 1703936 4571136 3102720
21749760
Oct 08 2003
07:17:14 2768896 5767168 3237888
21798912
Oct 08 2003
06:17:11 1753088 4636672 3142656
21479424
Oct 08 2003
04:47:09 2686976 7143424 4862976
21479424
Oct 08 2003
03:47:05 1703936 4685824 3145728
21479424
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
