Pages

▼
Friday, December 27, 2013

what is snapshot controlfile and when we can make use of it??

›
RMAN needs to get a consistent view of the control file when it sets out to make backup of every datafile. It only needs to know the mos...
6 comments:
Wednesday, November 13, 2013

Increasing Processes, Sessions and Transactions in Oracle

›
If your maximum number of process and/or sessions exceeds the limit ,oracle will throws following errors  ORA-12516: TNS:listener could n...
Tuesday, November 12, 2013

How to change the redo log size in RAC

›
There is no any ALTER... command to resize the REDO logs in orace.  So if you want to resize your REDO logs you will need to create a new g...

How to upgrade oracle client from 10.2.0.3 to 10.2.0.4

›
Recently i got a request   from my developer   team  to install oracle client version 10.2.0.4 . Here is the step that i followed to ach...
Tuesday, October 29, 2013

How to properly shutdown oracle rac database and its clusterware components in 11gR2

›
The first step to shutdown any database whether it is RAC or single instance is to stop all the applications that are accessing the Databas...
Saturday, October 26, 2013

Managing Backups and Recovery of the OCR Using OCR Backup Files

›
Two methods are most popular for copying OCR content and using it for recovery. The first method uses automatically generated OCR file copi...
Wednesday, September 4, 2013

Partitioning an existing table using datapump - a sample demo

›
First create a sample  table for testing purpose,  SQL>CREATE TABLE big_table (   id            NUMBER(10),   created_date  DATE,   ...