MaxDB 数据库迁移心得

qywei2012

不同平台(HREL->AIX)下数据库的迁移（MAXDB版本一致）
需在目标服务器上（target system）利用loadercli这个工具进行import/export

EXPORT语句
./loadercli –d DB –u SAPR3,SAP –n server(Source system) –b /backup/export/SDB_EXPORT.SQL

Touch /VI SDB_EXPORT.SQL

EXPORT USER
catalog outstream file '/backup/export/SAPR3.cat'
data outstream file '/backup/export/SAPR3.data' PAGES
package outstream file '/backup/export/\SAPR3.pack' csv

IMPORT 语句

./loadercli –d DB –u SAPR3,SAP –n server(target system) –b /backup/export/SDB_IMPORT.SQL



Touch/VI SDB_IMPORT.SQL

IMPORT USER
catalog instream file '/backup/export/SAPR3.cat'
data instream file '/backup/export/SAPR3.data' PAGES
package outstream file '/backup/export/SAPR3.pack' csv

Backup.(when data import completed don’t forget do one full backup)
After the page-by-page import into the target database, the data is
write-protected. A complete database backup (SAVE DATA) is
therefore essential once the import process is completed and before
production operation can be resumed

qywei2012

希望对大家有所帮助