The following shows an example of the process results output files for the database recovery utility.
pdrstr(VV-RR) ***** DB RECOVERY ***** 1995-05-16 11:35:35 [1] utl3 [2]
*** DB RECOVERY INFORMATION LIST ***
---------------------------------------------------------
<<RDAREA INFORMATION>>
UNIT NAME : un16 [3] SERVER NAME:sds [4]
RDAREA NAME: pdbuser01 [5]
RDAREA ID : 4 [6] ATTRIBUTE : USER [7] PAGE SIZE : 4096 [8]
RECOVERY STARTED AT : 1995-05-16 11:34:19 [9]
RECOVERY ENDED AT : 1995-05-16 11:34:46 [10]
<REPLICA RDAREA INFORMATION>
ORIGINAL RDAREA NAME : pdbuser01 [19]
REPLICA RDAREA GENERATION NO : 0 [20]
<<BACKUP INFORMATION>>
BACKUP STARTED AT : 1995-05-16 11:11:42 [11]
BACKUP ENDED AT : 1995-05-16 11:11:42 [12]
<<LOG INFORMATION>>
1ST LOG : 1995-05-16 10:57:48 [13]
LAST LOG : 1995-05-16 10:58:26 [14]
LOG COUNT : 42 [15]
<FILE INFORMATION>
1 /dbarea/area1/rdmt06 [16]
EXTENT COUNT : 2 [18]
PAGE NUMBER : 124 [17]
2 /dbarea/area1/rdmt07 [16]
EXTENT COUNT : 2 [18]
PAGE NUMBER : 108 [17]
--------------------------------------------------------
<<RDAREA INFORMATION>>
UNIT NAME : un16 SERVER NAME:sds
RDAREA NAME: pdbuser03
RDAREA ID : 5 ATTRIBUTE : USER PAGE SIZE : 4096
RECOVERY STARTED AT : 1995-05-16 11:34:46
RECOVERY ENDED AT : 1995-05-16 11:35:10
<REPLICA RDAREA INFORMATION>
ORIGINAL RDAREA NAME : pdbuser03
REPLICA RDAREA GENERATION NO : 0
<<BACKUP INFORMATION>>
BACKUP STARTED AT : 1995-05-16 11:11:42
BACKUP ENDED AT : 1995-05-16 11:11:43
<<LOG INFORMATION>>
1ST LOG : 1995-05-16 10:59:50
LAST LOG : 1995-05-16 11:02:35
LOG COUNT : 42
<FILE INFORMATION>
1 /dbarea/area1/rdmt08
EXTENT COUNT : 2
PAGE NUMBER : 124
2 /dbarea/area1/rdmt09
EXTENT COUNT : 2
PAGE NUMBER : 108
--------------------------------------------------------
<<RDAREA INFORMATION>>
UNIT NAME : un16 SERVER NAME:sds
RDAREA NAME: pdbuser05
RDAREA ID : 6 ATTRIBUTE : USER PAGE SIZE : 4096
RECOVERY STARTED AT : 1995-05-16 11:35:10
RECOVERY ENDED AT : 1995-05-16 11:35:34
<REPLICA RDAREA INFORMATION>
ORIGINAL RDAREA NAME : pdbuser05
REPLICA RDAREA GENERATION NO : 0
<<BACKUP INFORMATION>>
BACKUP STARTED AT : 1995-05-16 11:11:43
BACKUP ENDED AT : 1995-05-16 11:11:43
<<LOG INFORMATION>>
1ST LOG : 1995-05-16 11:03:21
LAST LOG : 1995-05-16 11:08:47
LOG COUNT : 42
<FILE INFORMATION>
1 /dbarea/area1/rdmt10
EXTENT COUNT : 2
PAGE NUMBER : 124
2 /dbarea/area1/rdmt11
EXTENT COUNT : 2
PAGE NUMBER : 108
-------------------------------------------------------- |
- Explanation
- Date and time the database recovery utility was executed (in the format YYYY/MM/DD hh:mm:ss).
YYYY: Year. MM: Month. DD: Date. hh: Hour. mm: Minute. ss: Second.
- HiRDB identifier
- Name of the unit containing an RDAREA
- Name of the unit containing an RDAREA
- Name of the recovered RDAREA
- Number of the recovered RDAREA
- Type of RDAREA:
MASTERDIRECTORY: Master directory RDAREA
DATADIRECTORY: Data directory RDAREA
DATADICTIONARY: Data dictionary RDAREA
SYSTEM_LOB: Data dictionary LOB RDAREA
USER: User RDAREA
USER_LOB: User LOB RDAREA
REG: Registry RDAREA
REG_LOB: Registry LOB RDAREA
- Page length of the RDAREA (in bytes)
- Recovery start time of the RDAREA (format is the same as in 1)
- Recovery end time of the RDAREA (format is the same as in 1)
- Backup start time of the RDAREA (format is the same as in 1)
- Backup end time of the RDAREA (format is the same as in 1)
- Time the first log record was output during recovery processing (format is the same as in 1)
- Time the last log record was output during recovery processing (format is the same as in 1)
- Number of updated log records used during recovery processing
- Name of a HiRDB file constituting the RDAREA
- Number of pages allocated to the HiRDB file
- Number of extents in the HiRDB file
- Name of the original RDAREA
- Generation number of the replica RDAREA
- Notes
- If there is no data to be restored, the utility displays No data for recovery at 9, and displays nothing at 8-15.
- If there is no backup file, the utility does not display 11 or 12.
- If there are no log records for an RDAREA, the utility does not display 13 or 14.
- 19 and 20 are output if the inner replica facility is used.