Autotuned_reserved_space is a new policy setting that got released with 21.1 and you should be using it. When I talk to customers about how to manage databases on a ZDLRA, the biggest confusion comes in when I talk about reserved space. Reserved space needs to be understood, and properly managed. This new feature in 21.1 allows the ZDLRA to handle the reserved space for you, and I explain how to use it in this blog post. First let's go through space usage, and reserved space in general.
Space usage on the ZDLRA.
Recovery Window goal (which drives the space utilization)
The recovery window goal is set at the policy level, and this value (in days) is the number of days that you want to keep as a recovery window for all databases that are a member of this policy. This will drive the space utilization.
Total space
The ZDLRA comes with all the space pre-allocated. When you are looking at OEM, or in the SAR report you will see the total space listed. You want to make sure that you have enough space for your database backups and any incoming new backups.
Used Space
Recovery Window Space
Reserved space
- The sum of all the reserved space cannot be greater than the total space available on the ZDLRA.
- When adding a new database, it's reserved space must fit within the unreserved space.
- When a new database is added, the reserved space must be set to least the size of the database, and defaults to 2.5 times the size of the database.
- The reserved space for a database needs to be at least the size of the largest datafile.
- The reserved space should be larger than the amount of space needed to support the recovery window goal space for the database. For databases with fluctuation, you need to reserve space for the peak usage.
- It can be used to determine how much space is available for new database backups.
- If the ZDLRA determines that it does not have enough space to support the recovery window goal of the supported databases, space is reclaimed from databases whose reserved space is too small.
Autotuned_reserved_space
AUTOTUNED_RESERVED_SPACE
MAX_RESERVED_SPACE
AUTOTUNE_SPACE_LIMIT
SUMMARY:
- autotuned_reserved_space - Enables autotuning of space within a protection policy
- max_reserved_space - Controls the maximum reserved space of databases in a protection policy
- autotune_space_limit - Slows the reserved space growth when a specified space limit is reached.
What does autotune reserved space do ?
- On a regular basis, if needed, the reserved space for each autotune controlled database is adjusted to reserve space for the recovery window goal, and incoming backups.
- If the database has a disk_reserved_space set, autotuning will not be used for this database. It is assumed that the disk_reserved_space will be set manually for this database
No comments:
Post a Comment