Home » Other » Marketplace » RedoMiner ,lightweight replicate solution
icon3.gif  RedoMiner ,lightweight replicate solution [message #271138] Sat, 29 September 2007 22:49 Go to next message
sunwy
Messages: 3
Registered: September 2007
Junior Member
RedoMiner is lightweight replicate solution, It lik Oracle's Stream,Quest's SharePlex.
RedoMiner can efficiently capture DML and Truncate changes made to tables and replicate those changes to one or more other databases.

[Updated on: Sun, 30 September 2007 10:41]

Report message to a moderator

Re: RedoMiner ,lightweight replicate solution [message #271194 is a reply to message #271138] Sun, 30 September 2007 13:20 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

I don't know how many of them will intend to download a .rar file. I am afraid it may contains virus. By the way can you tell us a brief feature of this tool.

Cheers
Soumen
Re: RedoMiner ,lightweight replicate solution [message #271217 is a reply to message #271194] Sun, 30 September 2007 21:28 Go to previous messageGo to next message
sunwy
Messages: 3
Registered: September 2007
Junior Member
RedoMiner
RedoMiner is lightweight replicate solution, It lik Oracle's Stream,Quest's SharePlex.
RedoMiner can efficiently capture DML and Truncate changes made to tables and replicate those changes to one or more other databases.

OS:
HP-UX11i

DB:
ORACLE9i


redominer process overview
redo_miner:capture process
redo_apply:apply DML and Truncate changes to others database;

Datatypes Captured
CHAR
VARCHAR2
NUMBER
DATE
TIMESTAMP



Setup:

Set ENV:
ORACLE_HOME、LD_LIBRARY_PATH=$ORACLE_HOME/lib32
Supplemental Logging:
lsupplemental logging for table that will be replicate

Dictionary:
tab : contain table that will be replicate
col : table columns

col Format:
DATA_OBJECT_ID,column_id,column_name,datatype,Y/N (PK)
tab Format:
DATA_OBJECT_ID,table_name
Config File:cfg.ini

OS=HP-UX
OS_FILE_HEADER=1024
REDOBLOCKSIZE=1024
BIGEND=FALSE
SHM_BLOCK_SIZE=8192
SHM_BLOCKS=1024
TRANSACTIONS=1024
BITS=64
SRC_CONN=sun/sun@ssyto
DEST_CONN=sun/sun@ssyto
TEST_EXPIRE=20080101
LICENSE=710f5015fb37a064

SHM_BLOCK_SIZE:
SHM_BLOCKS : multi 1024,SHM_BLOCKS*SHM_BLOCK_SIZE is Cache Size

SRC_CONN:Source Database Connection String ,User be granted SELECT_CATALOG_ROLE
DEST_CONN:Dest Database Connection String
Manager Interface :mgr
oracle@rac2:/RedoMiner> mgr
miner:cmd act on redo_miner process
apply:cmd act on redo_apply process

1 Start Miner

CMD>miner
CMD Miner>start

2 Start Apply
CMD Miner>apply
CMD Apply>start

3 Stop apply
CMD>apply
CMD Apply>shutdown


4 Stop Miner
CMD>miner
CMD Miner>shutdown

5 Show Context
CMD>miner
CMD Miner>showsga



Contact:swy1024@hotmail.com
MSN:swy1024@hotmail.com









welcome to trial [message #271527 is a reply to message #271138] Mon, 01 October 2007 21:07 Go to previous message
sunwy
Messages: 3
Registered: September 2007
Junior Member
welcome to trial
Previous Topic: Oracle 10G DBA Contract
Next Topic: can anybody advise for oracle institute in mumbai
Goto Forum:
  


Current Time: Thu Mar 28 11:05:56 CDT 2024