Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00332 - archived log is too small - may be incompletely archived

Serch-NETAug 27 2007 — edited Aug 27 2007
Hi, i have a problem with a physical standby database, the apply process is stoped, the databas is version 9.2.0.7.0 on Solaris 10. I received the the next errors into the alert logfile, What can i do??

Thanks for your help.

Regards.


Media Recovery Waiting for thread 1 seq# 16958 (in transit)
Media Recovery Log /dbf/dbnte01/oralogs/archivelogs/dbnte01_1_16958.dbf
Media Recovery Waiting for thread 1 seq# 16959 (in transit)
Media Recovery Log /dbf/dbnte01/oralogs/archivelogs/dbnte01_1_16959.dbf
Media Recovery Waiting for thread 1 seq# 16960 (in transit)
Media Recovery Log /dbf/dbnte01/oralogs/archivelogs/dbnte01_1_16960.dbf
Fri Aug 24 06:57:37 2007
Media Recovery Waiting for thread 1 seq# 16961 (in transit)
Fri Aug 24 16:51:51 2007
RFS: Possible network disconnect with primary database
Closing latent archivelog for thread 1 sequence 16961
EOF located at block 102401 low SCN 1510:-1868154783 next SCN 1510:-1868154783
Latent archivelog '/dbf/dbnte01/oralogs/archivelogs/dbnte01_1_16961.dbf'
If you wish to failover to this standby database, you should use the
following command to manually register the archivelog for recovery:
ALTER DATABASE REGISTER LOGFILE '/dbf/dbnte01/oralogs/archivelogs/dbnte01_1_16961.dbf';
Fri Aug 24 16:51:51 2007
Errors in file /sfw/oracle/admin/dbnte01/udump/stnte01_rfs_15414.trc:
ORA-00367: checksum error in log file header
ORA-00332: archived log is too small - may be incompletely archived
ORA-00334: archived log: '/dbf/dbnte01/oralogs/archivelogs/dbnte01_1_16961.dbf'
ORA-12161: TNS:internal error: partial data received
Fri Aug 24 18:58:05 2007
Fetching gap sequence for thread 1, gap sequence 16961-16961
Trying FAL server: (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=sunvk05)(PORT=1521)))(CONNECT_DATA=(SID=dbnte01)(SERVER
=DEDICATED)))
Fri Aug 24 19:03:40 2007
Failed to request gap sequence. Thread #: 1, gap sequence: 16961-16961
All FAL server has been attempted.
Fri Aug 24 21:07:24 2007
Shutting down instance: further logons disabled
Fri Aug 24 21:07:30 2007
MRP0: Background Media Recovery user canceled with status 16037
Recovery interrupted.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2007
Added on Aug 27 2007
2 comments
986 views