Online hot backup and recovery combat

Features of online backup

Online backup is also known as hot backup, while backup, users of the database can operate, so the contents of the corresponding physical files of the database are constantly changing, the update of the contents of these physical files is retained until the relevant operation has been written to the redo log file.

Use Backup Wizard to implement online backup

(1) as shown in Figure 12.33.

(2) The "Introduction" interface of the Backup Wizard appears as shown in Figure 12.34.
(3) The policy selection interface for the Backup wizard appears as shown in Figure 12.35.

(4) The backup selection interface for the Backup wizard appears as shown in Figure 12.36.
(5) The Archive log interface for the Backup wizard appears as shown in Figure 12.37.

(6) There are two options for the backup options interface of the Backup Wizard, as shown in Figure 12.38.
(7) The configuration interface of the Backup Wizard appears as shown in Figure 12.39.

(8) The schedule interface for the Backup wizard appears as shown in Figure 12.40.
(9) The job information interface for the Backup wizard appears as shown in Figure 12.41.

(10) The "profile" interface of the Backup Wizard appears.
(11) After the backup job completes successfully, a file named B_01ehj8rh_1_1 and B_02ehj96s_2_1 appears under the specified backup directory, which is the backed-up file.

Using the Recovery Wizard to achieve online recovery

(1) The database must work in a mounted state that is archived to perform an online recovery of the entire database.
(2) as shown in Figure 12.42.

(3) The introduction interface for the Recovery wizard appears.
(4) The "Restore Selection" interface appears as shown in Figure 12.43.
(5) The "Recover to" interface to the Recovery wizard appears as shown in Figure 12.44.

(6) The rename interface of the Recovery wizard appears as shown in Figure 12.45.
(7) The configuration interface of the Recovery wizard appears as shown in Figure 12.46.

(8) The "Overview" interface of the Recovery wizard appears.
(9) The recovery Manager will automatically perform the online restore operation of the database.