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.

What is redolog file? Path?

1917

---

How would you troubleshoot the 'system seems slow'?

1125

---

Which transport directory is used to implement support package and add-ons?

1121

---

Explain the system trace?

1161

---

Is there any report or table in which user log off time is stored in sap?

1167

---

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?

2073

---

What is GRIR, GRIR effect, why it is imp, How it is analysed, What is expected out GRIR, What is auto write off & Manual GRIR write off?

3103

---

Is there a difference between user ddic and sap_all/sap_new?

1663

---

describe where they would look at the buffer statistics, and what steps they would use to adjust them?

1377

---

What is the difference between consolidation and development route ?

1415

---

what can we do if shadow instance is down and getting up in prepare phase of upgrade

2651

---

What are the types of transport queries?

1188

---

How database extend?

1972

---

I need to change the Company address parameters of a user. The path is SU01 -> -> Change - > Address Tab - > Display Icon in Company Address section. In the new screen, i see a preview section icon; on clicking which, I can change the parameters such as "Sending Country"; "Street/PO Box number" and number of lines in the resulting pop up. Here though i change the parameter "Street/PO Box number" field to 'S' ( Street has priority over PO Box), its changing again to 'P' (PO Box has priority over street) only. In the help section it is written that if we set the user parameter (tcode SU3) LND1 to the desired country we can control the user specific Sending Country with the desired value else it takes the Sending Country of the Company defined by default. But no such parameter has been given for Street/PO Box number so that we could change its value atleast there. Someone suggest me how to change the Street/PO Box number of the Address format for a user to the desired value.

5112

---

How do you solve oracle archive struck?

1981

---