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
] 
Blog
Search
Help
Members
Register
Login
Home
