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

Anyone has experience creating the standby database on the same server.

Please note it is on the SAME SERVER on Windows
ballioballiAsked:
Who is Participating?
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.

pinkurayCommented:
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
DavidSenior Oracle Database AdministratorCommented:
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
schwertnerCommented:
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
ballioballiAuthor Commented:
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

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
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.