Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 394 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Archiver hnug log error
user5856470
Member Posts: 19
I am getting this error through Oracle Enterprise Manager for my Production RAc database
It has been working fine for ages. Its just suddenly started doing this.
The archiving is hung? Please can someone help explain what I need to do to resolve or if already ersolved. I'll know if its resolved as new archiving will be written in 1 days time otherwise it complain again when it tries to write to the archiving???
SEVERITY
critical
CATEGORY
Archiver Hung Alert Log Error
TIME
11-Sep-2008 23:02:43
ALERT LOG STACK
ORA-16038: log 3 sequence# 1351 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 2: '/u02/logs/gbprod01/redo03a.log'
ORA-00312: online log 3 thread 2: '/u02/logs/gbprod01/redo03b.log'
Trace File: /opt/app/oracle/admin/gbprod01/udump/gbprod012_ora_21265.trc
ALERT TRIGGERED
11-Sep-2008 23:14:15
The disk where the archiving would be written has plenty of space and full write access.
$>df -kh /u03
/dev/sdd 300G 186G 115G 62% /u03
$>ls -ltr /u03/arch/gbprod01
drwxr-xr-x 1 oracle oinstall 131072 Jun 12 2007 gbprod011
Please can someone help as to what I need to do or whether it has resolved itself.
FYI
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u03/arch/ddprod01/ddprod011
Oldest online log sequence 1326
Next log sequence to archive 1327
Current log sequence 1327
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- -------------------
1 1 1327 52428800 2 NO CURRENT
7883970584 11.09.2008 23:02:38
2 1 1326 52428800 2 YES INACTIVE
7883951113 11.09.2008 22:00:40
3 2 1351 52428800 2 YES INACTIVE
7883967749 11.09.2008 23:00:35
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- -------------------
4 2 1352 52428800 2 NO CURRENT
7883970586 11.09.2008 23:02:38
I'm also getting this in the trac file however this has been happening since the 7th of Sept and the problem has happened today. So this may be another issue.
LGWR: Archivelog for thread 1 sequence 1261 will NOT be compressed
*** 2008-07-31 17:14:16.863
...
...
...
*** 2008-09-11 23:02:38.163
LGWR: Archivelog for thread 1 sequence 1327 will NOT be compressed
Thank you in addvance.
Talha
It has been working fine for ages. Its just suddenly started doing this.
The archiving is hung? Please can someone help explain what I need to do to resolve or if already ersolved. I'll know if its resolved as new archiving will be written in 1 days time otherwise it complain again when it tries to write to the archiving???
SEVERITY
critical
CATEGORY
Archiver Hung Alert Log Error
TIME
11-Sep-2008 23:02:43
ALERT LOG STACK
ORA-16038: log 3 sequence# 1351 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 2: '/u02/logs/gbprod01/redo03a.log'
ORA-00312: online log 3 thread 2: '/u02/logs/gbprod01/redo03b.log'
Trace File: /opt/app/oracle/admin/gbprod01/udump/gbprod012_ora_21265.trc
ALERT TRIGGERED
11-Sep-2008 23:14:15
The disk where the archiving would be written has plenty of space and full write access.
$>df -kh /u03
/dev/sdd 300G 186G 115G 62% /u03
$>ls -ltr /u03/arch/gbprod01
drwxr-xr-x 1 oracle oinstall 131072 Jun 12 2007 gbprod011
Please can someone help as to what I need to do or whether it has resolved itself.
FYI
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u03/arch/ddprod01/ddprod011
Oldest online log sequence 1326
Next log sequence to archive 1327
Current log sequence 1327
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- -------------------
1 1 1327 52428800 2 NO CURRENT
7883970584 11.09.2008 23:02:38
2 1 1326 52428800 2 YES INACTIVE
7883951113 11.09.2008 22:00:40
3 2 1351 52428800 2 YES INACTIVE
7883967749 11.09.2008 23:00:35
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- -------------------
4 2 1352 52428800 2 NO CURRENT
7883970586 11.09.2008 23:02:38
I'm also getting this in the trac file however this has been happening since the 7th of Sept and the problem has happened today. So this may be another issue.
LGWR: Archivelog for thread 1 sequence 1261 will NOT be compressed
*** 2008-07-31 17:14:16.863
...
...
...
*** 2008-09-11 23:02:38.163
LGWR: Archivelog for thread 1 sequence 1327 will NOT be compressed
Thank you in addvance.
Talha
Answers
-
what's in the trace file
/opt/app/oracle/admin/gbprod01/udump/gbprod012_ora_21265.trc -
Have a look here.. it might help ?
http://arjudba.blogspot.com/2008/07/database-startup-fails-with-error-ora.html -
Which version of oracle are you running?
What does this show?SQL> show parameter recovery
-
Your disk may have space, but what is the setting of db_recovery_file_dest_size?
Bottom line, you need to backup those archive log files then delete them. This is what rman was made to do. -
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u03/backups/
db_recovery_file_dest_size big integer 40G
recovery_parallelism integer 0
however the archive log list shows the archiving is set to go to
/u03/arch/gbprod01/gbprod011 ( shown previously) So db_recovery_file_dest should be irrelevant shouldn't it?
Thanks in advance. -
rman is set to remove archives after it backs up.
However complaining though seemingly space there. -
try this mate,
You need to do this in RMAN, not SQLPlus. The following commands will delete your archivelogs from your flash recovery area so please make sure that everything is backed up first:
RMAN> connect target sys/*******
RMAN> delete archivelog all;
RMAN>crosscheck archivelog all;
should help you. -
The "archive log list" output indicates "/u03/arch/ddprod01/ddprod011" (ddprod) as the destination
but your "df" and "ls" listings are for "/u03/arch/gbprod01/gbprod011" (gbprod)
Are they the same directory/filesystem ? -
Had enough space in directory though it was complaining about not able to write to the location log. So we tried copying a large file in the same location which worked.
So then we did a few
SQL>alter system switch logfile;
Which forced a log switch and subsequently put the redo in archive logs.
We have an archive log as of today after the log switches in the archive log location where it was previously complaining.
Hence problem resolved. Maybe it just complained in OEM temporerily, and it remains there as an error message though resolved. Need to remove error from OEM manually.
Thank You for all your suggestions anyway.
Safi -
Quite possible. Any time you get an alert in OEM, you'd do well to take a look at the current situation in the alert log itself.
Also, I've seen situations in some nix systems where deleting a file didn't necessarily release the space. Never learned the details as the SA's at that company were very closed about everything, and now I don't even remember which nix it was, as we had Solaris, HP, and AIX.
This discussion has been closed.