VMS Help  —  ORACLE_RDB72, Information Tables, RDB$DATABASE_JOURNAL
    Displays information about the default journal information.

                                Data
    Column Name                 Type      Description

    RDB$CONDITION               integer   AIJ status
    RDB$DEFAULT_ALLOCATION      integer   Default allocation in
                                          blocks
    RDB$DEFAULT_EXTENT          integer   Default extension in blocks
    RDB$CURRENT_BACKUP_         integer   Backup sequence number
    SEQUENCE
    RDB$CURR_RECOVERY_          integer   Recovery sequence number
    SEQUENCE
    RDB$DATABASE_BACKUP_        integer   Database backup sequence
    SEQUENCE                              number
    RDB$ALLOCATION              integer   Number of allocated AIJ
                                          file blocks
    RDB$SHUTDOWN_TIME_MIN       integer   Shutdown time in minutes
    RDB$OPERATOR_CLASSES        integer   Operator class
    RDB$FLAGS                   integer   Flags
    RDB$DEFAULT_BACKUP_         char(255) Default backup file name
    FILENAME
    RDB$CACHE_FILENAME          char(255) Cache file name
    RDB$STANDBY_FILENAME        char(255) Standby database file name
    RDB$SERVER_NAME             char(31)  Server name
    RDB$BACKUP_EDIT_STRING      varchar(25Backup editname file
    RDB$REMOTE_NODE_NAME        char(31)  Remote node name
    RDB$CUR_ACTIVE_AIJ          integer   Current active AIJ journal
                                          index
    RDB$MASTER_FILENAME         char(255) When database replication
                                          is active on the standby
                                          database, this field
                                          contains the file name
                                          of the master database

1  –  RDB$FLAGS

    Represents flags for RDB$DATABASE_JOURNAL information table.

    Bit
    Position   Description

    0          Journaling is enabled
    1          Overwrite is enabled
    2          Backup mode
    3          New journal version
    4          ABS uses quiet-point AIJ backup
    5          Replicated as master
    6          Replicated as standby
    7          Master replication database
    8          Database replication online
    9          Hot Standby quiet-point
    10         Hot Standby is enabled
    11         Database changes made when AIJ disabled
    12         One or more journals overwritten
    13         Hard data loss resulted from fail over
    14         Full quiet-point AIJ backup required
Close Help