Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2009-03-31
4
Medium Priority
?
999 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 600 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 600 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 600 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

636 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