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 >>

Oracle Goldengate 11g Initial Load Using Direct Load Method.

This article focuses on initial synchronization of source and
target databases by using Golden Gate initial direct load method for the
purpose of zero downtime DML replication.


Prerequisites:

1) Target Tables should be empty. Otherwise you can get duplicate row errors.
2) Disable Foreign Key and Check Constraints. They can be enabled later on
   when the initial load is complete.
3) (Optional) Remove indexes from target tables as they may slow down the
   initial loading process.
4) To use handlecollisions function, each target table must have a
   primary or unique key. If that's not possible use the KEYCOLS 
   option of the TABLE and MAP parameters. Even if that is not possible
   then quiesce your database for the duration of intial load.

Read more >>

Delete or Remove Extract & Replicat Processes (Golden Gate 11g).

1)Stop extract/replicat.

kill extract group_name
kill replicat group_name

2)Delete extracat / replicat.

delete extract group_name
delete replicat group_name

3) Cleanup. 

cleanup extract group_name
cleanup replicat group_name

Read more >>