6.2.1 Acquiring a Backup of the Execution Log Information Table
- Organization of this subsection
(1) Using HiRDB to acquire a backup
You can use HiRDB's database copy utility (pdcopy) to periodically acquire a backup of the execution log information table. You can also use the database recovery utility (pdrstr) to restore the database. The following figure shows database backup and recovery using HiRDB's database copy utility (pdcopy).
|
|
![[Figure]](GRAPHICS/ZC060100.GIF)
If you use HiRDB to acquire a backup, select a backup acquisition mode using the -M option of HiRDB's database copy utility (pdcopy). The mode you select depends on whether the HCSC server is active or inactive.
-
When the HCSC server is active
Select the updatable mode (s).
If you select the updatable mode, you can reference and update the target RDAREA during backup processing.
You can restore the RDAREA to any synchronization point that falls after backup acquisition. To restore the database, you need the backup copy and the system log that was obtained after the synchronization point immediately before backup acquisition.
-
When the HCSC server is inactive (such as during maintenance)
Select the reference-possible mode (r) or reference/update-impossible mode (x).
If you select the reference-possible mode (r), you can reference the RDAREA subject to backup during backup acquisition, but you cannot update it.
If you select the reference/update-impossible mode, you can neither reference nor update the RDAREA subject to backup during the backup acquisition. Before acquiring the backup, you must use the HiRDB command pdhold -c to place the target RDAREA in shutdown and closed status.
By using the backup acquired with these modes, you can restore the database to the point at which the backup was acquired. If you use the system log, you can restore the database to any desired synchronization point that falls after backup acquisition.
For details about HiRDB's database copy utility (pdcopy), database recovery utility (pdrstr), and backup acquisition modes, see the manual HiRDB Description.
(2) Acquiring a backup using Oracle
You can use Oracle's Recovery Manager (RMAN) function to periodically back up the execution log information table. This function enables you to obtain a differential backup from the previous backup. For details, see the documentation provided with the product.