What is the size of oracle redo log file and what is the use
of oraarch directory in oracle?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rahul gupta
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 ? | 3 Yes | 5 No |
Can you tell me about the landscape migration to cloud ?
What is the start up Sequence of Dual stack(ABAP+ JAVA) SAP system??
how to change the owner of a file in unix
If brtools is not working how you will add datafile?
what is logical system ? how to create and why ?
HI , As an SAP BASIS member , Why do we need to monitor lock entries(SM12) and Update Errors(SM13) , wht is the trouble shooting for those ?
What is Data Dictionary ?
ecc full form
How to take a sap backup using BRTOOLS explain the procedure? When using BRTOOLS, which backup device, you are used (Drive/tape)?
What are the question will be asked on SM12(lock entries) and SM13(updates) and SM21 (system logs) transaction activities .
What is table buffer and single record buffer?
What is the difference between Set deletion flag and set deletion indicator?