Kbase P2454: How to re-start the database when after image file (ai) is full?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/19/2009 |
|
Status: Verified
GOAL:
How to re-start the database when after image file (ai) is full?
GOAL:
How to make an existing ai file available to be rolled into
GOAL:
What to do when all the After-image files are all full?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Without particular details around what specifically needs to be achieved as a result of what had happened, generally, this is the procedure that you would need to follow:
+ assuming that after imaging has been started "rfutil dbname -C aimage begin" in the database's history.
+ although it is not mandatory, we do recommend using more than one ai extent, stored on a different disk to the database and that these are backed up on a different server.
+ if variable extents are used, be careful of exceeding the 2GB limit - aistall is a useful tool in these cases
STEPS:
1) rfutil sports -C aimage extent full
- provides the filename of the oldest ai full file, so that archiving of extents can be performed in the order in which they were filled.
2) BACKUP ai extents with OS backup utilities, filing in the order that they were filled.
3) rfutil sports -C aimage extent empty
- to mark each file as empty and ready for re-use,
4) Start database server.