how do you solve oracle archive struck?
Answers were Sorted based on User's Feedback
Answer / lalit rana
The strategy which I follow is that I will keep one big
unwanted file (1 GB) size in /oracle/<SID>/oraarch
directory. So that incase the archive struck happens I can
immediate delete the 1 GB file and I get 1GB of space
instanteously for some time and get some time to think for
a permanentely. Or simple solution is if you have space on
disk then increase the size of your mount
point /oracle/<SID>/oraarch .
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / deepak
1. (planned)by increasing the space
2. (planned)taking backup
3. moving files to different location
deepak.basis.ua@gmail.com
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / m k hazra
have to increase free space in archiving directory.
regards,
manas k hazra
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / dnyaneshwar kadam
maintain sufficient free space in ORAARCH directory.
for test execute following sql statement.
SQL> alter system switch logfile;
| Is This Answer Correct ? | 2 Yes | 1 No |
Even you have sufficient free space & you are getting error
regarding oracle archive struck the concern prob. may be
effect of a catche memory. shutdown the instance, clear the
temp, prefetch & restart the system. You can able to
successfully complete the archive.
| Is This Answer Correct ? | 1 Yes | 0 No |
At o.s level where to check for system logs of sap application?
what is the query execution process in sap r/3 architecture,if multiple queries are immediate to execute?
Mention the use of personalized tab and parameter tab in user master record?
How to Start & Start Java at OS level (Windows)
Diff between local client copy and remote client copy?
Applied basis support pack successfully when the system which is not updated in the system status? Why? How to resolve?
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
what are the main issues you faced in the implementation project?
Differentiate between synchronous and asynchronous transport
what is the difference b/w UNIX systems logs and Windows sytem logs?
When applying a support pack to sap system. Can you tell me what are errors you are faced?
How do you kill a job in SAP?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP APO PPDS (50)
SAP AllOther (329)