How to make a replica of existing oracle server to another
server?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / rajasekar
we cant replace an existing oracle server to any other
servers becoz oracle has its own rits to develop itself
couldn't convert it
Is This Answer Correct ? | 1 Yes | 2 No |
how can you enable flashback feature?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........
what is meant by gateway
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
How do you tell what your machine name is and what is its IP address?
WHEN DOWN TIME WHAT CAN U DO?
What are the steps you will take, if you are tasked with securing an SQL Server?
How many packages we have in db
What is a correlated sub-query? : sql server DBA
When creating a user, what permissions must you grant to allow them to connect to the database?