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
How do you generate (recover) old system logs in a newly created SLOG00?
How to define logon groups?
How would you troubleshoot the 'system seems slow'?
How can you view locked transactions?
Which transaction do you use to check buffer statistics ?
Which are the most frequent errors encountered while dealing with transports ?
What are the different options available for scheduling a background job? What start conditions type can be used?
What is a support package?
Is it possible to install sap patches when other users are online?
Hi ,All What is the multi-threading and max connections for rfc. Actually i am facing problem while send large amount of idocs to external system using middle ware tibco r3 adapter. And how to enable these in SAP ?
What is the difference between asynchronous and synchronous transport?
When we are doing cash sales, free goods and discount, How many pricing procedure do we need to create..? Only one PP required or have to create multiple PP..? and how many condition type we need to create..?
dear friends, HOW TO CONFIGURE INTO ABAP WEB DYNPRO AND ADOBE OF ECC6.0 R/3 IDES SYSTEM?
What is the information derived from OSS notes?
I have solman 7.1 Stack3. I want to upgrade to stack13. My question is can I directly download stack13 files from marketplace, if yes, will those files includes xml file ? (MOPZ is not configured in my system).