 |
-
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
-
Ensure that all the connections to your database are
closed before you take backup.
-
Login as aspadm and run edm.sh
from $EDS_HOME/bin directory. For additional information,
see Using CES Database Manager.
-
From the EDM main window, select a database
that is to be backed up.
-
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.
|
-
Click Backup to start the database backup.
Once the backup operation is completed, a message indicating that
the backup has been successfully completed appears.
-
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.
|