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
what is a crs resource?
how can you find out if a table can be redefined?
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 generate profile of pl/sql applications to identify performance bottlenecks?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
which background process invoke at the time of upgradation tell me???
what is the role of dip user in our database?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
who owns the operating system files created by the utl_file package?
what do you understand by fine-grained auditing?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is a correlated sub-query? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?