Home » Server Options » Data Guard » archives not applied at standby
archives not applied at standby [message #274042] Sat, 13 October 2007 00:02 Go to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Hi friends

I have configured two physical standby databases for my production database. [All Oracle 10.2.0.1 on Windows Server 2003.] Iam encountering a strange problem and that too on the second standby only. The problem is that this standby is not able to apply archived file that it received from primary. When i try to register the file.. it throws the error:

SQL> alter database register logfile 'D:\STBY\ARCHIVE\ARC04544_0614221790.001
';
alter database register logfile 'D:\STBY\ARCHIVE\ARC04544_0614221790.001'
*
ERROR at line 1:
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: 'D:\STBY\ARCHIVE\ARC04544_0614221790.001'


This behaviour is random in nature. I copy the file from the first standby (no problem here) and register it.....still the same error.

But when I copy the file from primary site...and register its able to register.

I trid to compare the two files using comp .This is the output I get:

C:\Documents and Settings\Administrator>comp d:\ARC04544_stby_0614221790.001 d:\
stby\archive\ARC04544_0614221790.001
Comparing D:\ARC04544_stby_0614221790.001 and D:\stby\archive\ARC04544_061422
1790.001...
Compare error at OFFSET 200
file1 = 0
file2 = 1
Compare error at OFFSET 201
file1 = 0
file2 = 22
Compare error at OFFSET 204
file1 = 0
file2 = 1
......
......
Compare error at OFFSET 216
file1 = 0
file2 = 20
10 mismatches - ending compare


I think this is an OS level error. What is your say ? Please give me some suggestions to overcome the problem.

Regards
Nand Kumar

[Updated on: Sat, 13 October 2007 00:08]

Report message to a moderator

Re: archives not applied at standby [message #274831 is a reply to message #274042] Wed, 17 October 2007 06:33 Go to previous message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Hi friends.....today also I encounterd the same problem....any solutions ??
Previous Topic: Redo logs not getting applied - production issue,please advise
Next Topic: Data guard requirement
Goto Forum:
  


Current Time: Thu Mar 28 10:18:59 CDT 2024