Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!news.glorb.com!postnews1.google.com!not-for-mail From: orazon@dbnet.co.il (Ofer Razon) Newsgroups: comp.databases.oracle.server Subject: Re: RMAN internal`s mechanism Date: 3 Mar 2004 09:34:09 -0800 Organization: http://groups.google.com Lines: 34 Message-ID: <74c5bf11.0403030934.4bf11310@posting.google.com> References: <74c5bf11.0403030230.1464f170@posting.google.com> NNTP-Posting-Host: 192.118.10.10 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1078335249 32711 127.0.0.1 (3 Mar 2004 17:34:09 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 3 Mar 2004 17:34:09 +0000 (UTC) Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:256212 > Every block has a last change number - which is the SCN > at the last change plus a counter that goes from 1 to 254. > rman knows when the SCN when it last did a backup, reads > each block, and checks the last change number. > > > My goal is to use the same mechanism to find which blocks were changed > > since the last check. > > > > Possible - so long as you knew the SCN when rman started (or perhaps > when it started each file, or tablespace - that's a little detail that I'm > not > so sure on; the file would be the obvious choice). The last change SCN > is in a fixed location in the block, so you could write some 3GL code to > scan each file and pick it out from each block. I am curious to know why > you want to do this. Thanks. Do you know about any existing piece of code that scans the datafiles and process them? I`m trying to find a solution to synchronize two copies of a datafile : One is older than the other at about a week. The synchronization must be very effective and must do as less writes at the target as it can. My current solution is to open both of the files as binary files, go block by block (I set the block size) and compare the data. Only if the data read is different - I update the block at the target with the data from the source. The issue is that this solution must go and read both of the files. I`m looking for a way to make it work better.... Thanks, Ofer.