Oracle 11g RMAN Validate command.

The validate command can be used to detect corrupt blocks and missing files,
also to determine whether backup set can be restored.

The validate command can check for physical and logical corruptions in database files.

The following command will validate and check all datafiles along with archivelogs,
current controlfile and spfile for any kind of corruption.

Read more >>

Oracle Database 11g Workload Replay.

Database replay feature can be used to capture workload from the 
production system, and replay it on a test system, with exact
timing and concurrency.

Its like you can emulate the transaction workload on the test system
as it was happening on the production system.

Main benefit of this is that you can test new settings on 
the test system before implementing them on the production system.

Read more >>

Oracle 11g Health Checks.

Oracle 11g now has a feature called health monitor which can be used 
to run diagnostic checks on the database.

Health check can be run in two ways.

1) Automatic - The fault diagnosable infrastructure runs the checks
               when a critical error is reported.

2) Manual - Can be done manually either through enterprise manager
            or through DBMS_HM PL/SQL package.

Read more >>

Oracle 11g Data Recovery Advisor.

The data recovery advisor automatically detects corruption or loss of
data on disk and also provides advisory and execution functions for
repair or recovery of lost data.

Example: I lost my Users Tablespace datafile for some reason.

Read more >>

Oracle 10g Using RMAN to Roll Forward a Physical Standby Database.

On Standby

SQL>alter database recover managed standby database cancel;
SQL> select current_scn from v$database;

CURRENT_SCN
-----------
     485739

Read more >>

Oracle 11gR2 Table level compression.

Earlier in oracle 10g we had compression at the table level but it
was only for bulk load operations.

But with Oracle 11gR2 compression is also available at the OLTP
level.

Read more >>

Oracle Segment Advisor 10g.

Segment advisor which is available from oracle 10g onwards helps
in detecting segments that have space issues.

For example if a table had lots of rows earlier but now it has few
rows then it may be hording up space because of its high water mark.

Segment advisor helps in finding following
types of segments.

Read more >>