VMS Help  —  RMU72  Hot Standby, Replicate After Journal Commands, Reopen Output
    Closes the current informational file and reopens it as a new
    file. You can enter this command on either the master database
    node (to reopen the output file that records LCS information) or
    the standby database node (to reopen the output file that records
    LRS information).

1  –  Description

    The Hot Standby software dynamically and transparently switches
    from writing to the original output file to the new file. There
    is no need to stop or interrupt database replication operations
    during the transition to the new output file.

    The Replicate After_Journal Reopen_Output command performs the
    following steps to reopen the output file:

    1. Closes the current output file in which information about
       replication operations is recorded.

    2. Reopens the output file by opening a new file using the
       original output file name. On OpenVMS systems, the Hot
       Standby software opens a new output file using the originally
       specified file name and a new version number. Thus, you can
       view the original output file by specifying the older version
       number. If disk space is a problem, relocate the old output
       file to another disk.

    You can enter the Replicate After_Journal Reopen_Output command
    on either the master or standby node as follows:

    Enter the
    command . . .          To reopen the output file for the . . .

    On the master          LCS server on the master database
    database node

    On the standby         LRS server on the standby database
    database node

    You must explicitly enable the ability to write replication
    startup information to an output file by including the Output
    qualifier when you start replication operations (see the
    Replicate_After_Journal_Commands Start command for more
    information), or by specifying the BIND_ALS_OUTPUT_FILE, BIND_
    HOT_OUTPUT_FILE, BIND_LCS_OUTPUT_FILE, or BIND_LRS_OUTPUT_FILE
    logical name.

    The Replicate After_Journal Reopen_Output command is useful when:

    o  The output file becomes too large

       For example, as the output file grows over time, you might run
       out of disk space or notice that the database performance is
       slow. You can use the Replicate After_Journal Reopen_Output
       command to free up space on the disk. Once the new output
       file is open, you should relocate the old output file to a new
       location or delete the file.

       If the disk that contains the output file becomes full, the
       Hot Standby software stops writing information to the file
       (and on OpenVMS systems, a message is sent to the system
       operator). Note that replication operations continue, even
       when write I/O to the output file stops.

    o  You want to view the currently open output file

       By using the Replicate After_Journal Reopen_Output command,
       you can capture a snapshot of the output file and examine
       replication operations without interrupting processing. You
       can also view the contents of the current output file using
       the Type command at the OpenVMS system prompt.

                                      NOTE

          You cannot use the Replicate After_Journal Reopen_Output
          command to change the size or location of the output
          file; the command is intended to create a new version of
          an existing output file.

    o  You want to open an output file for a server process that is
       actively performing replication operations

       Defining a logical name is useful if you omitted the Output
       qualifier when you entered the Replicate After_Journal Start
       command to start replication. You can define a logical name
       to specify an output file while replication operations are
       active. This can be done by defining the appropriate logical
       name, and then invoking the Replicate After_Journal Reopen_
       Output command. This allows you to create an output file so
       the server can start writing to the file. The advantage to
       defining a logical name is that you do not need to stop and
       restart the server.

       Reference: See the Output qualifier discussion under the
       Replicate_After_Journal_Commands Start Help topic.

2  –  Format

  (B)0RMU/Replicate After_Journal Reopen_Output database-rootfile

3  –  Parameters

3.1  –  database-rootfile

    Specifies the name of the master or standby database root file.

4  –  Usage Notes

    o  To write replication information to an output file, specify
       the Log and Output qualifiers on the Replicate After_Journal
       Start command.

       If you enter the Replicate After_Journal Reopen_Output command
       on a node where logging is not enabled, the Hot Standby
       software ignores the command; it does not return an error
       message if the Replicate After_Journal Reopen_Output command
       does not find an output file.

    o  The Replicate After_Journal Reopen_Output command is
       applicable only to the files that record activities for the
       LCS process or the LRS process. To reopen or view the output
       file that records information about the ALS process, use the
       RMU Server After_Journal Reopen_Output command.

       Reference: For more information about displaying ALS
       information, refer to the Oracle RMU Reference Manual.

5  –  Examples

    Example 1

    The following command example shows how to reopen an output file:

    $ RMU /REPLICATE AFTER_JOURNAL REOPEN_OUTPUT mf_personnel.rdb
Close Help