How to make a replica of existing oracle server to another
server?
Answer Posted / 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 |
Post New Answer View All Answers
How do you troubleshoot errors in a sql server agent job? : sql server DBA
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?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are statistics, under what circumstances they go out of date, how do you update them?
what is grd?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Query processing is slow(eg select query)how will u solve that
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is the diffrence between core dba and apps dba?
What is replication? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.