Oracle Software Cloning.

On Source

$ emctl stop dbconsole

$ lsnrctl stop

$ cd/u01/app/oracle/product

Read more >>

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

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

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

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