The other day we had a situation with an OEM 12cR2. We performed maintenance in a 2-node cluster and both instances came up fine, but one of the instances in OEM’s Cluster Database target was showing a pending status. It goes to say that before the maintenance, both showed as up.
As you know, thresholds for flash/fast recovery area (FRA) usage are set internally in a database to 85 and 97 per cent, and there are no ways to change the thresholds — at least none that are supported by Oracle. This might work fine in most cases, but being aware of changes in FRA usage can sometimes be helpful. You can then contact your DBA and suggest verifying your database’s settings.
I am happy to announce that, thanks to all the volunteers’ hard work and Oracle Technology Network’s support, RAC Attack is going to be part of the Oracle OpenWorld 2013 conference in less than a month’s time.
This Log Buffer Edition starts with an awesome post by Dana Pylayeva from Rakuten LinkShare, a long term Pythian client, about her deep and insightful reflections about security. And as usual, it also brings together all the sparkling gems of Oracle, SQL Server, and MySQL. Enjoy!
Oracle Data Pump appeared with release 10gR1 and has been a best friend for Oracle techs ever since. It offers so much more than traditional export/import, but do not let it detract you from its predecessors for even a second. This article offers an introduction to some of the new stuff in 2cR1.
Data Guard Broker in #DB12c introduced a new command, VALIDATE DATABASE, which tremendously lightens the process of information gathering to make sure role change operations succeed. It is very helpful in the case of RAC database usage in Data Guard configuration.