Answer / mohapatra.gouranga@gmail.com

Data Guard Redo Transport Services coordinate the
Log Network Server (LNS);
transmission of redo from the primary database to the
standby database, at the same time the LGWR is processing
redo, a separate Data Guard process called the Log Network
Server (LNS) is reading from the redo buffer in the SGA and
passes redo to Oracle Net Services from transmission to a
standby database, it is possible to direct the redo data to
nine standby databases, you can also use Oracle RAC and
they don't all need to be a RAC setup. The process Remote
File Server (RFS) receives the redo from LNS and writes it
to a sequential file called a standby redo log file (SRL),
the LNS process support two modes synchronous and
asynchronous.

What command would you use to create a backup control file?

2 Answers  

---

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

0 Answers  

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,

---

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---