What is the dataguard background process??
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.
Is This Answer Correct ? | 3 Yes | 0 No |
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
Give the reasoning behind using an index.
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What are the different types of indexes available in sql server? : sql server DBA
What type of index should you use on a fact table?
what is the use of recording information about current session?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is asm?
How can you control the amount of free space in your index pages? : sql server DBA
What is a correlated sub-query? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?