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

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?
sikyalaSenior Database AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DavidSenior Oracle Database AdministratorCommented:
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
slightwv (䄆 Netminder) Commented:
>>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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sikyalaSenior Database AdministratorAuthor Commented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

sikyalaSenior Database AdministratorAuthor Commented:
my other concern was the SID
0
slightwv (䄆 Netminder) Commented:
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
DavidSenior Oracle Database AdministratorCommented:
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
sikyalaSenior Database AdministratorAuthor Commented:
ok I will try it thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.