Re: Copying Database from One location to Another

Thanks Alex, Like you said I copied all the files to another machine. But when I did, startup mount I got this error; ORA-00227: corrupt block detected in controlfile: (block 1, # blocks 1) ORA-00202: controlfile: '/u07/rocco/control01.ctl' Note: this is the control file I copied from original database. I thought one of controlfile might be bad so I tried to copy from each one( I have three copy of controlfile) but result is the same. Any ideas? Thanks in advance.

"Alex Filonov" <afilonov_at_pro-ns.net> wrote in message news:3A9497B7.DA69C199_at_pro-ns.net...
> kush wrote:
>
> > hi! Could anyone tell me what are the steps to create a database in new
> > location by reusing
> > the controlfiles, datafiles, redologfiles and arch. files(if needed)
 from
> > another database in another location.
> > This is more like copying database from one machine to another except
 the
> > fact that
> > a. I can't shutdown the original database and take a cold backup(it has
 to
> > be up all the time) and its running in archivelogmode.
> > b. when I create(recover) database at new location, I need to do point
 in
> > time recovery.
> >
> > both machine has oracle 8.1.5 standard edition.
> > Thanks in advance.
>
> Steps you need to do:
>
> 1. Make a hot database backup. All tablespaces.
> 2. Copy all other files, including log files, controlfiles, init<sid>.ora,
> archive log files.
> 3. Copy this all onto another machine, preserving the directory structure.
> 4. Startup database and recover until time.
> 5. Now you can rename database, if you want to.
>
> Note: You can't rename database before recover. If you need to change
> directory structure, try to
> rename files one by one.
>
>
Received on Thu Feb 22 2001 - 12:07:48 CST