How to make a replica of existing oracle server to another
server?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What view would you use to determine free space in a tablespace?
What is the difference between online backup & offline backup?
what are the performance views in an oracle rac environment?
How to make a replica of existing oracle server to another server?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can you get actual data change values from previous transactions in oracle?
How would you determine the time zone under which a database was operating?
How would you determine who has added a row to a table?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What questions might be they ask in managerial round in capgemini.
how can you initialize log miner?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)