How to make a replica of existing oracle server to another
server?
- 3 Answers
- 5702 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
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.
Why does Oracle not permit the use of PCTUSED with indexes?
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
What the different types of replication and why are they used? : sql server DBA
what are the performance views in an oracle rac environment?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you connect from 10g user to 11g user??
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is the default port no on which sql server listens? : sql server DBA
how can you create a user-defined lock?
how can you record information about current session?
What is replication? : sql server DBA
how does an oracle clusterware manage crs resources?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
