Linux下TimesTen主備搭建、重建cache group、重建備機操作[TimesTen運維]
Linux下TimesTen主備搭建、重建cache group、重建備機操作
整個過程都比較簡單,這裡也就都不加描述了,適合初學者做為參考。
useradd timesten
passwd timesten
usermod -G oinstall timesten
mkdir -p /Timesten/tt11/logs
mkdir -p /Timesten/tt11/info
mkdir -p /Timesten/ttcheck/DataStore
mkdir -p /Timesten/tt11/ttlog
chown -R timesten:timesten /etc/TimesTen /Timesten
==》配置環境變數,這裡直接採用$TT_HOME/bin下的setenv.sh獲得即可。
export TT_HOME=/Timesten/tt11
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/timesten/TimesTen/tt1121/lib
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export PATH=/home/timesten/TimesTen/tt1121/bin:$ORACLE_HOME/bin:$LD_LIBRARY_PATH:$PATH
==》解壓安裝介質
[timesten@ty102g Timesten]$ tar -xvf timesten112180.linux8664.tar
linux8664/
linux8664/doc/
linux8664/doc/doc.zip
linux8664/3rdparty/
linux8664/3rdparty/ant-1.6.2-bin.tar.bz2
linux8664/3rdparty/jms-1_1-fr-apidocs.tar.bz2
linux8664/install.pl
linux8664/setup.sh
linux8664/uninst.sh
linux8664/README.html
linux8664/LINUX8664/
linux8664/LINUX8664/manifest
linux8664/LINUX8664/perl
linux8664/LINUX8664/bzip2
linux8664/LINUX8664/unzip
linux8664/LINUX8664/ttpatchinst
linux8664/LINUX8664/common.tar.bz2
linux8664/LINUX8664/ttserver.tar.bz2
linux8664/LINUX8664/timesten.tar.bz2
linux8664/LINUX8664/ttclient.tar.bz2
[timesten@ty102g linux8664]$ cd linux8664
[timesten@ty102g linux8664]$ ./setup.sh
NOTE: Each TimesTen installation is identified by a unique instance name.
The instance name must be a non-null alphanumeric string, not longer than 255 characters.
Please choose an instance name for this installation? [ tt1121 ]
Instance name will be 'tt1121'.
Is this correct? [ yes ]
Of the three components:
[1] Client/Server and Data Manager
[2] Data Manager Only
[3] Client Only
Which would you like to install? [ 1 ]
Of the following options :
[1] /home/timesten
[2] /Timesten
[3] Specify a location
[q] Quit the installation
Where would you like to install the tt1121 instance of TimesTen? [ 1 ]
Where would you like to create the daemon home directory? [ /home/timesten/TimesTen/tt1121/info ] /Timesten/tt11/info
The daemon logs will be located in /Timesten/tt11/info
Would you like to specify a different location for the daemon logs? [ no ] yes
Where would you like the daemon logs to be written? [ /Timesten/tt11/info ] /Timesten/tt11/logs
Are you sure you want the daemon logs to be written to /Timesten/tt11/logs? [ yes ]
Installing into /home/timesten/TimesTen/tt1121 ...
Creating /home/timesten/TimesTen/tt1121 ...
Uncompressing ...
NOTE: If you are configuring TimesTen for use with Oracle Clusterware, the daemon port number must be the same across all TimesTen installations managed within the same Oracle Clusterware cluster.
NOTE: All installations that replicate to each other must use the same daemon port number that is set at installation time. The daemon port number can be verified by running 'ttVersion'.
The default port number is 53388.
Do you want to use the default port number for the TimesTen daemon? [ yes ]
The daemon will run on the default port number (53388).
NOTE: For security, we recommend that you restrict access to the
TimesTen installation to members of a single OS group. Only members of that OS group will be allowed to perform direct mode connections to TimesTen, and only members of that OS group will be allowed to perform operations that access TimesTen data stores, TimesTen files and shared memory. The OS group defaults to the primary group of the instance administrator. You can default to this group, choose another OS group or you can make this instance world-accessible. If you choose to make this instance world-accessible, all database files and shared memory are readable and writable by all users.
Restrict access to the the TimesTen installation to the group 'timesten'? [ yes ]
NOTE: Enabling PL/SQL will increase the size of some TimesTen libraries.
Would you like to enable PL/SQL for this instance? [ yes ] no
PL/SQL will not be enabled. It can be enabled later by running
/home/timesten/TimesTen/tt1121/bin/ttmodinstall.
In order to use the 'In-Memory Database Cache' feature in any databases
created within this installation, you must set a value for the TNS_ADMIN
environment variable. It can be left blank, and a value can be supplied later
using/bin/ttModInstall.
Please enter a value for TNS_ADMIN (s=skip)? [ ] s
NOTE: It appears that you are running version 4.1 of the g++ compiler. TimesTen ships with multiple sets of client libraries and server binaries : one built for compatibility with g++ 3.4.6 and one with g++ 4.1.0. The installer has created links to the 4.1.0 library in the/lib directory and to the 4.1.0 server binary in the /bin directory. If you want to use a different compiler, please modify the links to point to the desired library and server binary.
Installing server components ...
What is the TCP/IP port number that you want the TimesTen Server to listen on? [ 53389 ]
Do you want to install QuickStart and the TimesTen Documentation? [ no ]
Would you like to install the documentation (without QuickStart)? [ yes ] no
Installing client components ...
Would you like to use TimesTen Replication with Oracle Clusterware? [ no ]
NOTE: The TimesTen daemon startup/shutdown scripts have not been installed.
Run the 'setuproot' script :
cd /home/timesten/TimesTen/tt1121/bin
./setuproot -install
This will move the TimesTen startup script into its appropriate location.
The startup script is currently located here :
'/home/timesten/TimesTen/tt1121/startup/tt_tt1121'.
The documentation was not installed.
To manually install the documentation, run the command 'setup.sh -installDoc'
The 11.2.1.8 Release Notes are located here :
'/home/timesten/TimesTen/tt1121/README.html'
Starting the daemon ...
TimesTen Daemon startup OK.
End of TimesTen installation.
==》配置例項
vi sys.odbc.ini
[tytt]
Driver=/home/timesten/TimesTen/tt1121/lib/libtten.so
DataStore=/Timesten/ttcheck/DataStore/tytt
LogDir=/Timesten/tt11/logs
PermSize=100
TempSize=32
OracleNetServiceName=ora62a
DatabaseCharacterSet=ZHS16GBK
#UID=tt_ty
#PWD=tt_ty
==》啟動/載入例項
[timesten@ty10dg info]$ ttisql tytt
Copyright (c) 1996-2011, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "DSN=tytt";
Connection successful: DSN=tytt;UID=ttty;DataStore=/Timesten/ttcheck/DataStore/tytt;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=US7ASCII;DRIVER=/home/timesten/TimesTen/tt1121/lib/libtten.so;LogDir=/Timesten/tt11/logs;PermSize=100;TempSize=32;TypeMode=0;OracleNetServiceName=ora62a;
(Default setting AutoCommit=1)
[timesten@ty10dg info]$ ttadmin -ramPolicy manual tytt
RAM Residence Policy : manual
Manually Loaded In RAM : True
Replication Agent Policy : manual
Replication Manually Started : False
Cache Agent Policy : manual
Cache Agent Manually Started : False
[timesten@ty10dg info]$ ttisql "dsn=tytt;uid=ttty;pwd=ttty;oraclepwd=ttty"
Copyright (c) 1996-2011, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "dsn=tytt;uid=ttty;pwd=ttty;oraclepwd=ttty";
Connection successful: DSN=tytt;UID=ttty;DataStore=/Timesten/ttcheck/DataStore/tytt;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=US7ASCII;DRIVER=/home/timesten/TimesTen/tt1121/lib/libtten.so;LogDir=/Timesten/tt11/logs;PermSize=100;TempSize=32;TypeMode=0;OracleNetServiceName=ora62a;
(Default setting AutoCommit=1)
Command> call ttcacheuidpwdset('ttty','ttty');
Command> call ttcachestart;
Command> call ttgridcreate('tygrid');
Command> call ttgridnameset('tygrid');
Command> create readonly cache group ty.tt_tyun_cache autorefresh interval 2 seconds from ty.tt_tyun (tid number not null primary key,tname varchar2(20),tpart number);
Command> create readonly cache group ty.tt_objects_cache autorefresh interval 1 seconds
> from ty.tt_objects(object_id number not null primary key,owner varchar2(30),object_name varchar2(128),object_type varchar2(19),created date,last_ddl_time date,status varchar2(7));
Command> cachegroups;
Cache Group TY.TT_OBJECTS_CACHE:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: Paused
Autorefresh Interval: 1 Second
Autorefresh Status: ok
Aging: No aging defined
Root Table: TY.TT_OBJECTS
Table Type: Read Only
Cache Group TY.TT_TYUN_CACHE:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: Paused
Autorefresh Interval: 2 Seconds
Autorefresh Status: ok
Aging: No aging defined
Root Table: TY.TT_TYUN
Table Type: Read Only
2 cache groups found.
Command>
Command> load cache group ty.tt_tyun_cache commit every 100 rows;
4 cache instances affected.
Command> load cache group ty.tt_objects_cache commit every 200 rows parallel 2;
50072 cache instances affected.
Command> cachegroups;
Cache Group TY.TT_OBJECTS_CACHE:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: On
Autorefresh Interval: 1 Second
Autorefresh Status: ok
Aging: No aging defined
Root Table: TY.TT_OBJECTS
Table Type: Read Only
Cache Group TY.TT_TYUN_CACHE:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: On
Autorefresh Interval: 2 Seconds
Autorefresh Status: ok
Aging: No aging defined
Root Table: TY.TT_TYUN
Table Type: Read Only
2 cache groups found.
Command>
==》以上操作已經正常完成,下面重建cachegroup TY.TT_OBJECTS_CACHE;
Command> select count(*) from ty.tt_objects;
< 50072 >
1 row found.
Command> alter cache group ty.tt_objects_cache set autorefresh state paused;
Command> alter active standby pair exclude cache group ty.tt_objects_cache;
8123: An ACTIVE STANDBY PAIR scheme does not exist
The command failed.
==》這裡報錯是因為沒有建備機
Command> drop cache group ty.tt_objects_cache;
==》oracle端裝載資料
SQL> truncate table tt_objects;
Table truncated.
SQL> insert into tt_objects(owner,object_name,object_id,object_type,created,last_ddl_time,status) select owner,object_name,object_id,object_type,created,last_ddl_time,status from dba_objects;
50104 rows created.
SQL> commit;
Commit complete.
Command> create readonly cache group ty.tt_objects_cache autorefresh interval 1 seconds
> from ty.tt_objects(object_id number not null primary key,owner varchar2(30),object_name varchar2(128),object_type varchar2(19),created date,last_ddl_time date,status varchar2(7));
Command> load cache group ty.tt_objects_cache commit every 200 rows parallel 2;
50104 cache instances affected.
Command> alter cache group ty.tt_objects_cache set autorefresh state paused;
Command> alter cache group ty.tt_tyun_cache set autorefresh state paused;
Command> create active standby pair tytt on ty10dg ,tytt on ty102g include cache group ty.tt_tyun_cache,ty.tt_objects_cache;
Command> repschemes;
Replication Scheme Active Standby:
Master Store: TYTT on TY10DG
Master Store: TYTT on TY102G
Excluded Tables:
None
Excluded Cache Groups:
None
Excluded sequences:
None
Store: TYTT on TY10DG
Port: (auto)
Log Fail Threshold: (none)
Retry Timeout: 120 seconds
Compress Traffic: Disabled
Store: TYTT on TY102G
Port: (auto)
Log Fail Threshold: (none)
Retry Timeout: 120 seconds
Compress Traffic: Disabled
1 replication scheme found.
Command> call ttrepstart;
Command> call ttrepstateset('ACTIVE');
Command> alter cache group ty.tt_tyun_cache set autorefresh state on;
Command> alter cache group ty.tt_objects_cache autorefresh state on;
==》重建備機
vi sys.odbc.ini
[tytt]
Driver=/home/timesten/TimesTen/tt1121/lib/libtten.so
DataStore=/Timesten/ttcheck/DataStore/tytt
LogDir=/Timesten/tt11/logs
PermSize=100
TempSize=32
OracleNetServiceName=ora62a
DatabaseCharacterSet=ZHS16GBK
#UID=ttty
#PWD=ttty
"sys.odbc.ini" 274L, 11369C written
[timesten@ty102g info]$ ttRepAdmin -duplicate -from tytt -host ty10dg -uid ttty -pwd ttty -setMasterRepStart -ramLoad -compression 0 -verbosity 2 -keepCG -cacheUid ttty -cachePwd ttty -localhost ty102g -connStr "dsn=tytt"
11:13:06 Contacting remote main daemon at 192.168.64.62 port 53388
11:13:06 Contacting the replication agent for TYTT ON TY10DG (192.168.64.62) port 11141
11:13:07 Beginning transfer from TYTT ON TY10DG to TYTT ON TY102G
11:15:36 Checkpoint transfer 10 percent complete
11:15:37 Checkpoint transfer 100 percent complete
11:15:37 Checkpoint transfer phase complete
11:15:40 Log transfer 100 percent complete
11:15:40 Log transfer phase complete
11:15:41 Transfer complete
11:16:11 Duplicate Operation Ends
[timesten@ty102g info]$ ttisql tytt
Copyright (c) 1996-2011, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "DSN=tytt";
Connection successful: DSN=tytt;UID=timesten;DataStore=/Timesten/ttcheck/DataStore/tytt;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=US7ASCII;DRIVER=/home/timesten/TimesTen/tt1121/lib/libtten.so;LogDir=/Timesten/tt11/logs;PermSize=100;TempSize=32;TypeMode=0;OracleNetServiceName=ora62a;
(Default setting AutoCommit=1)
Command> call ttrepstart;
Command> select count(*) from ty.tt_tyun;
< 5 >
1 row found.
Command>
==》oracle端
SQL> insert into tt_tyun values(6,'tangyun',2);
1 row created.
SQL> commit;
Commit complete.
==》主節點
Command> select count(*) from ty.tt_tyun;
< 6 >
1 row found.
==》備節點
Command> select count(*) from ty.tt_tyun;
< 6 >
1 row found.
--------------------------end--------------------------------
整個過程都比較簡單,這裡也就都不加描述了,適合初學者做為參考。
useradd timesten
passwd timesten
usermod -G oinstall timesten
mkdir -p /Timesten/tt11/logs
mkdir -p /Timesten/tt11/info
mkdir -p /Timesten/ttcheck/DataStore
mkdir -p /Timesten/tt11/ttlog
chown -R timesten:timesten /etc/TimesTen /Timesten
==》配置環境變數,這裡直接採用$TT_HOME/bin下的setenv.sh獲得即可。
export TT_HOME=/Timesten/tt11
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/timesten/TimesTen/tt1121/lib
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export PATH=/home/timesten/TimesTen/tt1121/bin:$ORACLE_HOME/bin:$LD_LIBRARY_PATH:$PATH
==》解壓安裝介質
[timesten@ty102g Timesten]$ tar -xvf timesten112180.linux8664.tar
linux8664/
linux8664/doc/
linux8664/doc/doc.zip
linux8664/3rdparty/
linux8664/3rdparty/ant-1.6.2-bin.tar.bz2
linux8664/3rdparty/jms-1_1-fr-apidocs.tar.bz2
linux8664/install.pl
linux8664/setup.sh
linux8664/uninst.sh
linux8664/README.html
linux8664/LINUX8664/
linux8664/LINUX8664/manifest
linux8664/LINUX8664/perl
linux8664/LINUX8664/bzip2
linux8664/LINUX8664/unzip
linux8664/LINUX8664/ttpatchinst
linux8664/LINUX8664/common.tar.bz2
linux8664/LINUX8664/ttserver.tar.bz2
linux8664/LINUX8664/timesten.tar.bz2
linux8664/LINUX8664/ttclient.tar.bz2
[timesten@ty102g linux8664]$ cd linux8664
[timesten@ty102g linux8664]$ ./setup.sh
NOTE: Each TimesTen installation is identified by a unique instance name.
The instance name must be a non-null alphanumeric string, not longer than 255 characters.
Please choose an instance name for this installation? [ tt1121 ]
Instance name will be 'tt1121'.
Is this correct? [ yes ]
Of the three components:
[1] Client/Server and Data Manager
[2] Data Manager Only
[3] Client Only
Which would you like to install? [ 1 ]
Of the following options :
[1] /home/timesten
[2] /Timesten
[3] Specify a location
[q] Quit the installation
Where would you like to install the tt1121 instance of TimesTen? [ 1 ]
Where would you like to create the daemon home directory? [ /home/timesten/TimesTen/tt1121/info ] /Timesten/tt11/info
The daemon logs will be located in /Timesten/tt11/info
Would you like to specify a different location for the daemon logs? [ no ] yes
Where would you like the daemon logs to be written? [ /Timesten/tt11/info ] /Timesten/tt11/logs
Are you sure you want the daemon logs to be written to /Timesten/tt11/logs? [ yes ]
Installing into /home/timesten/TimesTen/tt1121 ...
Creating /home/timesten/TimesTen/tt1121 ...
Uncompressing ...
NOTE: If you are configuring TimesTen for use with Oracle Clusterware, the daemon port number must be the same across all TimesTen installations managed within the same Oracle Clusterware cluster.
NOTE: All installations that replicate to each other must use the same daemon port number that is set at installation time. The daemon port number can be verified by running 'ttVersion'.
The default port number is 53388.
Do you want to use the default port number for the TimesTen daemon? [ yes ]
The daemon will run on the default port number (53388).
NOTE: For security, we recommend that you restrict access to the
TimesTen installation to members of a single OS group. Only members of that OS group will be allowed to perform direct mode connections to TimesTen, and only members of that OS group will be allowed to perform operations that access TimesTen data stores, TimesTen files and shared memory. The OS group defaults to the primary group of the instance administrator. You can default to this group, choose another OS group or you can make this instance world-accessible. If you choose to make this instance world-accessible, all database files and shared memory are readable and writable by all users.
Restrict access to the the TimesTen installation to the group 'timesten'? [ yes ]
NOTE: Enabling PL/SQL will increase the size of some TimesTen libraries.
Would you like to enable PL/SQL for this instance? [ yes ] no
PL/SQL will not be enabled. It can be enabled later by running
/home/timesten/TimesTen/tt1121/bin/ttmodinstall.
In order to use the 'In-Memory Database Cache' feature in any databases
created within this installation, you must set a value for the TNS_ADMIN
environment variable. It can be left blank, and a value can be supplied later
using
Please enter a value for TNS_ADMIN (s=skip)? [ ] s
NOTE: It appears that you are running version 4.1 of the g++ compiler. TimesTen ships with multiple sets of client libraries and server binaries : one built for compatibility with g++ 3.4.6 and one with g++ 4.1.0. The installer has created links to the 4.1.0 library in the
Installing server components ...
What is the TCP/IP port number that you want the TimesTen Server to listen on? [ 53389 ]
Do you want to install QuickStart and the TimesTen Documentation? [ no ]
Would you like to install the documentation (without QuickStart)? [ yes ] no
Installing client components ...
Would you like to use TimesTen Replication with Oracle Clusterware? [ no ]
NOTE: The TimesTen daemon startup/shutdown scripts have not been installed.
Run the 'setuproot' script :
cd /home/timesten/TimesTen/tt1121/bin
./setuproot -install
This will move the TimesTen startup script into its appropriate location.
The startup script is currently located here :
'/home/timesten/TimesTen/tt1121/startup/tt_tt1121'.
The documentation was not installed.
To manually install the documentation, run the command 'setup.sh -installDoc'
The 11.2.1.8 Release Notes are located here :
'/home/timesten/TimesTen/tt1121/README.html'
Starting the daemon ...
TimesTen Daemon startup OK.
End of TimesTen installation.
==》配置例項
vi sys.odbc.ini
[tytt]
Driver=/home/timesten/TimesTen/tt1121/lib/libtten.so
DataStore=/Timesten/ttcheck/DataStore/tytt
LogDir=/Timesten/tt11/logs
PermSize=100
TempSize=32
OracleNetServiceName=ora62a
DatabaseCharacterSet=ZHS16GBK
#UID=tt_ty
#PWD=tt_ty
==》啟動/載入例項
[timesten@ty10dg info]$ ttisql tytt
Copyright (c) 1996-2011, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "DSN=tytt";
Connection successful: DSN=tytt;UID=ttty;DataStore=/Timesten/ttcheck/DataStore/tytt;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=US7ASCII;DRIVER=/home/timesten/TimesTen/tt1121/lib/libtten.so;LogDir=/Timesten/tt11/logs;PermSize=100;TempSize=32;TypeMode=0;OracleNetServiceName=ora62a;
(Default setting AutoCommit=1)
[timesten@ty10dg info]$ ttadmin -ramPolicy manual tytt
RAM Residence Policy : manual
Manually Loaded In RAM : True
Replication Agent Policy : manual
Replication Manually Started : False
Cache Agent Policy : manual
Cache Agent Manually Started : False
[timesten@ty10dg info]$ ttisql "dsn=tytt;uid=ttty;pwd=ttty;oraclepwd=ttty"
Copyright (c) 1996-2011, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "dsn=tytt;uid=ttty;pwd=ttty;oraclepwd=ttty";
Connection successful: DSN=tytt;UID=ttty;DataStore=/Timesten/ttcheck/DataStore/tytt;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=US7ASCII;DRIVER=/home/timesten/TimesTen/tt1121/lib/libtten.so;LogDir=/Timesten/tt11/logs;PermSize=100;TempSize=32;TypeMode=0;OracleNetServiceName=ora62a;
(Default setting AutoCommit=1)
Command> call ttcacheuidpwdset('ttty','ttty');
Command> call ttcachestart;
Command> call ttgridcreate('tygrid');
Command> call ttgridnameset('tygrid');
Command> create readonly cache group ty.tt_tyun_cache autorefresh interval 2 seconds from ty.tt_tyun (tid number not null primary key,tname varchar2(20),tpart number);
Command> create readonly cache group ty.tt_objects_cache autorefresh interval 1 seconds
> from ty.tt_objects(object_id number not null primary key,owner varchar2(30),object_name varchar2(128),object_type varchar2(19),created date,last_ddl_time date,status varchar2(7));
Command> cachegroups;
Cache Group TY.TT_OBJECTS_CACHE:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: Paused
Autorefresh Interval: 1 Second
Autorefresh Status: ok
Aging: No aging defined
Root Table: TY.TT_OBJECTS
Table Type: Read Only
Cache Group TY.TT_TYUN_CACHE:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: Paused
Autorefresh Interval: 2 Seconds
Autorefresh Status: ok
Aging: No aging defined
Root Table: TY.TT_TYUN
Table Type: Read Only
2 cache groups found.
Command>
Command> load cache group ty.tt_tyun_cache commit every 100 rows;
4 cache instances affected.
Command> load cache group ty.tt_objects_cache commit every 200 rows parallel 2;
50072 cache instances affected.
Command> cachegroups;
Cache Group TY.TT_OBJECTS_CACHE:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: On
Autorefresh Interval: 1 Second
Autorefresh Status: ok
Aging: No aging defined
Root Table: TY.TT_OBJECTS
Table Type: Read Only
Cache Group TY.TT_TYUN_CACHE:
Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: On
Autorefresh Interval: 2 Seconds
Autorefresh Status: ok
Aging: No aging defined
Root Table: TY.TT_TYUN
Table Type: Read Only
2 cache groups found.
Command>
==》以上操作已經正常完成,下面重建cachegroup TY.TT_OBJECTS_CACHE;
Command> select count(*) from ty.tt_objects;
< 50072 >
1 row found.
Command> alter cache group ty.tt_objects_cache set autorefresh state paused;
Command> alter active standby pair exclude cache group ty.tt_objects_cache;
8123: An ACTIVE STANDBY PAIR scheme does not exist
The command failed.
==》這裡報錯是因為沒有建備機
Command> drop cache group ty.tt_objects_cache;
==》oracle端裝載資料
SQL> truncate table tt_objects;
Table truncated.
SQL> insert into tt_objects(owner,object_name,object_id,object_type,created,last_ddl_time,status) select owner,object_name,object_id,object_type,created,last_ddl_time,status from dba_objects;
50104 rows created.
SQL> commit;
Commit complete.
Command> create readonly cache group ty.tt_objects_cache autorefresh interval 1 seconds
> from ty.tt_objects(object_id number not null primary key,owner varchar2(30),object_name varchar2(128),object_type varchar2(19),created date,last_ddl_time date,status varchar2(7));
Command> load cache group ty.tt_objects_cache commit every 200 rows parallel 2;
50104 cache instances affected.
Command> alter cache group ty.tt_objects_cache set autorefresh state paused;
Command> alter cache group ty.tt_tyun_cache set autorefresh state paused;
Command> create active standby pair tytt on ty10dg ,tytt on ty102g include cache group ty.tt_tyun_cache,ty.tt_objects_cache;
Command> repschemes;
Replication Scheme Active Standby:
Master Store: TYTT on TY10DG
Master Store: TYTT on TY102G
Excluded Tables:
None
Excluded Cache Groups:
None
Excluded sequences:
None
Store: TYTT on TY10DG
Port: (auto)
Log Fail Threshold: (none)
Retry Timeout: 120 seconds
Compress Traffic: Disabled
Store: TYTT on TY102G
Port: (auto)
Log Fail Threshold: (none)
Retry Timeout: 120 seconds
Compress Traffic: Disabled
1 replication scheme found.
Command> call ttrepstart;
Command> call ttrepstateset('ACTIVE');
Command> alter cache group ty.tt_tyun_cache set autorefresh state on;
Command> alter cache group ty.tt_objects_cache autorefresh state on;
==》重建備機
vi sys.odbc.ini
[tytt]
Driver=/home/timesten/TimesTen/tt1121/lib/libtten.so
DataStore=/Timesten/ttcheck/DataStore/tytt
LogDir=/Timesten/tt11/logs
PermSize=100
TempSize=32
OracleNetServiceName=ora62a
DatabaseCharacterSet=ZHS16GBK
#UID=ttty
#PWD=ttty
"sys.odbc.ini" 274L, 11369C written
[timesten@ty102g info]$ ttRepAdmin -duplicate -from tytt -host ty10dg -uid ttty -pwd ttty -setMasterRepStart -ramLoad -compression 0 -verbosity 2 -keepCG -cacheUid ttty -cachePwd ttty -localhost ty102g -connStr "dsn=tytt"
11:13:06 Contacting remote main daemon at 192.168.64.62 port 53388
11:13:06 Contacting the replication agent for TYTT ON TY10DG (192.168.64.62) port 11141
11:13:07 Beginning transfer from TYTT ON TY10DG to TYTT ON TY102G
11:15:36 Checkpoint transfer 10 percent complete
11:15:37 Checkpoint transfer 100 percent complete
11:15:37 Checkpoint transfer phase complete
11:15:40 Log transfer 100 percent complete
11:15:40 Log transfer phase complete
11:15:41 Transfer complete
11:16:11 Duplicate Operation Ends
[timesten@ty102g info]$ ttisql tytt
Copyright (c) 1996-2011, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "DSN=tytt";
Connection successful: DSN=tytt;UID=timesten;DataStore=/Timesten/ttcheck/DataStore/tytt;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=US7ASCII;DRIVER=/home/timesten/TimesTen/tt1121/lib/libtten.so;LogDir=/Timesten/tt11/logs;PermSize=100;TempSize=32;TypeMode=0;OracleNetServiceName=ora62a;
(Default setting AutoCommit=1)
Command> call ttrepstart;
Command> select count(*) from ty.tt_tyun;
< 5 >
1 row found.
Command>
==》oracle端
SQL> insert into tt_tyun values(6,'tangyun',2);
1 row created.
SQL> commit;
Commit complete.
==》主節點
Command> select count(*) from ty.tt_tyun;
< 6 >
1 row found.
==》備節點
Command> select count(*) from ty.tt_tyun;
< 6 >
1 row found.
--------------------------end--------------------------------
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24930246/viewspace-1065154/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- TimesTen重建備機標準操作[TimesTen運維]運維
- Oracle與TimesTen記憶體資料庫Cache Group同步效率與TimesTen主備資料同步機制研究Oracle記憶體資料庫
- Timesten cache database的準備Database
- TimesTen手動主備切換(ASP模式)[TimesTen運維基礎]模式運維
- TimesTen-CacheGroup配置操作指導[TimesTen運維]運維
- Timesten匯入資料到Cache Group
- Timesten cache group aging 功能的實現
- TimesTen IX鎖及用途介紹[TimesTen運維]運維
- 配置TimesTen客戶端連線[TimesTen運維]客戶端運維
- TimesTen中配置只讀Cache Group to Oracle的基本步驟Oracle
- TimesTen常用維護內建的儲存過程[TimesTen運維基礎]儲存過程運維
- Timesten新增Cache Groups到 Cache DatabaseDatabase
- 控制檔案重建以及備份
- TimesTen運維技能檢測題-基礎篇運維
- [Dataguard]主庫歸檔丟失,備庫不需重建實驗
- 利用RMAN備份重建資料庫資料庫
- 重建物理備庫案例兩則
- Oracle主庫歸檔丟失,備庫日誌有gap,在不重建備庫的情況下,恢復備庫Oracle
- 備份與恢復--重建控制檔案
- Oracle_TimesTen_and_In-Memory_Database_Cache_11g_Ed_1OracleDatabase
- 三維重建基礎
- MongoDB副本集(一主一備+仲裁)環境部署-運維操作記錄MongoDB運維
- TimesTen CacheGroup配置標準操作步驟
- 重建控制檔案後將備份資訊註冊
- ASM磁碟組修改重建操作ASM
- TimesTen學習(三)遠端連線TimesTen資料庫資料庫
- Timesten學習1
- Timesten學習2
- timesten client dsn 配置client
- Step by Step TimesTen --- ttIsqlSQL
- 【備份與恢復】重建受損的聯機重做日誌檔案成員
- Linux運維必備技術有哪些?運維要學開發Linux運維
- Linux 主機的硬體配備Linux
- MySQL叢集搭建(1)-主備搭建MySql
- Linux運維工程師必備工具合集Linux運維工程師
- TimesTen計算和配置TimesTen的ttmesg日誌儲存空間
- timesten配置只讀同步
- TimesTen錯誤總結