Please read all of the directions
before using this program.
This tool is only available for special circumstances and will be
provided by IBM-Rational Technical Support.
show_restores.pl
is used to detect a stale restorereplica oplog as a potential cause of
slow syncreplica exports.
The tool runs the following command against each replica in
each VOB requested.
Note: 4294967295 is the
highest available oplog ID and is only used to indicate a
restorereplica operation
Once a restore operation has been completed the oplog should be removed
via the restore complete operation.
Due to some syncing patterns and the uniqueness of the oplog the
restorereplica oplog can get imported after the restore complete
leaving it in a stale state.
If a stale restorereplica oplog is found it can be removed by
scrubbing the oplogs or with a special remove_restores tool provided by
IBM-Rational
Caution: The tool does not
distinguish between a legitimate restorereplica oplog and a stale one
so
care must be used before proceeding with the removal of the oplog.
Restrictions:
Identities: No Special
ClearCase permissions are needed.
Location: This
program can be run from any client machine. It need not be run on the
VOB server.
Instructions:
Options and arguments
Default
:
scan
current VOB -long
returns related oplogs bypassing prompt -short
skips related oplogs, bypassing prompt VOB-tag
scan specified VOB -all
scan all VOBs in region -host
scan all VOBs on this host -host hostname
scan all VOBs on named host
If a restorereplica oplog is found you will be presented with the
following option: restorereplica
oplog found for replica <replica name>\@<vob
tag> Get related oplogs? [y]
Choosing Y will search for related ackrestore and restore complete oplogs.
Example:
>perl show_restores.pl \od-r2
MultiSite version 7.0.1 (Thu May 17 09:19:04 2007)
multitool
7.0.1.0 (Tue May 15 23:20:45 2007)
NIBIRU: ClearCase 7.0.1.0 (Windows NT 5.1 (build 2600) Service Pack 2
Pentium)
Checking rep-1@\od-r2 restorereplica oplog found for replica
rep-1@\od-r2 Get related oplogs? [y] y
318: op= restorereplica
replica_oid= d2a1259a.7a194c48.bcd1.6f:e6:ee:f4:1b:e2 (rep-1)
oplog_id= 4294967295
op_time= 25-Jul-07.19:33:04UTC create_time= 25-Jul-07.19:33:18UTC
event comment= "Restore propagation started on replica
New row is: rep-2=0 rep-3=0 rep-1=144"
data size= 88 data= 0xecdf00
------------
replica_oid= d2a1259a.7a194c48.bcd1.6f:e6:ee:f4:1b:e2 (rep-1)
replica_oid= e9eaae72.a61c4e09.b569.a5:04:d6:6c:84:47 (rep-2)
oplog id= 0
replica_oid= 2ed34ade.70c54eee.b512.02:bd:15:d4:f9:7f (rep-3)
oplog id= 0
replica_oid= d2a1259a.7a194c48.bcd1.6f:e6:ee:f4:1b:e2 (rep-1)
oplog id= 144