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
If possible send me screenshot doc for installation of ecc6
What is the information derived from OSS notes?
Mention the use of personalized tab and parameter tab in user master record?
Is there any report or table in which user log off time is stored in sap?
what is role of sap administrator in pi & ep?
How to make security authorization reports?
What is an interface in SAP?
Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log
What is difference between oracle 9i and oracle 10g?
Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?
How to delet a table in sap. How to move a table from one location to another.
Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.
Error in the phase import_proper while applying support packages?
How you connect ECC to EP?