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
What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?
Is there any report or table in which user log off time is stored in sap?
List the difference between asynchronous and synchronous transport?
What is JVM switch. Why JVM switch is required ?
what is garbage collector. is there any way to set the time to gc?
how can we set a/r a/p netting for inter company code transactions? is it possible to do? if yes, give the solution?
What are the errors you got while applying support pack?
Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance
When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
what is sox and sod in sap ?
What is “data sets” in sap?
What is an interface in SAP?
can any send unix admin doc? if u have please send it to chanduk29@gmail.com
Mention what is the difference between sdm and jspm?