END BACKUP
Returns
the database to normal operation after an online backup.
SYNTAX
DESCRIPTION
The END
BACKUP command ends the backup state DBMaker places the database in during
an online backup. To execute the END BACKUP command, you must have DBA
or SYSADM security privileges.
To perform
an online full backup, you can start the database in NON-BACKUP, BACKUP-DATA,
or BACKUP-DATA-AND-BLOB mode. To begin the backup, you issue the BEGIN
BACKUP command. Use operating system commands or backup utilities to back
up all data and BLOB files to the backup device. After these files have
been backed up, issue the END BACKUP DATAFILE command. Then use operating
system command or backup utilities to back up all journal files. After
these files have been backed up, issue the END BACKUP JOURNAL command
to complete the backup and return the database to normal operation. Using
an online full backup, you can restore a database from the point in time
the END BACKUP DATAFILE command was executed to the point in time the
currently active journal file was copied.
To perform
an online incremental backup, you must start the database in either BACKUP-DATA
or BACKUP-DATA-AND-BLOB mode. To begin the backup, you issue the BEGIN
INCREMENTAL BACKUP command. DBMaker will list all journal files you need
to copy and a backup ID for each file. In an online incremental backup,
DBMaker will only back up journal files that have been used since the
last full online backup, excluding the currently active journal file.
Record the filename and backup ID of each file in a safe location; these
will be used if you restore you database. Use operating system commands
or backup utilities to back up the journal files in the list to the backup
device. After these journal files have been backed up, issue the END BACKUP
JOURNAL command to complete the backup and return the database to normal
operation. Using an online incremental backup, you can restore a database
from the point in time the END BACKUP DATAFILE command was executed in
the previous full backup, to the point in time the last committed transaction
was written to the last full journal file.
To perform
an online incremental backup to current, the database must have been started
in BACKUP-DATA or BACKUP-DATA-AND-BLOB mode. To begin the backup, you
issue the BEGIN INCREMENTAL BACKUP TO CURRENT command. DBMaker will list
all journal files you need to copy and a backup ID for each file. In an
online incremental backup to current, DBMaker will back up all journal
files that have been used since the last full online backup, including
the currently active journal file. Record the filename and backup ID of
each file in a safe location; these will be used if you restore you database.
Use operating system commands or backup utilities to back up the journal
files in the list to the backup device. After these journal files have
been backed up, issue the END BACKUP JOURNAL command to complete the backup
and return the database to normal operation. Using an online incremental
backup to current, you can restore a database from the point in time the
END BACKUP DATAFILE command was executed in the previous full backup,
to the point in time the currently active journal file was copied.
You can
abort an online backup at any time by issuing the ABORT BACKUP command.
(For more information, see the ABORT BACKUP command.) After you execute
the ABORT BACKUP command, you will not be able to use the files from this
backup to restore the database. You should delete these backup files so
they will not be confused with files from valid backups when you are restoring
your database.
EXAMPLE
The following
example shows the steps involved in a full online backup. To begin, you
issue the BEGIN BACKUP command to notify DBMaker that a full backup is
in progress. Then use operating system commands to copy all data and BLOB
files to the backup location. Once the files are copied, you issue the
END BACKUP DATAFILE command. Then use operating system commands to copy
all journal files to the backup location. Once the files are copied, you
issue the END BACKUP JOURNAL command. Following this command, the database
returns to normal operation.
BEGIN BACKUP
Copy data and BLOB files to backup location using OS commands
Change backup mode if desired
Abort the backup if desired
END BACKUP DATAFILE
Copy journal files to backup location using OS commands
Change the backup mode if desired
Abort the backup if desired
END BACKUP JOURNAL
|
The following
example shows the steps involved in an incremental online backup. To begin,
you issue the BEGIN INCREMENTAL BACKUP command to notify DBMaker that
an incremental backup is in progress. DBMaker will list all journal files
that you need to copy and a backup ID for each file. Use operating system
commands to copy these journal files to the backup location, and record
the backup ID for use during restoration. Once the files are copied, you
issue the END BACKUP JOURNAL command. Following this command, the database
returns to normal operation.
BEGIN INCREMENTAL BACKUP
Copy journal files to backup location using OS commands
Abort the backup if desired
END BACKUP JOURNAL
|
The following
example shows the steps involved in an incremental online backup that
backs up everything to the point in time the currently active journal
file is copied. To begin, you issue the BEGIN INCREMENTAL BACKUP TO CURRENT
command to notify DBMaker that an incremental backup to current is in
progress. DBMaker will list all journal files that you need to copy and
a backup ID for each file. Use operating system commands to copy these
journal files to the backup location, and record the backup ID for use
during restoration. Once the files are copied, you issue the END BACKUP
JOURNAL command. Following this command, the database returns to normal
operation.
BEGIN INCREMENTAL BACKUP TO CURRENT
Copy journal files to backup location using OS commands
Abort the backup if desired
END BACKUP JOURNAL
|
RELATED FUNCTIONS
<
DROP VIEW | Contents
| EXECUTE COMMAND >
|
