Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Dataguard, documentation/scripts for non-DBAs during failover

Posted on 2007-05-23
Medium Priority
Last Modified: 2013-12-18
We're looking at implementing Dataguard as part of an implementation of Documentum (a document management system from EMC) and I have been asked to look at producing documentation and scripts for non-DBA users to use during a failover.  The actual failover of the database itself will be handled by our DBAs, this is for the sys admins, network admins, application admins &c who may need to do things during fail over.

I'm currently going through the Dataguard concepts guide and have found some other documentation on OTN but was hoping that someone with more knowledge of Dataguard could point me towards any documentation that might help with the non-Oracle side of failover.  If anyone has any documentation/scripts like this they have prepared themselves that they are prepared to share and I could adapt to our environment then I'd be very grateful.

Here is the background:

We have a pair of IBM p590 servers, currently sitting in different parts of the same datacentre but (hopefully) one will be moving to a different site in the near future.  Each will run both primary and standby environments, one running the standbys for the primaries on the other.  Each environment will run in a virtual server.

The Documentum service runs in an N-Tier configuration:

Presentation layer/
Application/Business logic layer
Metadata/Storage layer

The presentation layer is either a fat client running on local PCs or a web front end running in Tomcat that the users can access via a browser.  The application/business logic layer is the Documentum application running in Oracle Application Server 10g.  The metadata/storage layer consists of an Oracle 10g database and filesystem storage on IBM storage devices.

Additionally on the application/business logic layer there are interfaces to SAP provided by Documentum Services for SAP running on a separate Windows 2003 server and scanning stations and servers, these connect to the Documentum application.

Users do not access the database directly, nor do any other services, all access is via the application.

When a document is added to the repository (via the presentation layer, Services for SAP or scanned) it is rendered to PDF and added to a filestore on the storage (i.e. the file is saved to a directory), metadata about the document (title, location, categories, key words &c) are stored in the Oracle database.

The filestore will be synced from primary to standby by either IBM Flashcopy or IBM Metro Mirror, the metadata will be synced by Oracle Dataguard.  Due to the way Documentum handles inconsistency between the metadata and the filestore (i.e. documents in one that are not in the other) the metadata sync will always lag behind the filestore sync (if there's metadata for a non-existant document then the metadata can easily be found and deleted but if there's no metadata for an existing document it's a bigger job to find the document, an analogy would be looking up words in a  book's index to find them in the book vs checking each word in a book to see if it's in the index).
Question by:stephenbooth_uk
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 48

Expert Comment

ID: 19142314
Dataguard failover procedures could be done only
by experienced DBA.
The part that is outside the Oracle DB comprises
of different Application servers (possibli Oracle Application server
also has an Infrastructure DB).
So you have to prepare installations media and instructions
how to install from scratch these components.
Additionaly you have to have copies of the scripts and
instruction where to copy these scripts.
You see - it is a complex task.

Author Comment

ID: 19142515
To clarify.

The failover of the database itself will be handled by the DBA team.  I have been asked to produce documentation for any changes that need to be made outside the database.  All the documentation I can find ignores anything outside the database.  Clearly there will need to be activities outside of the database when a failover or switchover takes place, the obvious one that comes to mind is pointing the clients to the new server.  I haven't been able to find anything about that.

Possible solutions that come to mind for pointing the clients to the new server are:
* Edit the TNSNAMES.ORA files.  This would be possible in this set up as we only have a few boxes (application servers, scanning servers and Services for SAP servers) that connect to these databases.  If the number of boxes increases significantly then it might no longer be possible, anyhow I prefer to avoid manual processes as I know how easy it is to miss something when you're under pressure.  
* Use a unique hostname for each database and have a DNS entry (so if database ORCL1 is on server bigprod, IP address, then we have a DNS entry orcl1 which resolves to and use that in the Net8 settings for the ORCL1 service).  This was proposed in another project and may get implemented.  The downside is it means involving a directories person in a fail/switch over.
* Use OID for database names resolution.  Probably the ideal solution but also means implementing another extra technology, and paying for it.  On the other hand we do have a plan to implement OID at some point in the future so we will probably use this eventually.

Accepted Solution

Computer101 earned 0 total points
ID: 22350332
PAQed with no points refunded (of 500)

EE Admin

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question