OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » ora-27046

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-27046 [message #148661]

Sat, 26 November 2005 01:00

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....

Report message to a moderator

Re: ora-27046 [message #148672 is a reply to message #148661]

Sat, 26 November 2005 02:55

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.

Report message to a moderator

Re: ora-27046 [message #148673 is a reply to message #148672]

Sat, 26 November 2005 03:09

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...

Report message to a moderator

Previous Topic:	DataGuard Across OS Platforms
Next Topic:	Flashback old primary after a failover

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 26 20:36:48 CST 2022