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 are statistics, under what circumstances they go out of date, how do you update them?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what are the types of connection load-balancing?
Can we take incremental backups in datapump?
what is the difference between catalog & nocatalog?
What is the default port no on which sql server listens? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
how does an oracle clusterware manage crs resources?
Why would you call update statistics? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
When creating a user, what permissions must you grant to allow them to connect to the database?
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)