- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: while large deletes in database following erro...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-25-2003 11:37 PM
тАО06-25-2003 11:37 PM
ARC1: Failed to archive log# 3 seq# 18165
ARC1: Beginning to archive log# 2 seq# 18166
Thu Jun 26 08:24:15 2003
ARC0: Completed archiving log# 3 seq# 18165
Thu Jun 26 08:24:15 2003
ARC2: Beginning to archive log# 2 seq# 18166
ARC2: Failed to archive log# 2 seq# 18166
Thu Jun 26 08:24:22 2003
ARC1: Completed archiving log# 2 seq# 18166
above error were noticed in alert log
oracle 8.1.7.3 on hp ux 11.11
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-25-2003 11:43 PM
тАО06-25-2003 11:43 PM
Solutionthese are not error, are just warning.
They mean that you were generating so many archive that the arc process were not able to save them.
In fact, you can see that after a while you get a "Completed" for each fo them.
Since you were working so much, oracle spawned ARC0 (default), ARC1 and ARC2 for a faster archiving. Until the redolog is saved, and become and archive log, you cannot reuse it.
If you plan to have often such large operation, i suggest you to enlarge your redo log, so you will see these message not often.
HTH,
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-25-2003 11:47 PM
тАО06-25-2003 11:47 PM
Re: while large deletes in database following error were observed in alert log file
thanks a lot
does log_archive_trace parameter can help in avoiding this messages in alert logfile &
my current logfile size is 104mb and we have 3 logfile in our database
shall i add two more logfile or shall i resize the existing logfile to 150mb
regards
fenil manek
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2003 12:04 AM
тАО06-26-2003 12:04 AM
Re: while large deletes in database following error were observed in alert log file
The log_archive_trace parameter will help you understand more about the whole log archive process in the system, but not fix it.
Kenneth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2003 12:12 AM
тАО06-26-2003 12:12 AM
Re: while large deletes in database following error were observed in alert log file
SELECT * FROM V$ARCHIVE_DEST;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2003 01:56 AM
тАО06-26-2003 01:56 AM
Re: while large deletes in database following error were observed in alert log file
a. there is no command to RESIZE a log file. You must DROP and CREATE them:
alter database drop logfile '.......';
alter database add logfile ....;
b. Check your logs
select group#,members, status from v$log;
Seems like one of yours is STALE!
It should show something like:
GROUP# MEMBERS STATUS
__________ __________ ________________
1 1 CURRENT
2 1 INACTIVE
3 1 INACTIVE
If you see any STALE, just do 4:
alter system switch logfile;
c.
As for the sizing of redolog files:
I myself start with 3 groups of 2 members of 25meg apiece and work up from there. Either adding more groups or making the members larger until I have enough online redo log to get me through at least 15-20 minutes of work without switching. As with all rules of thumb -- there will be times when 15-20 minutes is too long and too short. You need to pick your time and go from there.
I would recommend that you generate 100 50byte transactions or 100 500k transactions per minute.
You figure out your redo generation rate and use that to help you size it. I generally just add logs until it goes away. Not very scientific but brutally effecient.
hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-26-2003 02:32 AM
тАО06-26-2003 02:32 AM
Re: while large deletes in database following error were observed in alert log file
besides tips from the other, i suugest to have a higher number of redo logs.
Having bigger redo logs is better for big transaction, like a big delete, but if you have many small transaction, increasing the number would be better.
HTH,
Massimo