Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-00227: corrupt block detected in controlfile

Re: ORA-00227: corrupt block detected in controlfile

From: Yaroslav Perventsev <p_yaroslav_at_cnt.ru>
Date: Thu, 15 Mar 2001 10:36:47 +0300
Message-ID: <98pr0l$dau$1@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 - 01:36:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US