On Source $ emctl stop dbconsole $ lsnrctl stop $ cd/u01/app/oracle/product
Monday, February 27, 2012
Oracle Software Cloning.
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.
RMAN Catalog Creation.
Target Database: Name:orcl IP Address:192.168.1.55 Catalog Database: Name:recovery IP Address:192.168.1.200
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.
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.
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
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.
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/
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:
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.
Subscribe to:
Posts (Atom)