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

how can you get actual data change values from previous transactions in oracle?

1088

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1197

---

What is fill factor? : sql server DBA

1247

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2618

---

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

1103

---

How would you extract DDL of a table without using a GUI tool?

2488

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1067

---

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.

2567

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1044

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2435

---

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

1313

---

What is dcl? : sql server DBA

1267

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2336

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1905

---

How do you open a cluster administrator? : sql server DBA

1100

---