Experience: is what you get soon after you need it.
My Cloud Certifications:
AWS Certified Solutions Architect Associate
Azure Certified Administrator
Oracle Cloud Infrastructure 2018 Certified Architect Associate.
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.
Oracle Database Cloud Administrator Certified Professional.
Oracle Database Cloud Service Operations Certified Associate.
Thursday, April 15, 2010
How frequent shall I backup
new level 0 backup whenever 20% or more of the data has changed. If the rate of
change to your database is predictable, then you can observe the size of your
incremental backups to determine when a new level 0 is appropriate. The following
SQL query determines the number of blocks written to an incremental level 1 backup
of each datafile with at least 20% of its blocks backed up:
SELECT FILE#, INCREMENTAL_LEVEL, COMPLETION_TIME,
WHERE INCREMENTAL_LEVEL > 0
AND BLOCKS / DATAFILE_BLOCKS > .2
ORDER BY COMPLETION_TIME;