Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Multi-tenant database : Tenant Data Recovery : Step 2: Rolling forward after-image files
 
Step 2: Rolling forward after-image files
The second step in the tenant data recovery process is to apply after-image files to your temporary database.
After restoring your production database backup to a temporary database, if you use after-imaging, you need to apply all the after-image files from the production database that have been created since the backup was created, up to the point just prior to when the accidental deletion occurred. If you don't use after-imaging, proceed to Step 3: Moving data with PROUTIL DATAMOVE .
To expedite the process of rolling forward multiple after-image extents, RFUTIL ROLL FORWARD accepts a file containing a list of after-image files as input. The syntax of ROLL FORWARD with a list of extents is:
rfutil db-name -C roll forward -ailist listfile
The listfile file, containing a list of AI area files, must be structured as follows:
*Specify one AI file per line
*AI file names must have a fully specified absolute file name or a relative file name, relative to the working directory where RFUTIL is executed
*Lines that begin with a colon (:), hash mark (#), or asterisk (*) are treated as comments and skipped over for parsing
If a file in the list is not an after-image file, ROLL FORWARD issues a warning and the file is skipped.
The following example demonstrates applying the after image files from a database named production_db to a database named temporary_db.
To apply after-image files from a list:
1. Create a list of after-image files from production_db:
proenv>ls production_db.a* > production_ai_files.lst

proenv>cat production_ai_files.lst
production_db.a1
production_db.a10
production_db.a11
production_db.a12
production_db.a2
production_db.a3
production_db.a4
production_db.a5
production_db.a6
production_db.a7
production_db.a8
production_db.a9
Notice that the files are sorted using an alphabetical sort. ROLL FORWARD sorts the files into the proper sequence order before applying them to the target database.
2. Apply the source after-image files to the target, temporary_db, as shown:
proenv>rfutil temporary_db -C roll forward -ailist
           production_ai_files.lst
ROLL FORWARD sorts and applies the after-image files, reporting the progress of each file as it is applied to both the screen and the database log file. The following is a portion of the output:
OpenEdge Release 11.3ALPHA as of Wed Mar 13 19:01:40 EDT 2013
***Beginning processing of After-image extent C:\OE113WRK\production_db.a1 (17047)
After-image dates for this after-image file: (1633)
Last AIMAGE BEGIN Mon Mar 18 18:12:06 2013 (1640)
This is aimage file number 1 since the last AIMAGE BEGIN. (1642)
This file was last opened for output on Mon Mar 18 18:12:11 2013. (1643)

10% of aimage file processed (964 notes applied)...
20% of aimage file processed (1924 notes applied)...
30% of aimage file processed (2751 notes applied)...
40% of aimage file processed (3713 notes applied)...
50% of aimage file processed (4628 notes applied)...
60% of aimage file processed (5587 notes applied)...
70% of aimage file processed (6550 notes applied)...
80% of aimage file processed (7466 notes applied)...
90% of aimage file processed (8424 notes applied)...

8932 notes were processed. (1634)
0 in-flight transactions. (3785)
1 transactions were started. (1635)
1 transactions were completed. (11138)

At the end of the .ai file, 0 transactions were still active. (1636)
***Finished processing of After-image extent C:\OE113WRK\production_db.a1 (17048)

***Beginning processing of After-image extent C:\OE113WRK\production_db.a2 (17047)
After-image dates for this after-image file: (1633)
Last AIMAGE BEGIN Mon Mar 18 18:12:06 2013 (1640)
Last AIMAGE NEW Mon Mar 18 18:12:58 2013 (1641)
This is aimage file number 2 since the last AIMAGE BEGIN. (1642)
This file was last opened for output on Mon Mar 18 18:12:58 2013. (1643)
..
***Finished processing of After-image extent C:\OE113WRK\production_db.a11 (17048)

***Beginning processing of After-image extent C:\OE113WRK\production_db.a12 (17047)
After-image dates for this after-image file: (1633)
Last AIMAGE BEGIN Mon Mar 18 18:12:06 2013 (1640)
Last AIMAGE NEW Mon Mar 18 18:25:26 2013 (1641)
This is aimage file number 12 since the last AIMAGE BEGIN. (1642)
This file was last opened for output on Mon Mar 18 18:25:26 2013. (1643)

108977 notes were processed. (1634)
1 in-flight transactions. (3785)
0 transactions were started. (1635)
1 transactions were completed. (11138)
At the end of the .ai file, 0 transactions were still active. (1636)
Roll forward of the after-image busy extent is complete. (3786)
All roll forward for database target_db is complete. (3787)
***Finished processing of After-image extent C:\OE113WRK\production_db.a12 (17048)