Using db files on another server

From: KrzysztofB <smuter_at_gazeta.pl>
Date: Mon, 11 Jun 2007 15:42:11 +0200
Message-ID: <vliq63tcmj7ta3lrh00cbq5jgpal3upq7n@4ax.com>

I have file-copy database backup (*.ctl, *.dbf, and .ora file) and need to connect these files to working server.

My method (described below) failed.
I did it similar way on Windows XP and Fedora Core5 What I'm doing wrong?

---

I have oracle 10.2.0.1.0, .ora file has line "compatible=10.1.0.4.0"

I copy data files under oradata/NAME and  .ora file into dbs directory.

and next:

    ORACLE_SID=PROPERSID;
    export ORACLE_SID;
    sqlplus /nolog

        connect user/pass as sysdba
        startup mount

and result:
ORA-27047 unable to read the header block of file (on Windows I had ORA-27047 + OSD-04001 wrong block size)

---

Thanks for all your help
KrzysztofB Received on Mon Jun 11 2007 - 08:42:11 CDT