Allows you to close the current AIJ log server (ALS) output file for the specified database and open a new one. This allows you to see the current contents of the original ALS output file.
1 – Description
The RMU Server After_Journal Reopen_Output command allows you to reopen an ALS output file that was previously created with an RMU Server After_Journal Start command with the Output qualifier. (The ALS output file is opened for exclusive access by the ALS process.) Reopening the output file results in the current output file being closed and a new output file being created. The new output file has the same file name as the original output file, but its version number is incremented by one. The ALS is an optional process that flushes log data to the after-image journal (.aij) file. All database servers deposit transaction log data in a cache located in the database global section. If the ALS is active, it continuously flushes the log data to disk. Otherwise, server processes might block temporarily if the cache in the global section is full.
2 – Format
(B)0[mRMU/Server After_Journal Reopen_Output root-file-spec
3 – Parameters
3.1 – root-file-spec
Specifies the database root file for which you want to reopen the ALS output file.
4 – Usage Notes
o To use the RMU Server After_Journal Reopen_Output command for a database, you must have RMU$OPEN privilege in the root file access control list (ACL) for the database or the OpenVMS WORLD privilege. o To issue the RMU Server After_Journal Reopen_Output command successfully, the database must be opened. Other users can be attached to the database when this command is issued. o To determine whether the ALS is running, use the RMU Show Users command.
5 – Examples
Example 1 In the following example the first Oracle RMU command starts the log server and specifies an output file. The second Oracle RMU command reopens the ALS output file, so you can view the data that is contained in the ALS output file so far. $ RMU/SERVER AFTER_JOURNAL START MF_PERSONNEL/OUT=ALS $ ! Database updates occur $ RMU/SERVER AFTER_JOURNAL REOPEN_OUTPUT MF_PERSONNEL $ ! View the ALS.OUT;-1 file: $ TYPE ALS.OUT;-1 -------------------------------------------------------------------- 16-OCT-1995 13:02:05.21 - Oracle Rdb V7.0-00 database utility started --------------------------------------------------------------------- . . .