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 / annabathula
Redo Log:-
Redo log management plays a part in the following actions
During execution of a modifying transaction, the redo log entries are included in the log queue. The log writer writes the
log pages from the log queue to the log area.
During a Structure linklog backup, information is obtained on whether entries from the log area are to be backed up, and if
so, how many.
In the case of a restart or recovery, the required redo log entries are read from the log area.
The database parameters and other internal information that controls logging are stored in the log area and updated at
regular intervals.
Mirroring:-
It is essential to mirror the online redo log files in database. This procedure describes how you can check the mirroring
with BRSPACE. Also, the system check in BRCONNECT checks mirroring.
If you lose one or more online redo log files, you can no longer recover the database changes recorded in them. This means
that you can only recover the database up to the first gap in the online redo log records. For this reason, we strongly
recommend that you mirror the online redo log files. We recommend that you make at least one copy.
If an online redo log file of a group is lost, the database remains in operation. Oracle then uses the remaining member (or
members) of this group to log the database changes. In such a case, you must recover the original mirroring of the online
redo log files as quickly as possible.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Have you done any up gradations?
what is the common storage file for oracle ?
if i want to limit the condition record validity for forst 10 orders how can i do tht plz ans i hve interview in 2/3 days
How will go about doing a client copy ?
Do? If another user wants to share that lock but the user using that
How to analysis abap dumps?
Where do you check transport request logs?
How you can disable the ‘import all’ button on stms for the queues?
If a background job runs more than the time it should be completed normally then what actions will u take?
Where will you change the parameters in three profiles?
Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri
How to lock or unlock a transaction code using sm01?
Hi i have 2.10 yrs of experience on Sap Basis...been working as a sap basis consultant.but unable to get through MNC companies...On what criteria does HR select the candidate.does my academics matter coz they are not good thou i am a B.tech graduate
What is oracle Architecture?
what are the pros and cons of auto extend of table spaces?