How to make a replica of existing oracle server to another
server?
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
how can you find out if a table can be redefined?
what functionality does oracle provide to secure sensitive information?
What is replication? : sql server DBA
what is the role of dip user in our database?
internal architecture
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is logical system in sap basis
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the commands you'd issue to show the explain plan for "select * from dual"?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what are the performance views in an oracle rac environment?
What would you do with an "in-doubt" distributed transaction?
what is a user-defined lock?