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 |
0 komentar:
Post a Comment