Kill The Running Job in Oracle

Some times it becomes necessary to kill the ongoing running Oracle job. I faced a situation when there was "enq: TX - row lock contention" and job was continuously running.

Oracle Proxy User

A proxy user is a user that is allowed to "connect on behalf of another user"

Backup and Restore using AVAMAR

Brief:
The Avamar Plug-in for Oracle works with Oracle and Oracle Recovery Manager (RMAN) to
back up an Oracle database, a tablespace, or datafiles to an Avamar server.

Creating duplicate database using rman backup 11gR2 (Single instnace)

Scenerio:
Duplication required for a single instance database (11gR2) on the same server. OS environment Windows 64bit.

Restoring RMAN backup to new server

Scenerio:
RMAN backup has been taken on the production server and now it is required to restore it on the new fresh server. OS environment is Windows 64bit. Source system was on RAC 11gR2 and Destination was 11gR2 Single instance.

Scheduling RMAN Batch job for backup

Scenerio:

To take the RMAN backup by OS scheduled job (on Windows)

Deleting obsolete rman backup information from controlfile

Scenario:
We took database backup disk including controlfile from production server to refresh a staging server for application testing purpose. On production server TAPE (Netbackup) already configured. After copying the RMAN backup files to Stage DB Server, upon restore when we checked database backups it was showing the TAPE backups also. So we deleted the backups.

ORA-01031 insufficient privileges

Developer was getting "ORA-01031: insufficient privileges" error while updating a table even though the user had proper privileges already. Complete scenario is given below 

A Quick Intro to GIS - Part I

What is GIS
GIS stands for geographic information system. It is an integrated system used to display, store, manage and analyze data about objects on earth. It is used to perform a variety of functions on geographic information.

ORA-01152: file 1 was not restored from a sufficiently old backup

Scenerio: After restring and recovering database got ORA-01152 while opening the database with resetlogs. Backup was taken without taking the archive logs. Perform the following:

RMAN: Taking Cold backup using RMAN and restore it

Cold backup is particular useful when you plan to test some changes on the database and in case something goes wrong you can always fall back to this Cold backup.

Cold backup is a consistent backup when the database has been shutdown immediate or Shutdown Normal.If the database is shutdown with abort option then its not a consistent backup.

Cold backup can be taken by RMAN in mount stage after database has been shutdown immediate.

RMAN: Recovery of missing datafile that is never backed up

Environment:
Oracle Database 11gR2 on Windows 7
DB in archivelog mode

Example:
Assuming that already a tablespace "TS1" is existing with one datafile, if not you can use the statements below.
 create tablespace ts1 datafile 'C:\app\Inam\oradata\orcl\ts01.dbf' size 10m reuse;

Using Transportable Tablespaces

Oracle transportable tablespaces are the fastest way for moving large volumes of data between two Oracle databases. Using transportable tablespaces, Oracle data files (containing table data, indexes, and almost every other Oracle database object) can be directly transported from one database to another. Furthermore, like import and export, transportable tablespaces provide a mechanism for transporting metadata in addition to transporting data.

RMAN: Recover A Dropped Tablespace Using TSPITR (11gR2)

RMAN automatic Tablespace Point-In-Time Recovery ( TSPITR) enables you to quickly recover one or more tablespaces in an Oracle database to an earlier time, without affecting the state of the rest of the tablespaces and other objects in the database.

ORA-00245 control file backup failed

Environment: Two node Oracle RAC 11gR2 on Windows 2008R2

Symptoms

RMAN backups report errors like :

ORA-00245: control file backup operation failed

ORA-12528: TNS: listener: all appropriate instances are blocking new connections

Cause: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.

Installing 11gR2 RAC on Solaris

Environment: OS  Sun Solaris 10 update 10 x86 64bit on OVM, Oracle 11gR2 (11.2.0.1) 64bit
See the overview Note:

Read the overview above for Grid infrastructure concepts. As overview is related to Windows OS, difference is given below with respect to Solaris.
ADVM (ASM dynamic volume manager) and ACFS (ASM cluster file system) are currently not available forSolaris. 

11gR2 on Solaris: Create Database

11gR2 on Solaris: RDBMS Software Install

Log out from "grid" user and enter as "oracle" and run installer

11gR2 on Solaris: Oracle Grid Infrastructure Install

Start the RACSOL1 and RACSOL2 virtual machines, login to RACSOL1 as the grid user and start the Oracle GI installer.