1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How to make a replica of existing oracle server to another
server?

Question Posted / kalyan maddipati

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why would you use sql agent? : sql server DBA

588

What is the default fill factor value? : sql server DBA

579

Why does Oracle not permit the use of PCTUSED with indexes?

2343

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

when does an alert gets signaled?

590




How can you control the amount of free space in your index pages? : sql server DBA

749

how does an oracle clusterware manage crs resources?

581

What is the default port no on which sql server listens? : sql server DBA

568

what do you understand by flashback feature of oracle?

568

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1532

What is a correlated sub-query? : sql server DBA

589

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.

2076

What are the different types of database compression introduced in sql server 2008? : sql server DBA

574

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1554

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

715