MaxDB 数据库迁移心得
不同平台(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
希望对大家有所帮助:lol
页:
[1]