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 |
how can you generate profile of pl/sql applications to identify performance bottlenecks?
i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent
When creating a user, what permissions must you grant to allow them to connect to the database?
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
What is the default port no on which sql server listens? : sql server DBA
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
How do you trace the traffic hitting a sql server? : sql server DBA
How do you switch from an init.ora file to a spfile?
how can you find out if a table can be redefined?
What is the difference between clustered and non-clustered index? : sql server DBA
Explain the use of setting GLOBAL_NAMES equal to TRUE.
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
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)