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
For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?
How do you kill a job in SAP?
TMS Configuration?
What is the use of patches in sap system? Could you name few common patch types?
What are the different types of rfc and explain what transactional rfc is?
Do you have done System copy? What are the steps?
Explain the developer trace?
If client copy is stopped in middle, what happens if you want to start it again?
Explain how client refresh is different than client copy?
What is difference between oracle 9i and oracle 10g?
What are the DVD's Download for implementation?
How do you generate (recover) old system logs in a newly created SLOG00?
what are the pros and cons of auto extend of table spaces?
Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.
Mention what is the difference between sdm and jspm?