SAP IQ - Transaction Log Restore

[kairi2210]

Hello Experts,

We are trying to do some testing on backup and restore the transaction logs.

We did the backup by using dbbackup -t.
After awhile , we are trying to restore back the old transaction log by using dblog command, and got error on the below. We dont think its the right command to do so.

So we used back the latest transaction log, and it can be started normally.

Can any experts help us on how to restore back the old trans log?

[youn-jae_kim]

Hi kairi2210.

I'd like to add more information on the backup and transaction log.

Regarding 'TRANSACTION LOG', the transaction log plays a key role in the system recovery. A Transaction log is a file where the database server logs all changes made to the database, but doesn't store any real data.

Between Transaction log and Catalog db ( *.db) there are unique identifiers for the previous & current transaction log. It's used for recovery at server start up.

Therefore doing backup transaction log only is not allowed. When do restore through the only transaction log, it'll cause database inconsistency.

There is 'dbbackup' utility. The dbbackup utility makes a copy of the transaction log of a running SAP IQ database.

'dbbackup' is mostly used in IQ-Multiplex environment and please ignore using of 'dbbackup' in real world.

To back up an entire SAP IQ database, always use "BACKUP DATABASE" command instead of dbbackup.

Best Regards.
ykim.

[RolandKramer]

Hello kairi2210

the Question is already answered in the question - https://answers.sap.com/questions/13732247/sap-iq-transaction-log-restore-backup.html

Best Regards Roland