Backing up Database

About Backing up the Database

The Backup option provides the function of a full database backup.

This task explains the procedure to backing up the database:

  1. Create a backup directory of any name with permissions set to 770. This directory should be owned by a user belonging to the Explore instance owner user group. For example,

    $ mkdir /i2inst/i2inst1/backup
    $ chmod 770 /i2inst/i2inst1/backup

  2. Ensure that all the connections to your database are closed before you take backup.

  3. Login as aspadm and run edm.sh from $EDS_HOME/bin directory. For additional information, see Using CES Database Manager.

  4. From the EDM main window, select a database that is to be backed up.

  5. Select Administration > Backup Database option.

    The Backup Database window appears
    .

     

    Name Description

    Instance Name

    The name of the instance appears.

    Database Name

    The name of the database for which a backup is to be taken appears.

    Backup Directory

    The target directory where the database backup is to be stored. The default path to this directory appears but you can click Browse and choose a different directory/path.
    If the directory does not exist or if the user does not have write permissions on the directory, an error message appears.

     

  6. Click Backup to start the database backup. Once the backup operation is completed, a message indicating that the backup has been successfully completed appears.

  7. Click Cancel to return to the EDM main menu.

    The backup operation creates several backup files in the specified backup directory. These files should not be touched as they will be used while restoring the database. All the files of a single backup will have the same timestamp and will have suffixes to identify their order in the set.

    For example, a backup may result in these three files:
    ASPDB.0.i2inst6.NODE0000.CATN0000.20020219135222.001
    ASPDB.0.i2inst6.NODE0000.CATN0000.20020219135222.002
    ASPDB.0.i2inst6.NODE0000.CATN0000.20020219135222.003

    Each backup file name consists of a concatenation of several units of information separated by periods that is,
    dbname.type.instance.nodexxxx.catnxxxx.yyyymmddhhmmss.seq
    Where,
    zdbname is a 1 to 8 character database alias.
    type is the type of backup taken (0 for full database or 3 for table space level backup).
    instance is a 1 to 8 character database instance name.
    nodexxxx is the number of the node.
    catnxxxx is the number of the catalog node for the database.
    yyyymmdd Date (year month day).
    hhmmss Time (hour minute second).
    seq A file extension consisting of a 3-digit sequence number.

Note:  To understand how to restore your database, refer to CES Installation Guide : Restoring the Database.