Saving the Live Database

Note: This procedure is carried out from the live database.

This procedure enables you to save the live database to tape. Before performing the save, tlmenu switches the clean log and gives you the option of archiving it to tape.

Caution

tlmenu does not support archiving of multiple clean logs. The clean log archive procedure only dumps one clean log per tape. A separate tape must be used to archive each log file.

Procedure

  1. Select option 8 on the Routine Maintenance menu. A message is then displayed describing the purpose of the procedure and prompting you to confirm that you wish to continue. When you enter y  at the confirmation prompt, tlmenu continues, as follows:
  2. If Transaction Logging is inactive, tlmenu asks if you want to continue with the save. You may wish to start logging before continuing with the save, in which case, enter n. This aborts the procedure. You can then start logging by selecting option 2 on the Configuration and Setup menu.

    If you wish to continue with Transaction Logging inactive, enter y. tlmenu then continues by asking if you want to suppress the VERIFY-SAVE. Go to step 7.

  3. If Transaction Logging is active, you are asked to specify the clean log to switch to, before performing the save. A menu similar to the following is displayed:

    Current Clean Log is : CLOG990816-01
    
    Switch to:
    
    1.  Another Clean Log for today (CLOG990816-02)
    2.  Next day's Clean Log (CLOG990817-01)
    3.  Clean Log for named day or date
    4.  A named Clean Log
    
    Enter option (1-4) : _

    Select the option you require. See Clean Log Menu Options for an explanation of menu options.

    Having selected the clean log name, you are asked for confirmation that you want to switch to the specified clean log. Enter y  to confirm that you want to continue with the switch.

  4. You are then given the option to archive the previous clean log with the prompt:

    Do you want to archive previous Clean Log (y/n/q) :

    Enter y  to archive the previous clean log. Entering n  omits the archive procedure and takes you directly to the Suppress VERIFY-SAVE  prompt shown in step 7.

  5. A list of tape units currently configured on the database is displayed, showing their status. You are then prompted to select one to carry out the archive.

    Select an available tape device number to archive the clean log.

  6. Having entered the tape device number or entered n  to the archive option (step 3), you are then prompted to set up tape parameters for the save. First you are asked:

    Do you want to suppress the VERIFY-SAVE following 
    the Save (y/n/q) ? :

    Caution

    The integrity of the save cannot be guaranteed if you suppress VERIFY-SAVE.

    Enter n  to enforce verification and y  to omit verification. If you enter y, a warning prompt is displayed asking you to confirm that you wish to carry out the save without verifying it.

  7. Having made the appropriate responses:

    • If the Physical Save or dbsave option was selected when defining the backup method used by tlmenu, go to step 9.
    • If the FILE-SAVE method was selected, you are first prompted to set up tape parameters for the FILE-SAVE. You must respond to each prompt to move on to the next one. The sequence of prompts is, as follows:

      Will FILE-SAVE be multi-reel, if unsure select yes (y/n/q) ? : 

      Note: If you enter y, you will be prompted for multiple tape units during this FILE-SAVE setup sequence.

      Enter tape record block length (if other than 16000) :
      The following tapes are available on the local database:
      
                             Tape Unit Status
      
      Unit   Type   Status      Port    Channel  Assigned   Assigned Buffs  Reel
      number                    number  name     blocksize  density
      
       1     QIC    Available   
       2     8mm    Available   
      
      Enter tape unit desired :
      Enter tape density (if other than Device Default) :
      Enter tape label if desired :
  8. You are then prompted to specify the time for the save to start:

    Enter start time for Save (hh:mm) or return for immediate start :

    Enter the time in the format hh:mm at which you want the save to start or press return to start immediately.

    • If Transaction Logging is inactive, go to step 11.
    • If Transaction Logging is active, a new clean log is created and logging is switched to the new clean log.

      Once the clean log switch is complete, if you did not request the previous clean log to be archived, tlmenu continues with the save as described in step 10.

      If you did request the previous clean log to be archived, you are prompted to mount the tape for the archive.

      Mount write enabled tape on LOCAL tape unit for Clean Log archive.
      
      Are you ready to continue (y/n/q) ?

      Ensure that the tape is loaded and the tape unit is on-line, then enter y. tlmenu logs on to the database and executes tape operations to dump the clean log and verify the archived log.

      Once the archive tape is verified you are asked if you want to remove the clean log from disk.

      Delete Clean Log clog_name from Disk (y/n/q) ? :

      Enter y  to remove the archived clean log from disk.

      Note: An error condition occurring during the saving or verification of the clean log, will display the message:

      Warning : Clean Log archive / verify failed.
      Do you want to retry (y/n/q)?:

      Enter y  to retry the archive/verify procedure, or n  to return to the Routine Maintenance menu.

    You are then asked to confirm that you want to start the save.

    • For a FILE-SAVE, a message similar to the following is displayed, specifying the tape setup parameters.

      About to start the FILE-SAVE on local tape unit(s) n,
      using tape record block length nnnnn,
      tape density DEFAULT, tape label file-save,
      with a start time of hh:mm.
      
      Are you ready to start the Save (y/n/q) ? :
    • For a dbsave the following message is displayed:

      About to start dbsave with a start time of hh:mm
      
      Are you ready to start the Save (y/n/q) ? :

    Enter y  to start the save. The save is then executed at the specified start time and the tape is verified if this option was selected. You are then returned to the Routine Maintenance menu.

Go to top button