Re: ORA-00227: corrupt block detected in controlfile

Hi! Thanks for replying, as you said I tried to use the file from 'alter database backup controlfile to ...' but still I am getting same error. Could you please tell me how do I find out if the filesystems are different for two hosts? and if so what would be solution for my case. Thanks in advance.

"Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message news:98pr0l$dau$1_at_news247.cnt.ru...
> Hello!
> Try on the primary machine "alter database backup controlfile to
> 'control_file.ctl';"
> And use this file on the other machine.
> If you get the same error, may be you filesystems different for two hosts?
>
> Best regards.
> Yaroslav
>
>
> "james" <kdhakal_at_eline.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
> news:imRr6.1665$Up.95992_at_sea-read.news.verio.net...
> > hello! I am trying to copy database from one server to another by
 following
> > process:
> > 1. take a cold backup (datafiles, redologfiles, controlfile, initfile)
> > 2. move above files to another machince.
> > 3. change initfiles as needed.
> > 4. startup mount.
> > but I got this error
> > ORA-00227: corrupt block detected in controlfile: (block 1, # blocks
 1)
> > ORA-00202: controlfile: '/u07/path1/control01.ctl'
> > I first thought my backup is bad, but I am able to restore from
 coldbackups
> > in the same machine
> > without any problem. It just, when I move those files to new machine
 throgh
> > ftp and try to
> > starup mount I got the error. I have repeat above steps at least three
 times
> > and every time I got
> > the same error. Could anyone help me on this. Thanks in advance.
> >
> >
> >
>
>
Received on Thu Mar 15 2001 - 12:24:57 CST