How to make a replica of existing oracle server to another
server?
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
what is a user-defined lock?
what is grd?
Where would you look for errors from the database engine?
how can you find out if a table can be redefined?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can a session indicate its interest in receiving alerts?
what is ora 24313?what is the procedure to exclude that error?
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you record information about current session?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the recovery models for a database? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what functionality does oracle provide to secure sensitive information?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution