Recently I have faced data loss in one of our environment. When we queried for CUBE_INSTANCE table to check instance state I found all data before 7 day are gone. I have tried to find out the reason if that instance were ever created or not then I found one new feature of 12c called Auto Purge.
All of our instance’s data were purged because of this so the situation forced me to disable auto purge immediately. Later on I found this is very use full feature and configured them with optimal value as required for our environment.
Please read below page for some more info and to get basic idea on of this new feature.
Page Link : Auto Purge in 12c
Like it if you have learned something. Comment your views, queries. Any suggestion and corrections are always appreciated. Keep learning.
You must be logged in to post a comment.