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 client administration in sap system? Why do we use multiple clients in sap system?

935


How to update SAP

1579


what post steps and pre steps db refresh

2922


Which transaction do you use to check buffer statistics ?

926


Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

993


Where do you download trail version of sap ecc, what is sap cal?

861


How can you define login policy for users in sap system?

818


What is SSO? How to configure SSO?

1489


Screenshot document for solution manager installation.

1550


describe how SAP handles Memory Management?

828


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?

2082


What are the types of transport queries?

820


the difference between part number and serial number

2779


can any send unix admin doc? if u have please send it to chanduk29@gmail.com

1722


Myself Rahul am MBA(Mkt)having 1.5 years marketing experience.and in SAP-SD for 1 years experience.am looking for job.so pl anywher opening then pl let me revert.

1966