What is the size of oracle redo log file and what is the use
of oraarch directory in oracle?

Answer Posted / inder09

oracle redo log files do not dynamically grow when more
space is needed for redo entries; they have a fixed size (on
SAP systems,typically 50MB). When the current online redo
log file becomes full, the log writer process closes this
file and starts writing into the next one. This is called a
log switch.

oraarch
Offline redo log files are written to the oraarch directory;
their names are specified with help of Oracle instance
configuration parameters, so the name <DBSID>arch1_<LSN>.dbf
is just an example. Moreover, offline redo log files should
be stored on a mirrored disk to prevent loss of redo
information. A RAID system can be used for this purpose.
If u loose a disk containing offline redo logs and data files,
complete recovery is no longer possible. Therefore, offline redo
logs and data files should be on different disks!

Is This Answer Correct ?    24 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a support package? What is its purpose?

877


Mention the use of personalized tab and parameter tab in user master record?

975


How to see when were the optimizer stats last time run?

905


What is MySAP?

917


What are the different types of rfc?

881


What is the different architecture between SAP 4.7EE & ECC5.0

2815


Explain what is business kpis ?

922


please share sap basis admin interview questions .. thanks sadik

1147


What is purpose user group in SU01?

2772


I would like to know the version or name of SAP that is implemented in real time?

910


Difference between system refresh and client copy?

2581


Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri

1640


What is an “ok” code is and what is the difference between “t-code” and “ok” code?

956


I want to let sap skip printing cover pages during printing for any kind of report. How can this be done?

937


the difference between part number and serial number

2834