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.
- 2 Answers
- 11447 Views
- Accenture, I also Faced
- E-Mail Answers
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
Can you tell me installation procedure of SAP on UNIX
What are common background jobs that will run in your system?
If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?
list some common errors faced with jspm while updating java stcks.and solutions.
I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.
What is the difference between st06 and st03?
How you can apply sap notes to sap system?
Is there a way to perform sapgui 640 roll out using a centralized server?
How do I know what threshold values to set
can u explain step by step procedure of DB REFRESH..Ravi
What is the system's configuration required to implement SAP.
What is rfc connection?
Explain what is luw (logical unit of work)?
For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?
What is process for applying patches?
