Error ORA-27046

Yesterday applying recover to a Test database get the next error;

ORA-00279: change 400221459135 generated at 10/28/2018 09:25:32 needed for
thread 1
ORA-00289: suggestion : /dbtest/test/arch/log_dbsp_1_816009_655734277.arc
ORA-00280: change 400221459135 for thread 1 is in sequence #816009
ORA-00278: log file '/dbtest/test/arch/log_dbsp_1_816008_655734277.arc' no
longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
ORA-27046: file size is not a multiple of logical block size                    
Additional information: 1

I have moved the file from Production to Test by using sftp.The problem is the file it looks good but I have tranfered the file again. Maybe a binary comparison would show the problem and if the files (in source and destination) were equals.

HTH – Antonio Navarro


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s