Top
ETERNUS SF AdvancedCopy Manager V15.3 Operation Guide
ETERNUS

11.1.2 Making a package backup of databases

This section describes the function of making a backup of management information (e.g., databases) from just one Managed Server or Management Server.

With a package backup of management information, you can make a backup of management information for all Managed Servers and Management Server from just one Managed Server or Management Server. Executing a package backup of management information runs backup commands (making backups of backup management resources and databases) for the databases of other Managed Servers and Management Server, and collects the backup data and management information created by these backup commands.

The server on which you can execute a package backup of management information is called the "package-backup-of-the-management-information execution server". The servers whose data is to be backed up are called the "package-backup-of-the-management-information target servers".

Figure 11.1 Management Server and Managed Server

Example

Assume that the package backup of management information function has been used to back up the management information on a Management Server, Managed Server A, and Managed Server B onto Managed Server B in the diagram above. In this case, Managed Server B is the backup execution server. The Management Server, Managed Server A, and Managed Server B are the backup target servers. That is, Managed Server B operates as both the backup execution server and backup target server.

The following table shows the types of management information that is handled in a package backup of management information.

Table 11.4 Types of management information backed up by package backup of management information

Function

Type of data

Database

  • Database

Registry

  • Registry

Backup management

  • Backup management list, or backup management list and recovery control file

  • Pre-processing and post-processing scripts

  • Transaction volume locking specification file for backups

  • Backup volume locking specification file for backups

  • Backup-restored volume locking specification file

Replication management

  • Pre-processing and post-processing scripts

  • Copy-source volume locking specification file

  • Copy-destination volume locking specification file

Package backup of management information

  • Policy file

Note

  • Managed Server management information created by Softek AdvancedCopy Manager Version 10.3 (V10.0L40) or earlier cannot be handled by the package backup of management information function. To create a backup, back up each management information component individually as described in "Maintaining a database" in the ETERNUS SF AdvancedCopy Manager Operation Guide applicable to the Managed Server.

  • In an environment where the Managed Server with IPv4 address and the Managed Server with IPv6 address coexist, register the Management Server as a "package-backup-of-the-management-information execution server".


11.1.2.1 Preliminaries

Before creating a package backup of management information, you must perform the following:

  1. Determine the management information package backup target servers and the types of management information to be backed up.

  2. Determine the management information package backup execution server.

  3. Create a directory where the management information package backup execution server will store the backup data. The size of the directory must not be less than the total of the following sizes:

    • The required size for a database is the size of the database backup data multiplied by 1.2.
      For the backup data size, refer to "Maintaining a database" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the Management Server.

    • The required size for the registries is the total of the data sizes of the registry backup data on the management information package backup target servers.
      For the backup data size, refer to "Maintaining a database" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the management information package backup target server.

    • The required size for backup management is the total of the sizes below for each management information package backup target server:
      For the size of each component of backup data, refer to "Maintaining a database" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the management information package backup target server.

      • Size of the backup data for the backup management lists (size of the backup data for the backup management lists plus the size of the backup data for the recovery control files) multiplied by 1.2

      • Size of the pre-processing and post-processing scripts for backup management

      • Size of the transaction volume locking specification file for backups for backup management

      • Size of the backup volume locking specification file for backups for backup management

      • Size of the backup-restored volume locking specification file for backup management

    • The required size for replication management is the total of the following sizes for each management information package backup target server:

      • Size of the pre-processing and post-processing scripts for replication management

      • Size of the copy-source volume locking specification file for replication management

      • Size of the copy-destination volume locking specification file for replication management

  4. Check the size of the working directory for the management information package backup target servers (or the shared disk for shared data for AdvancedCopy Manager in a clustered system). The sizes described below are needed only when a package backup of management information is being created. Use the largest value of the sizes of the databases to be backed up from the management information package backup target servers. The required sizes are as follows:

    • The required size for the databases is the size of the database backup data multiplied by 2.2.
      For the backup data size, refer to "Maintaining a database" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the Management Server.

    • The required size for backup management is the size of the backup data for the backup management lists (size of the backup data for the backup management lists plus the size of the backup data for the recovery control files) multiplied by 2.2.
      For the backup data size, refer to "Maintaining a database" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the management information package backup target server.

    • The working directory does not require any space for registry, replication management, and policy file backups.

  5. Execute the stgmgrinfoset command as described in stgmgrinfoset (Management information package backup server registration/deletion command), on the management information package backup execution server (determined in step 2).

  6. Create a policy file on the management information package backup execution server.

    Table 11.5 Management information package backup execution server and policy file paths

    Management information package backup execution server

    Policy file path

    OS

    Operation type

    Windows

    Non-cluster

    <Environment directory>\etc\stgmgrinfo_policy.ini

    Cluster

    <AdvancedCopy-Manager-shared-data>:\etc\opt\swstorage\etc\stgmgrinfo_policy.ini

    Solaris,
    Linux,
    HP-UX,
    AIX

    Non-cluster

    /etc/opt/FJSVswstf/stgmgrinfo_policy.ini

    Cluster

    /etc/opt/FJSVswstf/<logical-node-name>/stgmgrinfo_policy.ini

Note

  • Do not specify more than one Managed Server as a management information package backup execution server.

  • When this server is used for executing transactions on the Managed Server in a clustered system, create a directory for storing backup data on a shared disk.

  • For databases and backup management, backup commands are executed on the corresponding management information package backup target servers. In addition, for database backups and backup management (ie, backup management lists) backups, a temporary capacity that is approximately 2.2 times greater than the total size of the backups is required to save the backup data in an archive log file.

Table 11.6 Policy file format

Section
name

Key
name

Description
(*1)

Whether specifiable on

Management
Server

Managed
Server

Server
name

DBData

Specifies whether to make a backup of the database.

Yes: Make a backup of the database.
No: Do not make a backup of the database.

A

C

BkupData

Specifies whether to make a backup of the backup management.

Yes: Make a backup of the backup management.
No: Do not make a backup of the backup management.

B

B

ReplData

Specifies whether to make a backup of the replication management.

Yes: Make a backup of the replication management.
No: Do not make a backup of the replication management.

B

B

A: Specifiable
B: Specifiable only when the applicable function is operating on the server
C: Unspecifiable

*1: If this key is not specified or if "Yes" is not in the form "Y" (uppercase) + "es" (lowercase), then "No" is set.

Example

Set up a policy file as follows:

  • The Management Server named ACMMGR creates backups for the database and backup management.

  • The Managed Server named ACMAGT1 creates backups for backup management.

  • The Managed Server named ACMAGT2 creates backups for replication management.

    [ACMMGR]
    DBData=Yes
    BkupData=Yes
    [ACMAGT1]
    BkupData=Yes
    [ACMAGT2]
    ReplData=Yes

Note

  • Create a policy file only if it will be used.

  • The policy file cannot include any settings for backups of registries and of the policy file for management information package backup.


11.1.2.2 Backup operations

Executing stgmgrinfobkup (Management information package backup command) on the management information package backup execution server stores the backup data in the directory under the following structure:

Table 11.7 Directory structure for execution of management information package backup and data types

Directory

Data type

*1

Server
name

DBData

  • Database

RegiData

  • Registry

BkupData

FJSVswsts

  • Backup management list, or backup management list and recovery control file

Scripts

  • Pre-processing and post-processing scripts for backup management

data

  • Transaction volume locking specification file for backups, for backup management

  • Backup volume locking specification file for backups, for backup management

  • Backup-restored volume locking specification file for backups, for backup management

ReplData

Scripts

  • Pre-processing and post-processing scripts for replication management

data

  • Copy-source volume locking specification file for replication management

  • Copy-destination volume locking specification file for replication management

MgrInfoData

  • Policy file for management information package backup

*1 is the backup data storage directory specified by stgmgrinfoset (Management information package backup server registration/deletion command).

Example

When *1 is D:\ACMBkupData and the server name is ACMAGT1, the pre-processing and post-processing scripts for backup management are located in the following directory:

D:\ACMBkupData\ACMAGT1\BkupData\Scripts

Initial operations

The policy file backup operations are described below. Backup of registries which are not included in the backup targets when a policy file is used to perform backup are also detailed. The initial operations are as follows:

  1. Execute stgmgrinfobkup (Management information package backup command) on the management information package backup execution server to make backups of the registries on all of the Managed Server.

  2. Execute stgmgrinfobkup (Management information package backup command) on the management information package backup execution server to make a backup of the policy file.


Normal-use operations

Execute stgmgrinfobkup (Management information package backup command) on the management information package backup execution server when you need to make backups of the target data.
For the timing of the backups, refer to "Maintaining a database" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the applicable operating system.


Operations when a server is added or deleted

Operations when server added
  1. On the management information package backup execution server, set up a policy for the added Managed Server in the policy file.

  2. Execute stgmgrinfobkup (Management information package backup command) on the management information package backup execution server to make a backup of the registry of the added Managed Server.

  3. Execute stgmgrinfobkup (Management information package backup command) on the management information package backup execution server to make a backup of the policy file.

Operations when server deleted
  1. On the management information package backup execution server, delete the information about the Managed Server that was deleted from the policy file.

  2. In the backup data directory on the management information package backup execution server, delete the directory containing the name of the deleted Managed Server.

  3. Execute stgmgrinfobkup (Management information package backup command) on the management information package backup execution server to make a backup of the policy file.


Operations when a server name is changed

  1. On the management information package backup execution server, delete the information for the Managed Server from the policy file.

  2. In the backup data directory on the management information package backup execution server, delete the directory containing the name of the Managed Server.

  3. On the management information package backup execution server, set up a policy for the renamed Managed Server in the policy file.

  4. Execute stgmgrinfobkup (Management information package backup command) on the management information package backup execution server to make a backup of the registry of the renamed Managed Server.

  5. Execute stgmgrinfobkup (Management information package backup command) on the management information package backup execution server to make a backup of the policy file.


11.1.2.3 Restoration operations

This section describes how to use the backup data created by stgmgrinfobkup (Management information package backup command) to execute restoration.
Perform the operations below as a root user or with an account that belongs to the Administrators group.


Restoring a registry

  1. Execute stgmgrinfoset (Management information package backup server registration/deletion command) on the management information package backup execution server to determine which directory contains the backup data.

  2. On the management information package backup execution server, copy the registry backup to the following directory:

    Windows version:
    <Directory-determined-in-step1>\<server-whose-registry-to-be-restored>\RegiData
    Solaris, Linux, HP-UX or AIX version:
    <Directory-determined-in-step1>/<server-whose-registry-to-be-restored>/RegiData
  3. Transfer the registry backup that was copied in step 2 to the target server in binary mode.

  4. Restore the registry on the server. For details on restoring a registry, refer to "Restoring a registry" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the target server.


Restoring a database

  1. Execute stgmgrinfoset (Management information package backup server registration/deletion command) on the management information package backup execution server to determine which directory contains the backup data.

  2. On the management information package backup execution server, copy the backup of the database to the following directory:

    Windows version:
    <Directory-determined-in-step1>\<management-server-name>\RegiData
    Solaris, Linux, HP-UX or AIX version:
    <Directory-determined-in-step1>/<management-server-name>/RegiData
  3. Transfer the backup of the database that was copied in step 2 to the Management Server in binary mode.

  4. On the Management Server, expand the database backup transferred in step 3.

    • On the Windows version Management Server:

      Expand the database backup using the stgarcext (Backup data expansion command) in the ETERNUS SF AdvancedCopy Manager Operation Guide (for Windows).

    • On a Solaris/Linux version Management Server:

      Expand the database backup by using the tar command supported by the operating system.

  5. On the Management Server, restore the database.

    For details on restoring a database, refer to "Restoring a database" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the Management Server.

    • The backup data storage directory specified for database restoration is the directory expanded in step 4.

    • Specify "RDB Dictionary, DSI(LOAD Mode)" for the Windows version as a recovery mode. Specify "0" for other versions.


Restoring a replication management list

  1. Perform the procedure of "Restoring a database" to restore a database.

    If you have performed it, this step is not needed.

  2. On the target server, execute the swsrprecoverres (Resource adjustment command) with the -r option.

    For details on the command, refer to "swsrprecoverres (Resource adjustment command)" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the target server.


Restoring a backup management list, or backup management list and recovery control file

  1. Execute stgmgrinfoset (Management information package backup server registration/deletion command) on the management information package backup execution server to determine which directory contains the backup data.

  2. On this server, copy the backup of the backup management list or the backups of the backup management list and the recovery control file to the following directory:

    Windows version:
    <Directory-determined-in-step1>\<server-whose-list/file-to-be-restored>\BkupData\FJSVswsts
    Solaris, Linux, HP-UX or AIX version:
    <Directory-determined-in-step1>/<server-whose-list/file-to-be-restored>/BkupData/FJSVswsts
  3. Transfer the backup of the backup management list or the backups of the backup management list and the recovery control file copied in step 2 to the target server in binary mode.

  4. Expand the backup of the backup management list or the backups of the backup management list and recovery control file transferred in step 3 on the target server.

    • On a Windows version server:

      Expand the backup of the backup management list using the stgarcext (Backup data expansion command) in the ETERNUS SF AdvancedCopy Manager Operation Guide (for Windows).

    • On a Solaris/Linux/HP-UX/AIX version server:

      Expand the backup of the backup management list or the backups of the backup management list and recovery control file by using the tar command supported by the operating system.

  5. Restore the backup management list, or the backup management list and recovery control file on the target server. For details on restoring, refer to "Restoring a backup management list" or "Restoring a backup management list and recovery control file" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the target server. The Backup-Directory specified in the resource restoration command is the directory expanded in step 4.


Restoring the backup management pre-processing/post-processing scripts

  1. Execute stgmgrinfoset (Management information package backup server registration/deletion command) on the management information package backup execution server to determine which directory contains the backup data.

  2. On this server, copy the backups of the backup management pre-processing/post-processing scripts for backup management to the following directory:

    Windows version:
    <Directory-determined-in-step1>\<server-whose-scripts-to-be-restored>\BkupData\Scripts
    Solaris, Linux, HP-UX or AIX version:
    <Directory-determined-in-step1>/<server-whose-scripts-to-be-restored>/BkupData/Scripts
  3. Transfer the backups of the backup management pre-processing/post-processing scripts copied in step 2 to the target server in binary mode.

  4. Transfer the backups of the backup management pre-processing/post-processing scripts copied in step 3 to the directory in which the scripts will be executed on the target server in binary mode. For the directory in which the pre-processing and post-processing scripts for backup management are executed (that is, the directory to which the scripts are to be copied), refer to "Pre-processing and post-processing for backup/restoration" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the target server.

  5. On a Solaris/Linux/UP-UX/AIX-version server, change the access permission assigned to the pre-processing and post-processing scripts for backup management copied in step 4 on the target server by using the chmod command supported by the operating system. Set execution permission for the root user, which is the owner.


Restoring locking specification files for backup management

  1. Execute stgmgrinfoset (Management information package backup server registration/deletion command) on the management information package backup execution server to determine which directory contains the backup data.

  2. On this server, copy the backups of the locking specification files for backup management to the following directory:

    Windows version:
    <Directory-determined-in-step1>\<server-whose-files-to-be-restored>\BkupData\data
    Solaris, Linux, HP-UX or AIX version:
    <Directory-determined-in-step1>/<server-whose-files-to-be-restored>/BkupData/data
  3. Transfer the backups of the locking specification files for backup management copied in step 2 to the target server in binary mode.

  4. Copy the backups of the locking specification files for backup management transferred in step 3 to the target server. For the directory in which the locking specification files for backup management are used (that is, the directory to which the files are to be copied), refer to "Pre-processing and Post-processing of Backup and Restoration" in the ETERNUS SF AdvancedCopy Manager Operation Guide (for Windows).


Restoring pre-processing and post-processing scripts for replication management

  1. Execute stgmgrinfoset (Management information package backup server registration/deletion command) on the management information package backup execution server to determine which directory contains the backup data.

  2. On this server, copy the backups of the pre-processing and post-processing scripts for replication management to the following directory:

    Windows version:
    <Directory-determined-in-step1>\<server-whose-scripts-to-be-restored>\ReplData\Scripts
    Solaris, Linux, HP-UX or AIX version:
    <Directory-determined-in-step1>/<server-whose-scripts-to-be-restored>/ReplData/Scripts
  3. Transfer the backups of the pre-processing and post-processing scripts for replication management copied in step 2 to the target server in binary mode.

  4. Copy the backups of the pre-processing and post-processing scripts for replication management transferred in step 3 to the directory in which the scripts will be executed on the target server. For the directory in which the pre-processing and post-processing scripts for replication management are executed (that is, the directory to which the scripts are to be copied), refer to "Appendix C Pre-processing and Post-processing of Replication" in the ETERNUS SF AdvancedCopy Manager Operation Guide for the operating system running on the target server.

  5. On a Solaris/Linux/UP-UX/AIX-version server, change the access permission assigned to the pre-processing and post-processing scripts copied in step 4 on the target server by using the chmod command supported by the operating system. Set execution permission for the root user, which is the owner.


Restoring locking specification files for replication management

  1. Execute stgmgrinfoset (Management information package backup server registration/deletion command) on the management information package backup execution server to determine which directory contains the backup data.

  2. On this server, copy the backups of the locking specification files for replication management to the following directory:

    Windows version:
    <Directory-determined-in-step1>\<server-whose-files-to-be-restored>\ReplData\data
    Solaris, Linux, HP-UX or AIX version:
    <Directory-determined-in-step1>/<server-whose-files-to-be-restored>/ReplData/data
  3. Transfer the backups of the locking specification files for replication management copied in step 2 to the target server in binary mode.

  4. Copy the backups of the locking specification files for replication management transferred in step 3 to the target server. For the directory in which the locking specification files for replication management are used (that is, the directory to which the files are to be copied), refer to "Pre-processing and Post-processing of Replication" in the ETERNUS SF AdvancedCopy Manager Operation Guide (for Windows).


Restoring a policy file for management information package backup

  1. Execute stgmgrinfoset (Management information package backup server registration/deletion command) on the management information package backup execution server to determine which directory contains the backup data.

  2. On this server, copy the policy file located in the following directory to the policy file for the management information package backup command:

    Windows version:
    <Directory-determined-in-step1>\<server-whose-file-to-be-restored>\MgrInfoData
    Solaris, Linux, HP-UX or AIX version:
    <Directory-determined-in-step1>/<server-whose-file-to-be-restored>/MgrInfoData

    For information on the directory for the policy file for the management information package backup command, refer to step 6 in "11.1.2.1 Preliminaries".