VMS Help  —  RMU72  Set  Logminer
    Allows you to change the LogMiner state of a database.

1  –  Description 

    Use this command to enable or disable LogMiner operations on an
    Oracle Rdb database. When LogMiner is enabled, the Oracle Rdb
    database software writes additional information to the after-
    image journal file when records are added, modified, and deleted
    from the database. This information is used during the unload
    operation.

2  –  Format 

  (B)0 RMU/Set Logminer root-file-spec

  Command Qualifiers           x  Defaults
                               x
  /Continuous                  x  /NoContinuous
  /Disable                     x  See description
  /Enable                      x  See description
  /[No]Log                     x  Current DCL verify value

3  –  Parameters

3.1  –  root-file-spec 

    The root file specification of the database. The default file
    extension is .rdb.

4  –  Command Qualifiers

4.1  –  Continuous 

    Continuous
    Nocontinuous

    Enables the database for the Continuous LogMiner feature
    when used in conjunction with the Enable qualifier. Use the
    NoContinuous qualifier with the Enable qualifier to disable use
    of the Continuous LogMiner feature.

    The RMU Set Logminer /Disable command explicitly disables
    the Continuous LogMiner feature as well as the base LogMiner
    functionality. To enable the Continuous LogMiner feature again,
    the entire RMU Set Logminer /Enable /Continuous command must be
    used.

4.2  –  Disable 

    Specifies that LogMiner operations are to be disabled for the
    database. When LogMiner is disabled, the Oracle Rdb software does
    not journal information required for LogMiner operations. When
    LogMiner is disabled for a database, the RMU Unload After_Journal
    command is not functional on that database.

4.3  –  Enable 

    Specifies that LogMiner operations are to be enabled for the
    database. When LogMiner is enabled, the Oracle Rdb database
    software logs additional information to the after-image journal
    file. This information allows LogMiner to extract records. The
    database must already have after-image journaling enabled.

4.4  –  Log 

    Log
    Nolog

    Specifies that the setting of the LogMiner state for the database
    be reported to SYS$OUTPUT. The default is the setting of the DCL
    VERIFY flag, which is controlled by the DCL SET VERIFY command.

5  –  Usage Notes 

    o  To use the RMU Set Logminer command, you must have the
       RMU$BACKUP, RMU$RESTORE, or RMU$ALTER privilege in the root
       file access control list (ACL) for the database or the OpenVMS
       SYSPRV or BYPASS privilege.

    o  The RMU Set Logminer command requires offline access to the
       database. The database must be closed and no other users may
       be accessing the database.

    o  Execute a full database backup operation after issuing an
       RMU Set Logminer command that displays the RMU-W-DOFULLBCK
       warning message. Immediately after enabling LogMiner, you
       should perform a database after-image journal backup using the
       RMU Backup After_Journal command.

6  –  Examples 

    Example 1

    The following example enables a database for LogMiner for Rdb
    operation.

    $ RMU /SET LOGMINER /ENABLE OLTPDB.RDB
Close Help