What is the role of each Bounded Recovery file?
Hello, Oracle experts.
When I checked the behavior of Bounded Recovery feature, I found 3 types of file in a capture directory, which is in the BR directory.
===
1. "CP." file: which is generated/updated every time in BR interval.
2. "PCD." file: which is generated when uncommitted transaction data exist in BR interval.
3. "POD." file: which is also generated when uncommitted transaction data exist in BR interval.
===
"CP." file name is like "CP.<capture name>.0000xx", where "0000xx" is number of current BR interval.
"PCD." file and "POD." file are generated same time, and "PCD." file length is variable, seems to depend on the transaction data size, though "POD." file length is fixed. And these file disappear when no transaction data remained by committing.