Jul 11: Oracle 11g - Total Recall

I suppose most readers will be aware that Oracle held a big launch for 11g yesterday, including the release of various technical docs at OTN. I've only managed a quick scan because I'm up to my eyeballs in some internal ASH/AWR training I'm giving later today, but what particularly interested me was this paragraph in the New Features Overview.

“Time Travel” with Oracle Flashback Data Archive
Oracle Database 11g also features Total Recall with Oracle Flashback Data Archive, which enables you to query data in selected tables “as of” earlier times in the past, thereby providing an easy, practical way to add a time dimension to your data for change tracking, ILM, auditing, and compliance. Oracle Flashback Data Archive provides automatic and efficient storage of “change” data to enable fast query access to old versions of the data.

The DBA can set retention policies to automatically purge data when your system reaches specified age thresholds

I'm not sure how much attention that might get because it sounds like just another minor Flashback feature, but I suspect it's really Rob Squire's stuff that I talked about here. Definitely one for further investigation.
Posted by Doug Burns Comments: (5) Trackbacks: (2)
Defined tags for this entry:
Related entries by tags:
Resource Manager and 11g
Parallel Query and 11g - Part 2
Parallel Query and 11g

Trackbacks
Trackback specific URI for this entry

Manly Men Only Deploy Oracle with Fibre Channel - Part VI. Introducing Oracle11g Direct NFS!
Since December 2006, I’ve been testing Oracle11g NAS capabilities with Oracle’s revolutionary Direct NFS feature. This is a fantastic feature. Let me explain. As I’ve laboriously pointed out in the Manly Man Series, NFS makes life much simpler in...
Weblog: Kevin Closson's Oracle Blog: Platform, Storage & Clustering Topics Related t
Tracked: Jul 12, 13:29
Does Anyone Know When 11g Will Be Released?
Sorry, I shouldn't be so sarcastic, but try to show some sympathy for my schedule.Thursday 9th August 22:30 BST - Got to bed, unusually early.Friday 10th 06:00 BST - Wake up, check Netvibes and noticed several 11g release blogs, including Eddie's initia
Weblog: Doug's Oracle Blog
Tracked: Aug 11, 10:06

Comments
Display comments as (Linear | Threaded)

#1 - Yuri van Buren said:
2007-07-12 15:00 - (Reply)

Doug here is a small example of Total Recall.

CREATE FLASHBACK ARCHIVE DEFAULT fla1 TABLESPACE testarea1
QUOTA 10G RETENTION 1 YEAR;

Flashback archive created.

Now set a table in the flashback arhive mode!

alter table hr.employees flashback archive fla1;

Table altered.

update hr.employees set salary = 5000 where salary = 4000;

1 row updated.

--> 192 5000

Prompt now see If I can get my data back!

SELECT employee_id, salary from hr.employees AS OF
TIMESTAMP TO_TIMESTAMP ('2007-06-19 20:28:00', 'YYYY-MM-DD HH24:MI:SS');

..
==>Cool 192 4000
..

So looks like flashback gets a new marketing name "Total Recal"
You data only ages out after your specified retention time.

#1.1 - Doug Burns said:
2007-07-15 08:50 - (Reply)

Thanks, Yuri.

I'll need to have a play around with it. I have a feeing that this feature might be improved further in coming versions ;-)

#2 - Alex Gorbachev said:
2007-07-25 17:42 - (Reply)

"Total Recall" in the title - interesting, but I used the same in my post next day and reading yours only now...

My fault - I wasn't paying much attention to my Google Reader last days and once clicked on "mark all as read" and now suffer consequences.

#2.1 - Doug Burns said:
2007-07-25 19:59 - (Reply)

Ha, I read your blog and didn't even notice that!

#2.2 - koert 2007-07-26 11:10 - (Reply)

>"Total Recall" in the title - interesting, but I used the same in my post next day and reading yours only now...

You mean ... that brilliant post that should be voted as 'Blogentry nec plus ultra of the year' ? ;-)


Add Comment

Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
BBCode format allowed