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
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you implement fine-grained auditing?
Explain about your sql server dba experience? : sql server DBA
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.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what are the performance views in an oracle rac environment?
what are the benefits of flashback feature?
What is the default fill factor value? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
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?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit