My environment
|
|
OLD Timesten Server
|
New Timesten Server
|
|
Timesten Home
|
/home/orattadmin/app/TimesTen/tt1121
|
/u01/app/TimesTen/tt1121
|
|
Host
|
VTGDB1.COM
|
VTGDB2.COM
|
|
User OS
|
orattadmin
|
orattadmin
|
|
Data source
|
ttvaaa
|
ttvaaa
|
|
Backup Dir
|
/home/orattadmin/backup
|
/u01/app/TimesTen/backup
|
ON OLD TIMESTEN SERVER
|
VTGDB1.COM
|
|
[orattadmin@VTGDB1.COM backup]$ttBackup
-type fileFullEnable -dir /home/orattadmin/backup ttvaaa
[orattadmin@VTGDB1.COM backup]$cd
/home/orattadmin/backup
[orattadmin@VTGDB1.COM backup]$ ls
ttvaaa.0.bac
ttvaaa.0.bac64 ttvaaa.sta
|
Copy all contents of /home/orattadmin/backup to NEW TIMESTEN
SERVER (//u01/app/TimesTen/backup)
ON NEW TIMESTEN SERVER
|
VTGDB2.COM
|
|
[orattadmin@VTGDB2.COM backup]$ pwd
/u01/app/TimesTen/backup
[orattadmin@VTGDB2 backup]$ ls
ttvaaa.0.bac
ttvaaa.0.bac64 ttvaaa.sta
|
Insert or edit in file sys.odbc.ini on folder (/u01/app/TimesTen/tt1121/info)
|
VTGDB2.COM
|
|
[ODBC Data Sources]
ttvaaa=TimesTen 11.2.1 Driver
...
[ttvaaa]
Driver=/u01/app/TimesTen/tt1121/lib/libtten.so
DataStore=/u01/app/ttdata/ttvaaa
LogDir=/u01/app/ttdata
PLSQL_MEMORY_SIZE=100
PermSize=1500
TempSize=100
LogBufMB=100
PLSQL=1
#OracleNetServiceName=vas
Connections=100
DatabaseCharacterSet=WE8MSWIN1252
|
Restart ttDaemonAdmin
|
VTGDB2.COM
|
|
[orattadmin@VTGDB2.COM info]$ ttDaemonAdmin
-restart
TimesTen Daemon stopped.
TimesTen Daemon startup OK.
|
Restore TimesTen
|
VTGDB2.COM
|
|
[orattadmin@VTGDB2 TimesTen]$ ttRestore -dir /u01/app/TimesTen/backup
-fname ttvaaa "dsn=ttvaaa"
Restore started ...
Restore complete
|
Is it possible to extract the backup files(bac and bac56)?
ReplyDelete