Cold – Warm – Mixed Restore

· Offline backup:Backup of database objects performed while the corresponding database or instance is shut down and unavailable to users. Also known as a cold backup.

· Offline restore: Automated restore that does not require the manual installation of an operating system. A bare metal recovery (BMR) is an offline restore.

· Online backup: Backup of database objects performed while the corresponding database or instance is running and available to users. Also known as a hot backup.

· Online restore: Restore operation that is performed from a NetWorker recover program. An online restore requires that the computer has been booted from an installed operating system. See also offline restore.

· Online indexes: Databases located on the NetWorker server that contain all the information pertaining to the client backups (client file index) and backup volumes (media index).

• For a DB2, Informix, MySQL, Oracle, or Sybase backup:

A. The nsrdasv program communicates with the appropriate database server or backup server to start a backup session through one of the following methods:

· DB2 API

· Informix onbar

· MySQL mysqlbackup executable

· Oracle RMAN executable

· Sybase Open Client/Server API

B. Each backup session created by the database server or backup server loads the NMDA shared library for the specific database to perform the backup.

Determining the Informix restore mode:

You can perform an Informix restore with the database server in one of three modes: cold, warm, or mixed. Each of the restore types consists of specific physical restores and logical restores with the onbar command.

◆ Cold restore mode:
Restores both critical and noncritical data when the database server is offline. A cold restore performs the following operations:

1. A backup of the logs that have yet to be backed up.

2. A physical restore and logical restore of the critical dbspaces.

3. A physical restore and logical restore of the noncritical dbspaces.

Advertisements

About Ahmad Sabry ElGendi

https://www.linkedin.com/pub/ahmad-elgendi/94/223/559
This entry was posted in E20-597. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s