This content has been marked as final. Show 9 replies
REDO LOG wrote:do it between two virtual machines
I have I project that consists on creating a standby database to archive the primary database in it, the problem is that I need two machines, witch is not the case for me, so I am asking if I can place the primary database in my machine and the standby database in a virtual machine (vm installed in the same machine as the primary database). This project is network project so I needed something that includes network aspects.
thanks for help
best regards Rashid
that would be a solution, but the physical resources are not enough, I run a windows xp sp3 on HP 620 (2GB RAM)
I assume that this is an academic project, not a commercial project.1 person found this helpful
2GB RAM would be insufficient to run both a Database on the Host and a Guest VM with a Database in it. The minimum you'd need is 4GB
Hemant K Chitale
thanks for replay,
exactly this is an academic project, I have installed the win xp sp3 on the vmware ans succeed to ping ips from both sides,
my question now is I will perform the standby database installation on the vm?
I mean, will the installation will be the same as the primary database? and if so how will I configure it to be the standby db? thanks for any help
best regard Rashid
you need to install the oracle software (not create a database), and do some basic configuration (init, orapw etc), before you actually create the database.
Hi thanks for replay
so I just need to install oracle software without creating the database, and create the database manually (the architecture), then modify the parameters of both primary and standby dbs?
yes.basically that is it.
create the init, restore the db(following correct procedure), create the tnsnames aliases, establish connectivity between the two machines, and that is it.
thanks for replay,
I found this article: http://www.orafaq.com/node/2030 , does it looks interesting for my project, because I haven't tried to backup a database before, I just know some administrative tasks but never look to backup how it works
Edited by: REDO LOG on Jan 2, 2013 3:44 PM
yes, that looks good.
you can use that method and avoid the backup.
if it is just for academic purposes that is fine :)
p.s. - please mark all usefull or correct comments as such.
the volunteers say thank you :)