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 |
How to define instances and operation modes?
Myself Rahul am MBA(Mkt)having 1.5 years marketing experience.and in SAP-SD for 1 years experience.am looking for job.so pl anywher opening then pl let me revert.
Can anyone tell me How to lock a single client from sap level and from o/s level?How to lock users from o/s level.
1.how to retrive corrupt file in back up ? 2.what post actives of patching 3.how increase the file size in unix
Is it mandatory to make all the users log off while applying add-ons and s-notes as it is in the case of support packs?
What is a background processing batch scheduler?
How to increase tables space, resizing, backups and in what situation are these done?
What are the different types of rfc and explain what transactional rfc is?
How would you import a transport request at operating system Level?
How to check cpu utilization from o/s level,wat is the command.
How to monitor user accessed transactions (T-code) on a given day?
Which type of Backup and Redo log backup is performed daily? And which type of Backup and Redo log backup is performed Weekly in the organization?
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 AllOther (329)