Home » Server Options » Data Guard » ora-27046
ora-27046 [message #148661] Sat, 26 November 2005 01:00 Go to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

hi all
v r using oracle 9.2 on solaris 9... while doing recovery of archive log files from primary db i m getting this error
ORA-00308:cannot open archived log
'/usr7/ETALB/arch/ETALB_39546.arc
ORA-27046:file size is not a multiple of logical lock size
Additional information:1

first i have manulay copy all the archivelog file from primary to standy and then started recover of archived log file in standby database....up to above specified file recovery is successfull....
i have found this cause and action from net but i could not understand it.....

Cause: File size as indicated by stat is not correct. Additional information indicates which function encountered the error.
Action: Verify that the file has not been overwritten or truncated.

Thanks in advance
Rushikesh....
Re: ora-27046 [message #148672 is a reply to message #148661] Sat, 26 November 2005 02:55 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Just a wild guess --

Can you copy the specific archive again from Primary to Standby database and try again to recover.

Looks like the file has been corrupted.
Re: ora-27046 [message #148673 is a reply to message #148672] Sat, 26 November 2005 03:09 Go to previous message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

hi tarun...

i have tryed so many times by this way but it is not working....
plz giv me some another solution if possible...it is urgent

Thank you
Rushikesh...
Previous Topic: DataGuard Across OS Platforms
Next Topic: Flashback old primary after a failover
Goto Forum:
  


Current Time: Fri Mar 29 03:59:57 CDT 2024