on 09-24-2008 8:54 AM
Thank you for reading my problem first
For example, I have a database name DEMO, and for this DB, I have 1 complete data backup, and also have 1 log backup which was taken after the data backup.
Now I want to restore this DEMO to another database DEMO_666, I am able to import the complete data backup into DEMO_666 with "db_activate recover" , but is it possible to import the log backup from DEMO to DEMO_666 as well?
I dont know if I say it clearly, if you have any questions, please let me know _
Thanks for help.
vivian
Yes, this is possible.
You just have to make sure that you don't bring the database to online mode after restoring the complete backup.
The database has to stay in admin mode and then you can continue with restoring incremental or log backups.
Best regards,
Melanie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
wow, so quick ~ thank you!
But I got some error message while trying to restore the log backup, can you help me see below and tell me what is the problem if you get it ? _
and the source DB and target DB are both on same computers.
Thanks,
vivian
dbmcli on demo_666>db_activate recover demo6_full
OK
Returncode 0
Date 20080924
Time 00171259
Server IBM-L3GWY26.cn.ibm.com
Database DEMO1
Kernel Version Kernel 7.6.03 Build 015-123-173-107
Pages Transferred 360
Pages Left 0
Volumes 1
Medianame Demo6_full
Location D:\maxdb_data\backup\recover\demo1_full
Errortext
Label DAT_000000001
Is Consistent true
First LOG Page 1177
Last LOG Page
DB Stamp 1 Date 20080923
DB Stamp 1 Time 00135145
DB Stamp 2 Date
DB Stamp 2 Time
Page Count 347
Devices Used 1
Database ID IBM-L3GWY26.cn.ibm.com:DEMO1_20080923_135145
Max Used Data Page 0
Converter Page Count 8
---
dbmcli on demo_666>recover_start demo6_log log 001
ERR
-24988,ERR_SQL: SQL error
-903,Host file I/O error
20000,no update of LogInfoPage: DeviceState = Cleared, LogIsEmpty = true
6,k38headmaster, Error code 3700 "hostfile_error"
6,RestoreLog, Error code 3700 "hostfile_error"
Edited by: vivian shi on Sep 24, 2008 11:17 AM
Hello Melanie, thank you for taking time on my issue.
I found the problem actually is with the backup template in new database. In source database, the log backup template is defined with block sizes 8, but in new database, I defined it with block sizes 6, so that causes the errors.
Now it is OK and I can restore the logs already ~ really appreciate your help 谢谢 _
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.