How to make a replica of existing oracle server to another
server?

Answers were Sorted based on User's Feedback



How to make a replica of existing oracle server to another server? ..

Answer / kalyan maddipati

you mean to say that the same Oracle database should be at another place and what all the changes made to the Parent database should reflect on the child database? If U wanna that then it is know as parallel servers till 9.0 but from 10G we have the same concept with another name data guard.

Is This Answer Correct ?    1 Yes 0 No

How to make a replica of existing oracle server to another server? ..

Answer / pavana kumar.s

If the server is a linux box means,
Without Sychronization:
1.Just tar the oracle_base path and untar it on another server. This copies the databse including the oracle software.
2.Otherwise do the rman cloning.

With Synchronization:
Try to configure the Dataguard.

Is This Answer Correct ?    0 Yes 0 No

How to make a replica of existing oracle server to another server? ..

Answer / rajasekar

we cant replace an existing oracle server to any other
servers becoz oracle has its own rits to develop itself
couldn't convert it

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB Administration Interview Questions

how can you enable flashback feature?

0 Answers   Oracle,


Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  


I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  


what is meant by gateway

1 Answers   IBM,






Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  


How do you tell what your machine name is and what is its IP address?

4 Answers  


WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,


What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,


How many packages we have in db

1 Answers   Tesco,


What is a correlated sub-query? : sql server DBA

0 Answers  


When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  


Categories