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
I would like to know the version or name of SAP that is implemented in real time?
What are the daily transactions?
Explain domain controller?
What are the different types of job status? Can you unschedule an active job?
i want my company code and controlling area defaut as 'ABC" through out SAP what to do ? and my plantcode also default to some value
What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?
What is the purpose of table tadir?
hi friends, in sap screen with 000 client i unable to logon,with 001 client i can login but i want to log on with 000 client how i can loggin with 000 client intial screen ,please can u help me
Is it possible to install sap patches when other users are online?
suppose in the landscape there is development, quality, pre-production and production system is there. what is the route(transport route) between pre-production to production? and why?
How will u send mail after completion of backup?
Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?
can any send unix admin doc? if u have please send it to chanduk29@gmail.com
Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?
What is a support package?