1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / tushar

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

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

What command would you use to encrypt a PL/SQL application?

1 Answers  

What is the default fill factor value? : sql server DBA

0 Answers  

What is the importance of a recovery model? : sql server DBA

0 Answers  

How would you go about generating an EXPLAIN plan?

2 Answers  




how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

How do you add a data file to a tablespace?

3 Answers  

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

how can you enable flashback feature?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories