Home » Server Options » Data Guard » log archive miss (oracle, 8i, windows 2003 server)
log archive miss [message #599200] Tue, 22 October 2013 23:45 Go to next message
shahidjee7
Messages: 11
Registered: December 2010
Location: Pakistan
Junior Member
Dear All,

i have found an issue regarding log archiving on dest1. yesterday one sequence number 76871 not archive to dest1.alert logfile content as follow. please help. i configure standby and ship archive manually with window copy command. i need this archive to complete recovery on standby database.


Mon Oct 21 09:29:28 2013
ARC2: Completed archiving log# 3 seq# 76869
Mon Oct 21 09:39:28 2013
Thread 1 advanced to log sequence 76871
Current log# 2 seq# 76871 mem# 0: D:\ORACLE\ORADATA\ORC1\REDO02.LOG
Mon Oct 21 09:39:28 2013
ARC1: Beginning to archive log# 1 seq# 76870
ARC1: Completed archiving log# 1 seq# 76870
Dump file D:\oracle\admin\orc1\bdump\orc1ALRT.LOG
Mon Oct 21 10:01:18 2013
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, v.4354, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 67108864
large_pool_size = 10485760
java_pool_size = 20971520
control_files = D:\oracle\oradata\orc1\control01.ctl, D:\oracle\oradata\orc1\control02.ctl, D:\oracle\oradata\orc1\control03.ctl
db_block_buffers = 8192
db_block_size = 8192
compatible = 8.1.0
log_archive_start = TRUE
log_archive_dest_1 = location=d:\Archive\ mandatory reopen=5
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = FALSE
distributed_transactions = 500
instance_name = orc1
service_names = orc1
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 29360128
sort_area_retained_size = 65536
db_name = orc1
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = D:\oracle\admin\orc1\bdump
user_dump_dest = D:\oracle\admin\orc1\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Mon Oct 21 10:01:22 2013
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=14
Mon Oct 21 10:01:23 2013
ARCH: STARTING ARCH PROCESSES COMPLETE
Mon Oct 21 10:01:23 2013
ARC0: Archival started
Mon Oct 21 10:01:23 2013
alter database mount exclusive
Mon Oct 21 10:01:30 2013
Successful mount of redo thread 1, with mount id 1461294521.
Mon Oct 21 10:01:30 2013
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Oct 21 10:01:30 2013
alter database open
Beginning crash recovery of 1 threads
Mon Oct 21 10:01:33 2013
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 76871 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORC1\REDO02.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 76872 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ORC1\REDO01.LOG
Mon Oct 21 10:01:36 2013
Thread recovery: finish rolling forward thread 1
Thread recovery: 167 data blocks read, 122 data blocks written, 2047 redo blocks read
Crash recovery completed successfully
Mon Oct 21 10:01:38 2013
Thread 1 advanced to log sequence 76873
Thread 1 opened at log sequence 76873
Current log# 1 seq# 76873 mem# 0: D:\ORACLE\ORADATA\ORC1\REDO03.LOG
Successful open of redo thread 1.
Mon Oct 21 10:01:42 2013
SMON: enabling cache recovery
Mon Oct 21 10:01:42 2013
ARC0: Beginning to archive log# 3 seq# 76872
ARC0: Completed archiving log# 3 seq# 76872
Mon Oct 21 10:01:45 2013
SMON: enabling tx recovery
Mon Oct 21 10:02:15 2013
Completed: alter database open
Dump file D:\oracle\admin\orc1\bdump\orc1ALRT.LOG
Mon Oct 21 10:22:34 2013

regards
shahid
icon5.gif  Re: log archive miss [message #599221 is a reply to message #599200] Wed, 23 October 2013 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the 10 last lines of "select sequence#, archived, resetlogs_time, first_time, next_time from v$archived_log;".
Post the result of "select group#, sequence#, archived, status from v$log order by group#;"
Post the result of "select group#, status, member from v$log order by group#, member;"

Before configure your nls_date_format to display the time part of dates.


Re: log archive miss [message #599235 is a reply to message #599221] Wed, 23 October 2013 02:47 Go to previous messageGo to next message
shahidjee7
Messages: 11
Registered: December 2010
Location: Pakistan
Junior Member
select sequence#, archived, resetlogs_time, first_time, next_time from v$archived_log;

SEQUENCE# ARCHIVED RESETLOGS_TIME FIRST_TIME NEXT_TIME
77167 YES 10:21:33 AM 12:19:28 PM 12:29:28 PM
77166 YES 10:21:33 AM 12:09:28 PM 12:19:28 PM
77165 YES 10:21:33 AM 11:59:28 AM 12:09:28 PM
77164 YES 10:21:33 AM 11:49:28 AM 11:59:28 AM
77163 YES 10:21:33 AM 11:49:15 AM 11:49:28 AM
77162 YES 10:21:33 AM 11:39:28 AM 11:49:15 AM
77161 YES 10:21:33 AM 11:29:28 AM 11:39:28 AM
77160 YES 10:21:33 AM 11:19:28 AM 11:29:28 AM
77159 YES 10:21:33 AM 11:09:28 AM 11:19:28 AM
77158 YES 10:21:33 AM 10:59:28 AM 11:09:28 AM
77157 YES 10:21:33 AM 10:49:28 AM 10:59:28 AM
77156 YES 10:21:33 AM 10:39:28 AM 10:49:28 AM
--------------------------------------------------------------------------------------------------
select group#, sequence#, archived, status from v$log order by group#;

GROUP# SEQUENCE# ARCHIVED STATUS
1 77167 YES INACTIVE
2 77168 YES ACTIVE
3 77169 NO CURRENT
--------------------------------------------------------------------------------------------------
select group#, status, members from v$log order by group#, members;

GROUP# STATUS MEMBERS
1 INACTIVE 1
2 ACTIVE 1
3 CURRENT 1


Re: log archive miss [message #599237 is a reply to message #599235] Wed, 23 October 2013 03:02 Go to previous messageGo to next message
John Watson
Messages: 4400
Registered: January 2010
Location: Global Village
Senior Member
Your query results are incompatible with the alert log extract. They cannot be from the same database at about the same time. Please can you confirm where they came from? And display the date as well as the time in your queries.

Please enclose your copy/pastes in tags, as described here How to use [code] tags and make your code easier to read
--
update: typo

[Updated on: Wed, 23 October 2013 03:16]

Report message to a moderator

Re: log archive miss [message #599253 is a reply to message #599237] Wed, 23 October 2013 05:25 Go to previous messageGo to next message
shahidjee7
Messages: 11
Registered: December 2010
Location: Pakistan
Junior Member
my dear john this informaion is from same database. sequence number miss at monday morning and query information is current.
icon2.gif  Re: log archive miss [message #599256 is a reply to message #599253] Wed, 23 October 2013 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the query against v$archived_log with sequence# between 76861 and 76881 and order by sequence#.
Are you in RAC?
Also I mistype the last query, I meant v$logfile not v$log (and it is really "member" and not "members").

When I said to post dates with time, I meant to post dates with date and time, not just time (and not just date which is the default).

Re: log archive miss [message #599368 is a reply to message #599256] Wed, 23 October 2013 23:41 Go to previous messageGo to next message
shahidjee7
Messages: 11
Registered: December 2010
Location: Pakistan
Junior Member
FIRST_CHANGE#	FIRST_TIME	NEXT_CHANGE#	NEXT_TIME	ARCHIVED	DELETED	COMPLETION_TIME
8269793259	21-Oct-13 7:59:28 AM	8269793260	21-Oct-13 8:09:28 AM	YES	NO	21-Oct-13 8:09:28 AM
8269793260	21-Oct-13 8:09:28 AM	8269793264	21-Oct-13 8:19:28 AM	YES	NO	21-Oct-13 8:19:28 AM
8269793264	21-Oct-13 8:19:28 AM	8269793271	21-Oct-13 8:29:28 AM	YES	NO	21-Oct-13 8:29:28 AM
8269793271	21-Oct-13 8:29:28 AM	8269793272	21-Oct-13 8:39:28 AM	YES	NO	21-Oct-13 8:39:28 AM
8269793272	21-Oct-13 8:39:28 AM	8269793273	21-Oct-13 8:49:28 AM	YES	NO	21-Oct-13 8:49:28 AM
8269793273	21-Oct-13 8:49:28 AM	8269793278	21-Oct-13 8:59:28 AM	YES	NO	21-Oct-13 8:59:28 AM
8269793278	21-Oct-13 8:59:28 AM	8269793282	21-Oct-13 9:09:28 AM	YES	NO	21-Oct-13 9:09:28 AM
8269793282	21-Oct-13 9:09:28 AM	8269793290	21-Oct-13 9:19:28 AM	YES	NO	21-Oct-13 9:19:28 AM
8269793290	21-Oct-13 9:19:28 AM	8269793380	21-Oct-13 9:29:28 AM	YES	NO	21-Oct-13 9:29:28 AM
8269793380	21-Oct-13 9:29:28 AM	8269793427	21-Oct-13 9:39:28 AM	YES	NO	21-Oct-13 9:39:28 AM
8269793427	21-Oct-13 9:39:28 AM	8269794131	21-Oct-13 9:49:28 AM	YES	NO	21-Oct-13 9:49:28 AM
8269794131	21-Oct-13 9:49:28 AM	8269814133	21-Oct-13 10:01:38 AM	YES	NO	21-Oct-13 10:01:44 AM
8269814133	21-Oct-13 10:01:38 AM	8269834185	21-Oct-13 10:23:12 AM	YES	NO	21-Oct-13 10:23:36 AM
8269834185	21-Oct-13 10:23:12 AM	8269854238	21-Oct-13 12:43:16 PM	YES	NO	21-Oct-13 12:43:28 PM
8269854238	21-Oct-13 12:43:16 PM	8269874292	21-Oct-13 1:13:41 PM	YES	NO	21-Oct-13 1:13:45 PM
8269874292	21-Oct-13 1:13:41 PM	8269894347	21-Oct-13 1:18:23 PM	YES	NO	21-Oct-13 1:18:28 PM
8269894347	21-Oct-13 1:18:23 PM	8269914399	21-Oct-13 1:20:53 PM	YES	NO	21-Oct-13 1:20:57 PM
8269914399	21-Oct-13 1:20:53 PM	8269914455	21-Oct-13 1:29:28 PM	YES	NO	21-Oct-13 1:29:29 PM
8269914455	21-Oct-13 1:29:28 PM	8269914462	21-Oct-13 1:39:31 PM	YES	NO	21-Oct-13 1:39:31 PM
8269914462	21-Oct-13 1:39:31 PM	8269914590	21-Oct-13 1:49:28 PM	YES	NO	21-Oct-13 1:49:28 PM
8269914590	21-Oct-13 1:49:28 PM	8269914615	21-Oct-13 1:59:28 PM	YES	NO	21-Oct-13 1:59:29 PM


-------------------------------
GROUP#	STATUS	MEMBER

1		D:\ORACLE\ORADATA\ORC1\REDO03.LOG
2		D:\ORACLE\ORADATA\ORC1\REDO02.LOG
3		D:\ORACLE\ORADATA\ORC1\REDO01.LOG

---------------------------

and i m not in RAC..........

*BlackSwan added {code} tags. Please do so yourself in the future.

[Updated on: Thu, 24 October 2013 08:22] by Moderator

Report message to a moderator

icon5.gif  Re: log archive miss [message #599383 is a reply to message #599368] Thu, 24 October 2013 01:16 Go to previous message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why did you remove the sequence number from your first query? I can't do anything with what you posted.
Why did you remove the archive column from the second query?
Also read How to use [code] tags and make your code easier to read to format your output.

Previous Topic: Archived applied status showing NO in v$archived_log
Next Topic: log applied stopped "ORA-01442: column to be modified to NOT NULL is already NOT NULL"
Goto Forum:
  


Current Time: Mon Jul 28 19:55:21 CDT 2014

Total time taken to generate the page: 0.13352 seconds