|
|
|
|
| Re: RedoMiner ,lightweight replicate solution [message #271217 is a reply to message #271194] |
Sun, 30 September 2007 21:28   |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
