This forum is currently locked. You can't register or post questions at this time. (read more)

track changed blocks

All posts relating to Oracle database administration.

Moderator: Tim...

vivek_k47
Member
Posts: 27
Joined: Sun Aug 05, 2012 11:45 am

track changed blocks

Postby vivek_k47 » Sat Feb 09, 2013 1:51 pm

Hi,
Is there a way to track the changed blocks of a table?
Thanks
Vivek

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: track changed blocks

Postby Tim... » Sat Feb 09, 2013 2:47 pm

Hi.

It depends what for. Oracle has something called block change tracking, it uses to improve the speed of incremental backups.

http://www.oracle-base.com/articles/10g ... al_backups

That information is not visualized to you though.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

vivek_k47
Member
Posts: 27
Joined: Sun Aug 05, 2012 11:45 am

Re: track changed blocks

Postby vivek_k47 » Sat Feb 09, 2013 5:53 pm

Not in RMAN..

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: track changed blocks

Postby Tim... » Sat Feb 09, 2013 8:23 pm

Hi.

Then I don't think what you want is possible, short of learning how to interpret the contents of the block change tracking file.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 7 guests

cron