HELPLIB.HLB  —  RMU72  Restore  Only Root, Description
    The RMU Restore Only_Root command rebuilds only the database root
    (.rdb) file from a backup file, produced earlier by an RMU Backup
    command, to the condition the .rdb file was in when the backup
    operation was performed. Use the command qualifiers to update
    the .rdb file. The area qualifiers alter only the .rdb file, not
    the storage areas themselves. Use the area qualifiers to correct
    the restored backup root file so that it contains storage area
    information that was updated since the last backup operation was
    performed on the database. This is useful when you need to match
    the root from an older backup file of your database with the area
    information in the more recent backup file of your database in
    order to have a usable database.

    When the .rdb file is restored by itself, be sure that you
    correctly set the transaction state of the database with the
    Initialize_Tsns qualifier or the Set_Tsn qualifier. If the
    database transaction sequence number (TSN) and commit sequence
    number (CSN) are not set to the same values as those that were
    in the lost .rdb file, there will be an inconsistency in the
    journaling if after-image journaling is enabled. Therefore, you
    cannot recover the database by using journal files created before
    you used either the Initialize_Tsns qualifier or the Set_Tsn
    qualifier in a restore-only-root operation.

    You should set the TSN to a value equal to or greater than the
    value that was in the lost .rdb file. If the TSN is set to a
    lower value than the value stored in the lost database root file,
    the database is corrupted, and it might return incorrect data or
    result in application failures. If the number you have selected
    is less than the Next CSN and Next TSN values, you will receive a
    fatal error message as follows:

    %RMU-F-VALLSSMIN, value (0:40) is less than minimum allowed
     value (0:74) for Set_Tsn=tsn

    After the set TSN and reinitialize TSN operations
    complete, and after you have verified the .rdb
    file, enabled after-image journaling, and the
    new .aij file is created, all .aij records are based on the new
    starting TSN and CSN numbers in the .rdb file.

    Although Oracle Corporation recommends that your backup strategy
    ensures that you maintain a current full and complete database
    backup file, it is possible to restore the database from
    current full by-area backup files only. This is accomplished by
    restoring the root and specifying the Noupdate_Files and Noset_
    Tsn qualifiers. When you specify the Noset_Tsn qualifier, the
    TSN and CSN values on the restored database will be the same as
    those recorded in the backup file. When you specify the Noupdate_
    Files qualifier, the database root is restored but RMU Restore
    Only_Root will not link that restored root to any of the area
    files, nor will it create or update the snapshot (.snp) files. By
    specifying the Noupdate_Files and Noset_Tsn qualifiers with the
    RMU Restore Only_Root command, you can use the following strategy
    to restore your database:

    1. Restore the root from the most recent full by-area backup
       file.

    2. Restore the storage areas by applying the by-area backup files
       in reverse order to their creation date.

       Apply the most recent by-area backup file first and the oldest
       by-area backup file last. (Be sure you do not restore any area
       more than once.)

    3. Recover the database by applying the after-image journal
       (.aij) files.

       You can recover the .aij files manually by using the RMU
       Recover command. Or, if the state of your .aij files permits
       it, you can allow RMU Restore Only_Root to automatically
       recover the .aij files by not specifying the Norecovery
       qualifier with the last RMU Restore command you issue. For
       details on the automatic recovery feature of the RMU Restore
       command, see the help entry for the RMU Restore command.
       (The automatic recovery feature is not available for the RMU
       Restore Only_Root command.)

    When you use this strategy, be sure that the first RMU Restore
    command after the RMU Restore Only_Root command includes the
    most recent RDB$SYSTEM storage area. The RDB$SYSTEM storage area
    contains the structures needed to restore the other database
    storage areas. For this reason, Oracle Corporation suggests that
    you back up the RDB$SYSTEM storage area in every by-area backup
    operation you perform.

    See Example 6 in the Examples help entry under this command for a
    demonstration of this method.

    Note that the database backup file must be recent-differences
    between the database and backup file must be known, and the
    number of storage areas must be unchanged since the backup file
    was created. If you have moved a storage area, use the File
    qualifier to show its new location and the Snapshot qualifier
    to indicate the current version of the area's .snp file.

                                   NOTE

       You must perform a full and complete backup operation
       on your database when the RMU Restore Only_Root command
       completes. Oracle Corporation recommends that you define a
       new after-image journal configuration with the RMU Restore
       Only_Root command by using either the After_Journal or the
       Aij_Options qualifier. This action ensures that the new
       .aij file can be rolled forward in the event that another
       database restore operation becomes necessary.
Close Help