Oracle 10g Dataguard Physical Standby.

This tutorial is for configuring
physical standby database.


The dataguard type which we are configuring
here is "Maximum Performance Mode".

Primary Machine IP: 192.168.1.160

Database name:orcl

Read more >>

Oracle 11gR2 Compression feature.

In Oracle 10g we had basic compression in RMAN.
But Oracle 11gR2 has added some more compression features.

There are basically four compression levels.

HIGH   = unmodified BZIP2
MEDIUM = ZLIB
LOW    = LZO
BASIC  = BZIP2

Read more >>

Oracle 11g Feature Multisection Backup.

With this new feature RMAN backups can be split 
into multiple pieces.

Suppose you want to backup your system tablespace and spread the 
backups to three different backup locations.
You can do so through the following query.

Read more >>

How to Multiplex Control Files ?

To multiplex a control file:

1. Set the new location.

   Example: SQL> alter system set control_files='/u01/app/control04.ctl',
                    '/u01/app/control01.ctl','/u01/app/control02.ctl',
                     '/u01/app/control03.ctl' scope=spfile;

2. Shutdown the database
3. Copy a already existing controlfile to the above locatons
   and rename it.

4. Startup the database.

Read more >>

Types of Checkpoints in Oracle.

Checkpoint types can be divided as INCREMENTAL and COMPLETE.

Also COMPLETE CHECKPOINT can be divided further into
PARTIAL and FULL.

In Incremental Checkpoint,checkpoint information is written to the
datafile header and controlfile In the following cases:

Read more >>

Oracle 10g BigFile Tablespace.

One of the new features in oracle 10g is the introduction of 
bigfile tablespace.

A bigfile tablespace is a tablespace which basically consists of one
and only one datafile which can be as large as 128 Terabytes in size
depending upon the block size of the tablespace.

Following is the list of block sizes and maximum
sizes for bigfile tablespaces.

Read more >>

Oracle Database Tablespace Management.

To check for all the tablespaces in your database
issue the following query.

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
EXAMPLE

6 rows selected.

Read more >>