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 |
what is static profiles and dynamic profiles?
Advantage of central instance on application server
what can we do if shadow instance is down and getting up in prepare phase of upgrade
What is the difference between installing SAP R/3 and installing a SAP CRM system? OR, what are the installation steps for i) Installing an SAP R/3 and ii) Installing SAP CRM /SAP PLM/SAP business suite?
How to perform the transport?
How to do transport's between Production and Development?
what is SAPMNT?
How many default clients are available with SAP
20 Answers Cap Gemini, Satyam,
What is Remote Transaction Processing?
Tell me steps for support pack installation in ecc6?
Do? If another user wants to share that lock but the user using that
Have you participated in Kernel upgrading and OCS Patches?