cancel
Showing results for 
Search instead for 
Did you mean: 

Can I restore the log to another DB?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Melanie
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

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

Melanie
Advisor
Advisor
0 Kudos

Hi Vivian,

please check file knldiag for detailed information about the IO error and post this info.

How does the media definition of the log backup medium look like?

Regards, Melanie

Former Member
0 Kudos

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 谢谢 _