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 |
Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?
Hi Al I have a small querry in SAP there are different type of Users one of them is System User I want to know why the system user is created and if created what is use of them and how they are associated with the Dialogue User ,As we all know Dialogue user can perform all work in Sap by logging in the sap server , so why the system user is created and how they are associated with Dialogue user With Rgds
What is transport layer and domain controller? In which system you have create domain control?
What will you do when spool process fails?
how to check network among Central Instance, Application Server, Database Instance?
how will you check whether database active or not from OS level?
Diff between local client copy and remote client copy?
How can you define login policy for users in sap system?
What is password policy?
How to transport users from one client to another?
what to do, if a workprocess is in hold status
In sap basis what are the different types of transport requests?