Thursday, July 28, 2011

Quick reference to Oracle Patchset patch numbers --Moid

As per the Oracle's Document ID 753736.1, the following are the quick reference to Oracle Patchset patch numbers:

Click here for the document.

--Moid


keywords:
oracle version
oracle patches
oracle patchset

Friday, July 22, 2011

11g RAC using openfiler (Jeff Hunter's Document) --Moid

Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-1
Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-2
Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-3

--Moid

Tuesday, July 5, 2011

Download Tora from here --Moid

from http://torasql.com/about

"TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms.

In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers – which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools."

Tora (a tool similar to TOAD) can be downloaded from here. Main download page is at http://sourceforge.net/projects/tora/

--Moid Muhammad

Download Oracle 11g R2 Client for 32/64-bit Windows --Moid

Oracle Database 11g Release 2 (11.2.0.1.0) Client for 32/64-bit Windows.

1) Go to http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

2) Click on "Accept License Agreement"

3) And then start browsing as per your need. Few links to download Oracle client are as follows:

32-bit http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

Direct Download: http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_client.zip

64-bit http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

Direct Download: http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_client.zip

Click here for step-by-step Oracle 11g R2 Client Installation on Windows 7.

Click here for step-by-step Oracle 12c R1 Client Installation on Windows 8.

Note: In order for TOAD to work, use 32-bit client installation.

--Moid Muhammad

Monday, July 4, 2011

Backup and Recovery ()

Backup and Recovery ()

RMAN Scenario-21: How to recover database from lost controlfiles? --Moid

MIITDocID-938: My notes on RMAN --Moid

MIITDocID-958: Command Line Reference Guide --Moid

RMAN: Scenario-20: How to perform TABLESPACE point in time recovery? --Moid

RMAN: Scenario-19: How to perform point in time recovery? --Moid

RMAN: Scenario-18: How to restore Oracle datafile? --Moid

RMAN: Scenario-17: How to restore Oracle tablespace? --Moid

RMAN Scenario-16 | How to restore Oracle database? --Moid

RMAN: Scenerio-15: How to restore database with a new name from Cold Backup --Moid

Backup and Recovery Scenerio-14 | How to restore archivelogs from backups? --Moid

Backup and Recovery Scenerio-13 | How to perform time-based Oracle Point-In-Time recovery using RMAN? --Moid

Backup and Recovery Scenerio-10 [How to duplex Oracle 10g RMAN backups?] --Moid

Click here for the document.

--Moid

Backup and Recovery Scenerio-9 (How to perform a point in time tablespace recovery)

How to perform a point in time tablespace recovery? In this exercise, tablespace name is CT_COMMON_DATA?
$ export ORACLE_SID=PrimeDG
$ rman target /
RMAN> sql 'alter tablespace CT_COMMON_DATA offline';

RMAN> run

{

set until time "to_date('FEB 28 2008 13:59:00','Mon DD YYYY HH24:MI:SS')";

recover tablespace CT_COMMON_DATA;

}

RMAN> sql 'alter tablespace CT_COMMON_DATA online';
RMAN> exit;

Backup and Recovery Scenerio-12 (How to transport a tablespace?) -- Moid

Backup and Recovery Scenerio-11 (How to restore and rename database on a different server) --Moid

MIITDocID-942: Controlfiles are lost and database is still open. How to rebuild the lost controlfiles? --Moid

Backup and Recovery Scenario-7 | How to duplicate (clone) database on the DIFFERENT HOST from NON-ASM to ASM using RMAN? --Moid

Click here for the document.


Migrate NON-ASM to ASM on a different host.

--Moid Muhammad

Backup and Recovery Scenario-6 | How to duplicate (clone) database on the same server from NON-ASM to ASM using RMAN?

Click here for the document.

Migrate NON-ASM to ASM.

--Moid Muhammad

Backup and Recovery Scenario-5 | How to duplicate (clone) database on the different server using RMAN?

Click here for the document.

--Moid

Backup and Recovery Scenario-3 | How to restore and recover database on a remote server using RMAN?

Click here for 10g document.

Click here for 11g document.

--Moid

Backup and Recovery Scenario-4 | How to duplicate (clone) database on the same server using RMAN? --Moid

Click here for the document.

NON-ASM to NON-ASM

--Moid

Backup and Recovery Scenerio-2 | How to recover a datafile when all archivelogs are available?

Click here for the document.

--Moid

Backup and Recovery Scenario-1 (Recover Lost Datafile from User-Managed Full Backup)

Click here for the document.

--Moid

Backup and Recovery Scenario-0 |How to perform a user-managed cold backup?

Click here for the document.

--Moid

Oracle Background Processes

Click here for the document.

--Moid

Followers