Example 1
The following command generates a list of records associated with
unresolved transactions in the .aij file:
$ RMU/DUMP/AFTER_JOURNAL/STATE=PREPARED PERSONNEL.AIJ
Example 2
The following example shows the value to specify with the Aij_
Buffers qualifier along with information on how frequently each
page is accessed. The output from this example shows that you
should specify the Aij_Buffers=29 qualifier when you recover
aij_one.aij. In addition, it shows that pages (1:623-625) were
referenced 37 times which means that 8.9% of all data records in
the dumped after-image journal file reference this page.
$ RMU/DUMP/AFTER_JOURNAL/OPTION=STATISTICS aij_one.aij
.
.
.
Use "/AIJ_BUFFERS=29" when recovering this AIJ journal
1 recovery buffer referenced 37 times (1:623-625): 8.9%
1 recovery buffer referenced 23 times (4:23-25): 5.5%
1 recovery buffer referenced 22 times (4:5-7): 5.3%
1 recovery buffer referenced 21 times (4:44-46): 5.0%
1 recovery buffer referenced 20 times (4:50-52): 4.8%
1 recovery buffer referenced 19 times (4:41-43): 4.6%
2 recovery buffers referenced 18 times (4:38-40): 8.7%
1 recovery buffer referenced 17 times (4:17-19): 4.1%
1 recovery buffer referenced 16 times (4:29-31): 3.8%
2 recovery buffers referenced 15 times (4:35-37): 7.2%
1 recovery buffer referenced 14 times (4:2-4): 3.3%
2 recovery buffers referenced 13 times (4:11-13): 6.3%
3 recovery buffers referenced 12 times (4:8-10): 8.7%
2 recovery buffers referenced 11 times (5:2-4): 5.3%
4 recovery buffers referenced 10 times (4:14-16): 9.7%
1 recovery buffer referenced 9 times (4:47-49): 2.1%
2 recovery buffers referenced 8 times (1:617-619): 3.8%
1 recovery buffer referenced 6 times (4:20-22): 1.4%
1 recovery buffer referenced 2 times (1:503-505): 0.4%
Journal effectiveness: 97.3%
175 data records
412 data modification records
423 total modification records
2 commit records
3 rollback records
See the Oracle Rdb Guide to Database Maintenance and the Oracle
Rdb7 Guide to Distributed Transactions for more examples of the
RMU Dump After_Journal command.
Example 3
The following example shows how to start a dump from Block 100 or
TSN 52, whichever occurs first.
$ RMU/DUMP/AFTER_JOURNAL /FIRST=(BLOCK=100,TSN=0:52) mf_personnel.aij
Example 4
This example shows how to dump committed records only.
$ RMU/DUMP/AFTER_JOURNAL /ONLY=(TYPE=COMMIT) mf_personnel.aij
Example 5
This example shows the dump output when you specify an area, a
page, and a line.
RMU/DUMP/AFTER_JOURNAL/AREA=3/PAGE=560/LINE=1 mf_personnel.aij
*-----------------------------------------------------------------------------
* Oracle Rdb X7.1-00 3-NOV-2005
10:42:23.56
*
* Dump of After Image Journal
* Filename: DEVICE:[DIRECTORY]MF_PERSONNEL.AIJ;1
*
*-----------------------------------------------------------------------------
2/4 TYPE=D, LENGTH=122, TAD= 3-NOV-2005 10:31:12.56, CSM=00
TID=6, TSN=0:640, AIJBL_START_FLG=01, FLUSH=00, SEQUENCE=1
MODIFY: PDBK=3:560:1, LDBID=0, PSN=0, FLAGS=00, LENGTH=84
0022 0000 line 1 (3:560:1) record type 34
00 0001 0002 Control information
.... 79 bytes of static data
86726576696C6F54343631303000010D 0005 data '...00164Toliver.'
5020363431411120846E69766C410420 0015 data ' .Alvin. .A146 P'
009820876563616C50206C6C656E7261 0025 data 'arnell Place. ..'
3330484E12208B6175726F636F684307 0035 data '.Chocorua. .NH03'
20F03100630F72B31C00004D373138 0045 data '817M...³r.c.1ð '
2/6 TYPE=D, LENGTH=224, TAD= 3-NOV-2005 10:31:12.56, CSM=00
TID=6, TSN=0:641, AIJBL_START_FLG=01, FLUSH=00, SEQUENCE=3
MODIFY: PDBK=3:560:1, LDBID=0, PSN=1, FLAGS=00, LENGTH=84
0022 0000 line 1 (3:560:1) record type 34
00 0001 0002 Control information
.... 79 bytes of static data
86726576696C6F54343631303000010D 0005 data '...00164Toliver.'
5020363431411120846E69766C410420 0015 data ' .Alvin. .A146 P'
009820876563616C50206C6C656E7261 0025 data 'arnell Place. ..'
3330484E12208B6175726F636F684307 0035 data '.Chocorua. .NH03'
20F03100630F72B31C00004D373138 0045 data '817M...³r.c.1ð '
3/9 TYPE=D, LENGTH=330, TAD= 3-NOV-2005 10:31:12.73, CSM=00
TID=6, TSN=0:642, AIJBL_START_FLG=01, FLUSH=00, SEQUENCE=5
MODIFY: PDBK=3:560:1, LDBID=0, PSN=2, FLAGS=00, LENGTH=84
0022 0000 line 1 (3:560:1) record type 34
00 0001 0002 Control information
.... 79 bytes of static data
86726576696C6F54343631303000010D 0005 data '...00164Toliver.'
5020363431411120846E69766C410420 0015 data ' .Alvin. .A146 P'
009820876563616C50206C6C656E7261 0025 data 'arnell Place. ..'
3330484E12208B6175726F636F684307 0035 data '.Chocorua. .NH03'
20F03100630F72B31C00004D373138 0045 data '817M...³r.c.1ð '
Use "/AIJ_BUFFERS=3" when recovering this AIJ journal.
Make sure you have enough working set and pagefile quota
for the recommended number of buffers.
1 recovery buffer referenced 3 times (3:559-561): 50.0%
1 recovery buffer referenced 2 times (3:436-438): 33.3%
1 recovery buffer referenced 1 time (3:134-136): 16.6%
Journal effectiveness: 54.5%
3 data records
6 data modification records
11 total modification records
3 commit records