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

2  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

 

2  Arguments
 

3  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  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.
 

2  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.