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
Solved

creating standby database on the same server--- oracle 10g database

Posted on 2009-03-31
4
978 Views
Last Modified: 2013-12-18
Anyone has experience creating the standby database on the same server.

Please note it is on the SAME SERVER on Windows
0
Comment
Question by:ballioballi
4 Comments
 
LVL 4

Assisted Solution

by:pinkuray
pinkuray earned 150 total points
ID: 24036188
Hi,
 A physical stand by can be done for oracle 10g in the same server.

If and only the archiving is not enabled then you can start the mount ,
You can use any backup copy of the primary database to create the physical standby database--for this  you use the Recovery Manager utility (RMAN).



0
 
LVL 23

Assisted Solution

by:David
David earned 150 total points
ID: 24038230
Pinkuray provides a good start, but your brevity suggests there might be more going on.  Please say more.
I could easily see value in having a cloned ORACLE_HOME to live test patches, but I will be interested in learning how such an arrangement adds value.  At best, one might shift to separate physical drives in a non-RAID environment....  Curious.
0
 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 150 total points
ID: 24040123
Physically Data Guard (former Standby DB) could be installed on the same server.

Logically it is nonsence and could be done only for testing purposes. If you Server is captured,
damaged by fire, flood or other disaster (or even plain and simple Hard Disk damage!!!!) you will loose the Primary and the Data Guard.
Even the 'only advantage' - the usage the Data Guard for reporting will not work because the load of the server.
Also two running instances will make high load of the server machine.

OK, let us think that you will dp experiments ...

Clone the database and in mount mode rename the location of all files - .dbf, control

Make a copy for standby of the control file.

Put the Primary DB in archivelog mode

Create a second destination of the Archived Logs - the standby DB

More details could be find in Data Guard manual of 10g
0
 

Accepted Solution

by:
ballioballi earned 0 total points
ID: 24210930
Thanks to everyone.
It is just for testing purposes and I agree with schwertner that it is not useful but it can be done on 10g but it is easy on different physical servers.
0

Featured Post

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.

Question has a verified solution.

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

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to take different types of Oracle backups using RMAN.

808 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