Solved

Is it possible to have a physical standby database on the same server as the primary database

Posted on 2012-04-11
7
431 Views
Last Modified: 2012-04-20
I am trying to create a physical standby database on a development server. I have limited resources and am unable to create it on another server. I read somewhere that it is possible. However, I came across something that caused me concern. It seems that the oracle binaries must be installed in the standby environment. Is this true? Does anyone know the best way to create the standby on a test box?
0
Comment
Question by:sikyala
  • 3
  • 2
  • 2
7 Comments
 
LVL 23

Assisted Solution

by:David
David earned 250 total points
ID: 37832656
Interesting question, are you doing this in conjunction with your production server, or simply trying to test the setup outside of production. Each database installation requires a dedicated directory, described below -- so the key question may be whether your server has the CPU and IO resources to run multiple instances.  From ss64.com and many other sources:

Software Directories
To support the execution of multiple versions of Oracle at the same time, store each version of the Oracle Server software in a directory matching the pattern:
/ MountPoint/ StdDirectoryName/ OwnerOfDirectory/ product/ version

e.g.
/u01/app/oracle/product/9.2.0.1.0
C:\oracle\product\ora911\

Set the environment variable to match:
ORACLE_HOME=/u01/app/oracle/product/9.2.0.1.0

For Oracle 10g, the OFA recommended path is extended to:
/ MountPoint/ StdDirectoryName/ OwnerOfDirectory/ product/ version/ type[_n]
Where type is the type of Oracle home, e.g. Database (db) or Client (client), and n is an optional counter.
e.g.
/u01/app/oracle/product/10.1.0/type[_n]
This extended syntax allows you to install different products with the same release number in the same
base directory, or install the same product version more than once.
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 37832659
>>It seems that the oracle binaries must be installed in the standby environment. Is this true?

Why does this cause you conern?  You need Oralce software to run an Oracle database.

I don't see any need to create a different install.  The standby database should be able to use the same binaries ad the primary.  It is after-all just another Oracle database.

>>Does anyone know the best way to create the standby on a test box?

Follow the steps for any other standby.  Just use the same server.
0
 

Author Comment

by:sikyala
ID: 37832790
I am trying to work with limited resources. I wanted to make sure that I was able to duplicate production as much as possible and I couldn't find specific instructions for creating a standby on the same server. Reading documentation that creates standby on different server made me wonder if i needed duplicate installation in my environment. I want to use Grid control GUI to create standby.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:sikyala
ID: 37832806
my other concern was the SID
0
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 37832829
The SID will have to change.  I've not played around much with Data Guard but doesn't the SID have to change anyway?

>>if i needed duplicate installation in my environment.

The same binaries should run both instances.  There are a few blog entries out there on this topic but never having done this, I cannot say if they work or not.
0
 
LVL 23

Assisted Solution

by:David
David earned 250 total points
ID: 37832853
sikyala, when you connect to any Oracle database, your session needs the database SID and port for the listener service.  But as slight says, the actual binaries are (or should be) common.
0
 

Author Comment

by:sikyala
ID: 37833016
ok I will try it thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

830 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