Different ways to get the DBID of Database.

Method 1:Through SQL command prompt.

SQL> select dbid from v$database;

      DBID
----------
3764293269

Read more >>

Simulating Oracle Tape Backups.

As per Oracle Note:312737.1

The Oracle DiskSbt API is designed for TESTING purposes ONLY
and can NOT be used for any database backup.

The Oracle.Disksbt can be used to simulate tape backups on disk using sbt_tape
channel.

Read more >>

Oracle Database links.

Primary database name = dell
Secondary Database Name = dup

On Secondary

Create TNS Entry for primary database.

[oracle@newyork admin]$ cat tnsnames.ora 

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

Read more >>

Oracle 11gR2 RAC Node Deletion.

NodeName which has to be removed from the cluster - rac3

Backup OCR from rac1


[root@rac1 ~]# /u01/app/11.2.0/grid/bin/ocrconfig -manualbackup

Read more >>

RAC common wait events.

1) Global cache blocks lost- This statistic shows block losses during network
transfers. High values of this statistic indicate network problems.
The use of an unreliable IPC protocol, such as UDP, may result in the value
for lost global cache blocks being non-zero. 

High values for this statistics indicates that there is some problem with the IPC,
network or hardware.

2) Global cache blocks corrupt - This statistic shows if there is any block corruption
during interconnect transfers. High value for this statistic indicates
that there is a IPC,network or hardware problem.

Read more >>

Oracle 11gR2 RAC Node Addition.

Following are the IP Addresses which i am using 
for the node.

Public IP Address: 192.168.1.170
Private IP Address: 192.168.2.170
Virtual IP Address: 192.168.1.250

OS installed - RHEL 5.4

Read more >>