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
can u explain step by step procedure of DB REFRESH..Ravi
What is ocm and how to apply ocm patches?
What are the activities you done in EP?
How client refresh is different than client copy?
What is an interface in SAP?
Explain what is heterogenous system copy and homogenous system copy ?
How can I restrict the user from printing?
How would you troubleshoot the 'system seems slow'?
What is the purpose of support package?
What do you understand by executing background jobs in sap system?
describe how SAP handles Memory Management?
does the Tcode EWZ5 exist in ECC6?I'm using NW2004S SR2 abap engine and EWZ5 doesn't exist in that.so in that case what is the alternative to EWZ5?to see the list of users present in a client but not necessarily logged in and to to lock or unlock them? Thanks.
Explain what is business kpis ?
What is the importance of table t000?
What is the procedure to applying patches?