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


Please Help Members By Posting Answers For Below Questions

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

2981


What is the difference between dropping a database and taking a database offline? : sql server DBA

588


What are the different ways you can create databases in sql server? : sql server DBA

605


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2401


How to start SQL Server in minimal configuration mode?

6968






How would you go about verifying the network name that the local_listener is currently using?

2768


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1735


Can you redefine a table online?

686


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1973


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

622


what is the use of ocr?

606


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?

2010


how can you communicate with operating system files from oracle?

569


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

609


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

3813