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


Please Help Members By Posting Answers For Below Questions

If possible send me screenshot doc for installation of ecc6

1502


What is the information derived from OSS notes?

6578


Mention the use of personalized tab and parameter tab in user master record?

955


Is there any report or table in which user log off time is stored in sap?

882


what is role of sap administrator in pi & ep?

1874


How to make security authorization reports?

1893


What is an interface in SAP?

996


Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?

2206


If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log

1883


What is difference between oracle 9i and oracle 10g?

1525


Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?

1332


How to delet a table in sap. How to move a table from one location to another.

2032


Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.

2425


Error in the phase import_proper while applying support packages?

1543


How you connect ECC to EP?

1817