what is the difference between re-do and mirror log?
How it is related with database backup?
Please explain the database backup concept in detail.

Thanks in advance.:)
regards
preeti.

Answer Posted / devd

In the Oracle RDBMS environment, redo logs comprise files in
a proprietary format which log a history of all changes made
to the database. Each redo log file consists of redo
records. A redo record, also called a redo entry, holds a
group of Change vectors, each of which describes or
represents a change made to a single block in the database.
For example, if a user UPDATEs a salary-value in a table
containing employee-related data, the DBMS generates a redo
record containing change-vectors that describe changes to
the data segment block for the table. And if the user then
COMMITs the update, Oracle generates another redo record and
assigns the change a "system change number" (SCN).

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference b/w 4.6c & 4.7EE?

1823


What is difference between oracle 9i and oracle 10g?

1333


I also wanna work with Webdynpros? What are the requirements? I mean SAP 4.7 ee or ECC 5 or 6? Netweaver developer Studio? Also with win 2003 i have the activation problem every month. SO do i get a cd that doesnt ask for the activation? i have win 2000 but can it be installed on HP pavilion laptops that are coming preinstalled with Vista OS?

1872


Explain what is business kpis ?

636


Can you tell me installation procedure of SAP on UNIX

1969






If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log

1691


what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?

11583


What is sap market place?

618


Differentiate between synchronous and asynchronous transport

654


Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.

1889


What are the key responsibilities of sap basis administrator?

617


If you have a long-running Job, how do you analyse?

741


Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri

1442


Explain the system trace?

631


the difference between part number and serial number

2535