Interested to Buy Any Domain ? << Click Here >> for more details...
How ORAARCH (:\oracle\DEV\oraarch) directory is
configured, what is the maximum size of
ORAARCH directory, how to see? briefly....
- 1 Answers
- 32773 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / inder09
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
Create a cron job to run a script to check percentage used /
capacity of oraarch directory. If it exceeds 80% run a
brarchive command to archive the logs.
archive directory containing all of SAP information for
backup restore purpose.
So I suggest you doing list out some questions from your
system which is the answer may impact the growth size of the
archive files in oraarch directory:
How much transaction happend by day?
Do the system doing extraction data from R3 to BW system?
are you doing reorganization table?
are you doing client copy?
Are you sure the archive backup (copy-del-save) run well
everyday?
Or you may analyze by your self the growth of the files in
oraarch directory by counting the files created by system
each day. After that you may make calculation how many
files average created each day.
Example:
created files by day (average) are 100 files (each files
20Mb by default)
so you will need:
100 x 20Mb = 2Gb => 3Gb
Always spare more space for archive directory, otherwise if
the directory
full the SAP system will stop responding.
| Is This Answer Correct ? | 21 Yes | 3 No |
Post New Answer View All Answers
What are the activities you done in EP?
What are steps for DB Refresh?
How to uncar car/sar files in a single shot?
the difference between part number and serial number
Where is the Deletion Flag or Indicator used in archiving process?
How to apply job on OS Level?
What is you allocate disks to different areas in sap?
What is the difference between developer trace, system log and system trace?
What is transport layer and domain controller? In which system you have create domain control?
Mention the use of personalized tab and parameter tab in user master record?
Explain what is heterogenous system copy and homogenous system copy ?
Can you tell me installation procedure of SAP on UNIX
Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?
What is difference between oracle 9i and oracle 10g?
what is netweaver
