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
Is there a way to perform sapgui 640 roll out using a centralized server?
How would you troubleshoot the 'system seems slow'?
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
Hello Guys, If any body looking for "SAP Vendor Invoice Management (VIM) Training", Please Contact Me,We will covers all SAP VIM topics along with end to end ICC, Document pipeline xECM, Enterprise scan etc. Email ID :kakumanusasikanth@gmail.com
How to transport objects from Production to Development?
How do you distribute the load?
What is the difference between – support package, kernel and sap note?
How to define logon groups?
How you will rate yourself in SAP, Oracle from a scale 1 - 10?
Have u applied patches what is the transaction code?
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?
How you can assign an object to 100 roles at time?
what is your project architecture?
How do you create an instance?
What is oracle Architecture?