Solved

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

Posted on 2009-03-31
4
987 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
[X]
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
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

705 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