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
in oracle script @? "?" question mark means what it indicate?
what is the procedure for java stack upgradation?
While doing implementation do you get any issues?
How would you troubleshoot the 'system seems slow'?
I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.
What is the different type of users in sap?
A transport is imported into QAS in 2 min. time the same transport when imported into PRD is taking more than 20 min. why? What to do?
can anyone tellme java instance startup sequence?
What is business kpis ?
What are the activities you done in PI?
Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com
Explain deletion flag?
How to lock or unlock a transaction code using sm01?
How to transport objects from Production to Development?
Is it possible to install ecc 5.0 as a test system and not production, without installing solution manager?