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
What is SSO? How to configure SSO?
Do you have done System copy? What are the steps?
What is the different type of users in sap?
How to set predecessor relationship between two transport requests?
What is difference between oracle 9i and oracle 10g?
On a particular system how you can get a list of the users with development access on a particular system?
How many times bdls transaction executes for 2 clients
What is Unit Testing in SAP?
Can you change the profile parameter in the os level? Which one is advisable why?
What is the different architecture between SAP 4.7EE & ECC5.0
How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?
What is the use of profile paramater ztta/roll_area?
At os level how you can change the number of work process? How you can analyze the status of work process at os level?
Explain what is business kpis ?
What is client administration in sap system? Why do we use multiple clients in sap system?