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
I want to change five dialog work processes into batch. Where can I do this?
How do I know what threshold values to set
What are the scripts you can create for security by using LSMW??
How you can disable the ‘import all’ button on stms for the queues?
What is a background processing batch scheduler?
User wants lock ASAP then what will u do?
Explain logon groups?
What is redolog file? Path?
Explain the system trace?
My Apologies, The previous questions were concerning the Transaction ST02
What do you understand by transport management in sap basis?
how can i change access to a user who is having access for SPRO display only to change access in sPro
Have u applied patches what is the transaction code?
How do you kill a job in SAP?
At o.s level where to check for system logs of sap application?