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
what is role of sap administrator in pi & ep?
What is rfc connection?
The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?
How many types of work processes?
How do you check the users logs in your system and how many sessions each user is generating?
If a background job runs more than the time it should be completed normally then what actions will u take?
How to define logon groups?
Where do you download trail version of sap ecc, what is sap cal?
Do you know logon groups at which situation will be created logon group?
Explain what is the use of reference and service user in sap?
How would you troubleshoot the 'system seems slow'?
Where is the Deletion Flag or Indicator used in archiving process?
How to assign a mass Tables in Auth Group by using T-code:se54
How to set predecessor relationship between two transport requests?
What settings we have to do in EEWC while using slandalone SAP-CRM system.