Home | Previous Page | Next Page   Overview of the ON-Bar Backup and Restore System > Restoring Data with ON-Bar >

Restoring Table Types

Table 12 discusses restore scenarios for different table types. For more information about the table types, see the IBM Informix: Administrator's Guide and the IBM Informix: Guide to SQL Syntax.

Table 12. Restoring Table Types
Table Type IDS XPS Can You Restore This Type of Table?
Standard X X Yes. Warm restore, cold restore, and point-in-time restore work.
Duplicated X Yes. Only the primary copy of the table is restored. Following a restore, manually drop all duplicates using the SQL command DROP DUPLICATE OF TABLE.

You can then duplicate the table again by using the SQL command CREATE DUPLICATE OF TABLE. For more information, see the IBM Informix: Guide to SQL Syntax.

Temp X X No.
Scratch X No.
Operational X You can restore an operational table if no light appends occurred since the last level-0 backup.

If light appends occur to the table since the last backup, the table is not wholly restorable. This sort of problem can also occur if you restore from an older backup. To determine whether your table was restored to its original state, check the message log for the following error message:

Portions of partition partnum of table tablename
in database dbname were not logged. This partition 
cannot be rolled forward.

If you see this message, the table or table fragments were not restored to their original state. If you want full access to whatever remains in this table, you need to alter the table to raw and then to the desired table type. This alter operation removes inconsistencies in the table that resulted from replaying non-logged operations such as light appends.

Raw X X When you restore a raw table, it contains only data that was on disk at the time of the last backup. Because raw tables are not logged, changes that occurred since the last backup cannot be restored.
Static X Yes, you can restore the data present at the last dbslice or dbspace backup.

Static tables cannot change data. If you alter a static table to another type and update the data, the recoverability of the table depends on each type the table has been since each dbspace was backed up. For example, if you alter a static table to raw, it follows the rules for restoring a raw table.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]