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
Is it possible to install sap patches when other users are online?
What is the use of patches in sap system? Could you name few common patch types?
Have u applied patches what is the transaction code?
Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?
Hi,My name is Saurabh I have done BMS & currently working in Wipro BPO (1 year). I want to pursue my career in SAP. As I am totally new in the IT field(no course & no experience) Please could you suggest whether to do a certification from Certified institutes or Non Certified institutes.What is the difference? Also, Is MBA necessary to do certification from Certified institutes?
What is the procedure to applying patches?
Do you have done System copy? What are the steps?
Where is the Deletion Flag or Indicator used in archiving process?
I want to change five dialog work processes into batch. Where can I do this?
What is client administration in sap system? Why do we use multiple clients in sap system?
How database extend?
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
Explain what is the importance of table t000?
What is rfc connection?
How to update SAP