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 |
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Give two examples of how you might determine the structure of the table DEPT.
How to make a replica of existing oracle server to another server?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
What view would you use to look at the size of a data file?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the operating modes in which database mirroring runs? : sql server DBA
In oracle 10g export, import if we declare rows=y/n what would be the output?
What command would you use to encrypt a PL/SQL application?
How would you determine the time zone under which a database was operating?