AUTOMATED TABLESPACE POINT IN TIME RECOVERY

I have seen people using Flashback Technology more often to restore tables to an earlier point in time. Automatic tablespace point in time recovery is an other option which we can use to recover one or more tablespaces to an earlier point in time at the same time retaining other tablespaces and objects as it […]

Read the rest of this entry »

Getting hold with Oracle Database 11gR2 RAC

Oracle Database 11gR2 MOS Notes Doc ID 1232802.1 RAC One — Changes in 11.2.0.2 Doc ID 1312225.1 Things to Consider Before Upgrade to 11.2.0.2 Grid Infrastructure Doc ID 1267828.1 SYS Password Management with RAC and Data Guard Doc ID 1276368.1 Complete checklist for out-of-place manual upgrade from 11.2.0.1 to 11.2.0.2 Doc ID 341880.1 How to […]

Read the rest of this entry »

Oracle 11g New Feature Causes AMM to Restart

This post is from one of the emails I have recieved from my friend Mackenzie D’Cruz, he experienced this issue on his production environment. This information is published by Don Burleson at http://www.dba-oracle.com. So this is just a copy to let our readers know about this issue. Beware, following new upgrades to 11gR2, you can […]

Read the rest of this entry »

Oracle 8i to 11g – hidden features.

Every release contains many new features and enhancements that are not highlighted in the marketing material. Oracle assumes all customers will move on to new versions when they are released. Here are few examples of those – New  features failed to spot. DBMS_SYSTEM.KSDWRT undocumented package installed in all databases Used to write messages to trace […]

Read the rest of this entry »

Real Application Testing Oracle RAT 11g

What is the critical concern when we need to make a change in the production database ?  The biggest concern is the risk of the change – “mess up” something. Even the most minor changes can have an awful effect, eventually producing a visible impact. In Oracle Database 11g, We have a new feature called […]

Read the rest of this entry »
|