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
What is you allocate disks to different areas in sap?
Explain transport domain?
How do you check the users logs in your system and how many sessions each user is generating?
Mention what is the difference between sdm and jspm?
How can you find a list of objects that have been repaired in the system?
what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?
what post steps and pre steps db refresh
what is the difference b/w 4.7EE & ECC5.0?
I'm getting the following runtime error in IDES "DYNPRO_MSG_IN_HELP". GUI is 720 final release and patch level:0
What are the scripts you can create for security by using LSMW??
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
What are the tools to install java patches?
What are the regular activities u do in solution manager and how
If brtools is not working how you will add datafile?
How can you define login policy for users in sap system?