Oracle Database 11g introduced the Snapshot Standby feature in Data Guard. Using this feature you can use your physical standby database to temporary process transactions. If you have a need to test out application fixes […]
Category: Oracle Database
Changing the Data Guard Protection Mode Using Oracle Enterprise Manager 11gR1 Grid Control
Oracle Enterprise Manager 11gR1 Grid Control provides a web based interface for managing a Data Guard environment. Many Data Guard management functions can be accomplished with just a few clicks of the mouse and changing […]
Changing the Data Guard Protection Mode Using the Data Guard Command Line Interface
Using the Data Guard Command Line Interface to change the Data Guard Protection mode is a simple and efficient process. This document will detail the steps using DGMGL to change to all three Data Guard […]
Changing the Data Guard Protection Mode
Oracle Data Guard provides three modes to protect the data in the primary database. While each provide a high degree of data protection they each have a different effect on both the availability and performance […]
Switchover to a Physical Standby using the Data Guard Command Line Interface
The Data Guard Command Line Interface can be used to manage your Data Guard environment through the command line. Using the Data Guard Command Line Interface, dgmgrl, you can manage the broker configuration along with […]
Switchover to a Physical Standby using Oracle Enterprise Manager 11gR1 Grid Control
A switchover can be used to reduce downtime for planned outages such as patching to the database or host OS and hardware upgrades. In a switchover the primary database is transitioned to the standby role […]
Data Guard Switchover to a Physical Standby
A switchover can be used to reduce downtime for planned outages such as patching to the database or host OS and hardware upgrades. In a switchover the primary database is transitioned to the standby role […]
Data Guard Standby Archive Destination Full
Problem: You notice the following error in the alert.log of the Data Guard Standby database. Your Standby is configured to write its archive logs to the Fast Recovery Area. Solution: You have several of options […]
Quick RMAN configuration for disk based backups
This document will detail a quick set up of RMAN for disk based backups using Oracle Database 11gR2 base.
Introduction to the High Availability Console in Oracle Enterprise Manager 11gR1 Grid Control
The High Availability Console provides the administrator comprehensive information about the primary and standby databases in a dashboard format. On one page you can see information about availability events, redo rates, transport and apply lag […]
Create a Physical Standby Database using Oracle Enterprise Manager 11gR1 Grid Control
Oracle Enterprise Manager 11gR1 Grid Control greatly simplifies the creation of physical or logical standby databases. The Add Standby Database wizard provides a quick way to get a Standby database up and running in record […]
Clone a Database to Another Host using Enterprise Manager 11gR1 Grid Control
This document will detail the steps to clone a database to another host using Oracle Enterprise Manager 11gR1 Grid Control.
Building OCI and OCCI applications in NetBeans 6.8
This document will detail the configuration options needed in order to compile OCI and OCCI applications using NetBeans 6.8.
Linux Error 111: Connection refused
When attempting to start the listener you get an error like the one below.
SET AUTOTRACE fails with error SP2-0618
Problem: You attempt to set autotrace and receive the following error message. Solution: The user executing AUTOTRACE needs to have the PLUSTRACE role. By default the PLUSTRACE role does not exist and can be created […]
Deferred Segment Creation
Starting with Oracle Database 11gR2 when you create an empty heap organized table in locally managed tablespace segment creation is deferred until the time in which the first row is inserted. Segment creation is also […]
Restore database to another host using RMAN
This document will detail the steps to restore a database on a new host using RMAN. For this demonstration we will be using Oracle Database 11gR2 on Linux and disk based backup.
Recover from a corrupt or missing control file
This document will detail recovery scenarios dealing with missing or corrupted control files using RMAN disk based backups.
Multiplexing Control Files
This document will detail multiplexing of control files. Having multiple control files reduces the risk of control file loss due to corruption or accidental removal. In the case of corruption or loss recovery is no […]
Error: cannot restore segment prot after reloc: Permission Denied
When attempting to use SQL*Plus or other OCI based programs on either Red Hat Enterprise Linux or Oracle Enterprise Linux 5.0 or greater you receive errors such as the following.