Resets an area's inconsistent indication flag, allowing you to
    use the database.

1  –  Description

    When a storage area is restored from backup files on a by-area
    basis, it does not reflect data that has been updated since
    the backup operation. The transaction level of the restored
    area reflects the transaction level of the backup file, not the
    transaction level of the database. Therefore, the transaction
    level of the restored area differs from that of the database.
    Oracle Rdb marks the area by setting a flag in the storage area
    file to inconsistent.

    You can perform a recovery by area to upgrade the transaction
    level of the restored area to that of the database. (After-image
    journaling must be enabled in order to restore by area.) If you
    are certain that no updates have been made to the database since
    the backup operation, you can use the MAKE CONSISTENT command in
    RdbALTER to change the setting of the flag from inconsistent to
    consistent.

                                   NOTE

       Beginning in Oracle Rdb Version 6.0, the capabilities
       provided through this command are also provided through the
       RMU Set Corrupt_Pages command. The RdbALTER MAKE CONSISTENT
       command might be removed in future versions of Oracle Rdb.
       Therefore, Oracle Corporation recommends that you use the
       RMU Set Corrupt_Pages command instead of the RdbALTER MAKE
       CONSISTENT command when these capabilities are needed.

2  –  Format

  (B)0qwqqq>qqqqwq> CONSISTENT qwq> storage-area-name qqqwq>
   m> MAKE qj               mq> storage-area-number qj

3  –  Arguments

3.1  –  storage-area-name

    Specifies a storage area by the storage area name, which is the
    name defined with the SQL CREATE STORAGE AREA statement.

3.2  –  storage-area-number

    Specifies a storage area by storage area number, which is
    assigned when the database is created and is given on the first
    line of a page display.

4  –  Examples

    Example 1

    The following example resets the indication flag from
    inconsistent to consistent for the area JOBS:

    RdbALTER> MAKE CONSISTENT JOBS

                    ***** WARNING! *****

     BEWARE ATTEMPTING TO MAKE CONSISTENT A STORAGE
     AREA WITHOUT FIRST VERIFYING IT USING THE
     RMU/VERIFY COMMAND.

     AN RdbALTER ROLLBACK COMMAND WILL LEAVE THIS
     AREA MARKED INCONSISTENT.

    Area JOBS now marked consistent.