Solved

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

Posted on 2009-03-31
4
974 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 47

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

Title # Comments Views Activity
report returning null 21 96
SQL Retrieve Values 4 70
How do I call MySQL Stored Procedure from oracle using HS link ? 5 46
Use of Exception to end a Loop 3 33
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to recover a database from a user managed backup

809 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