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 |
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
How do you tell what your machine name is and what is its IP address?
What is the importance of a recovery model? : sql server DBA
what is the role of dip user in our database?
When creating a user, what permissions must you grant to allow them to connect to the database?
what is asm?
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
Explain CREATE DATABASE syntax?
How can you enable a trace for a session?
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)