Search This Blog

Monday, February 27, 2012

Oracle Software Cloning.

On Source

$ emctl stop dbconsole

$ lsnrctl stop

$ cd/u01/app/oracle/product
Read more >>

Friday, February 17, 2012

Essential RMAN Commands.

CHANGE

Options:

1) AVAILABLE - Changes the status of backup or copy to "available" in the repository.
2) UNAVAILABLE - Changes the status of backup or copy in the repository.
3) KeepOption - Overrides the retention policy.
Read more >>

RMAN Catalog Creation.

Target Database:
Name:orcl
IP Address:192.168.1.55

Catalog Database:
Name:recovery
IP Address:192.168.1.200
Read more >>

Oracle Database Cloning Using User Managed Backup.

Assumption:

1) Hot backups of the production server are there. 
 
Production Database Name: orcl
Cloned Database Name: pub

--Create pfile from the production servers spfile.
Read more >>

Saturday, February 11, 2012

Oracle Database Best Practices.

1) Maintain atleast three controlfiles.

2) Set CONTROL_FILE_RECORD_KEEP_TIME Large Enough.

(a) The CONTROL_FILE_RECORD_KEEP_TIME specifies the number of days
    that records are kept within the controlfile before being reused.
Read more >>

Friday, February 10, 2012

Commonly Configured OEM Alerts and Their Solutions.

Archiver Hung Alert Log Error

Cause: Possible cause is that the destination LOG_ARCHIVE_DEST_n is full.
Action: Check alert log file and archiver for additional information. 

ORA-01578:ORACLE data block corrupted
Read more >>

Thursday, February 9, 2012

Oracle 11g GoldenGate Installation.

Download the GoldenGate software from Oracle Edelivery.

Select a Product Pack: Oracle Fusion Middleware
Platform: Linux X86

Download the Oracle GoldenGate media pack.
Read more >>

Oracle 11g Manual Database Creation.

Create necessary directories.

$ mkdir -p /u01/app/oracle/admin/pub/adump/
$ mkdir -p /u01/app/oracle/oradata/pub/
$ mkdir -p /u01/app/oracle/flash_recovery_area/pub/

Read more >>

Monday, February 6, 2012

Oracle Enterprise Manager Cloud Control 12c Release 1 Installation on Oracle Linux 5.6

Requirements:

1) Oracle Linux 5.6 or RHEL 5.6 or higher
2) Oracle Database 11gR2
3) Enterprise Manager Cloud Control 12c Release 1

Package Requirements for Grid Control on 32-bit:
Read more >>

Saturday, February 4, 2012

Oracle 11g Invisible Indexes.

With Oracle 11g you can turn any index invisible with this feature.

When you turn a index invisible the optimizer cannot see it and therefore
the executions plans are generated without the use of index in the plans.

This feature is helpful when you want to check whether a table is better without its
index. Instead of dropping the index just make it invisible and check for performance
benifits. If you want the index back just make it visible.
Read more >>