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 |
if user calls and reports to you that his background job is taking long time, and which normally does not take so much time. What will you do?
how do you register developers?
WHEN I M TRYING FOR CREATING ROLE OF ECC6.0 IDES SO IT SHWOING DUMP ERROR: THERE IS NO MORE SPACE MEMORY BUT I HAVE INSTALLED ON 500GB HDD. PLS GIVE ME SOLUTION PLS IT'S VERY IMPORTANT & URGENT FOR ME.
What is the production system configuration in sap basis4.7EE?
When you use DB02 Transaction, You see something called as Swaps, What are they, and how the increase in swaps does affect your SAP system Performance
How to do MS SQL Server upgrade 2005 to 2008 .IF ANY ONE HAVE SCREEN SHOTS PLEASE UPDATE ON ppsr_reddy@yahoo.com
role of RFC connection in project scenarios
What is the different type of users in sap?
Do you know about oss what do you do with oss?
If java server got strucked or stopped?
how to take database backup in oracle ? how to crate a table space in oracle database ?
In nw7.1 the Jstart program is requied to start the central instance