Re: HELP! need to clone a server but got stuck

Yuck, you just can't go copying DBFs and throw them somewhere else and bring up an instance.

I don't suppose the dbnames and SID's differ, do they?

There a bunch of different things or multiple things that could be wrong.

Look at dba_tablespaces and dba_datafiles and find out where your REDOs are and how big, use Orainst (preferably the same one you used to build the other database), make sure your block sizes, maxdatafiles and such are the same as in the first, after verifying the file names and locations on the new machine. Refer to the Utilities Reference Manual on recovery backups and restores, and do a complete export of database 1, when it is in RESTRICTED mode and you've bounced and restarted it that way, followed by an incremental export, which should have nearly nothing in it.

Go to the other machine, import the incremental first as INCTYPE=SYSTEM, then your complete as RESTORE and import the incremental again as INCTYPE=RESTORE. Read the Export and Import sections of the Utilities Reference Manual before you attempt this.

If global_names is true, your test database ought to have a different $ORACLE_SID and dbname; we always make those the same, so we'd have, say D1 as the SID, the DBNAME, and how it's known to the network; and P1 the same way. If the test box must look exactly like production, make sure the databases do not know about each other.

I never liked cloning databases by file copy, something always seems to go wrong.

RSH.
"Arash" <arashamiri_at_hotmail.com> wrote in message news:fa5fb486.0204050437.5a2bcc37_at_posting.google.com...
> Hi!
>
> My problem is as followed (here is my story ;) ):
>
> I need to set up a test server which should be a copy of the real
> server.
>
> I copied the DBFs (cold, after a shutdown normal) and I backuped the
> controlfiles as trace.
>
> now here comes the crucial point:
>
> - something went wrong with my dbfs. due to some confusion in the
> company some of the dbfs got deleted, recopied and so on...
>
> Right now my server is NOT STARTED!! When I want to open it (i.e.
> startup normal) "I get an ORA-01202: wrong incarnation..
> (SYSTEM01.DBF) ". That means, that I can not start my server. I could
> not logon to my server. So I went through some newsgroups and found
> out that I can logon like that:
>
> connect sys/password_at_oratest as sysdba
>
> I did that with the server-manager.
>
> - I copied the dbfs once again (this time without shutting down the
> server, but who cares about some lost data, since it's going to be a
> test server...)
>
> - I backuped the trace file from the NEW test server. so the trace
> file looked more or less like this:
>
> CREATE CONTROLFILE REUSE DATABASE "ORATEST" NORESETLOGS NOARCHIVELOG
> MAXLOGFILES 32
> MAXLOGMEMBERS 2
> MAXDATAFILES 254
> MAXINSTANCES 1
> MAXLOGHISTORY 453
> LOGFILE
> GROUP 1 'D:\ORADATA\ORATEST\REDO01.LOG' SIZE 1M,
> ...
> ...
>
> when I did a CREATE CONTOLFILE after a STARTUP NOMOUNT I got the
> following error message :
>
> ORA-01161: database name INTRANET in file header does not match given
> name for of ORATEST.. (concerning the SYSTEM01.DBF)
>
> so I went again through some newsgroups and tried the following CREATE
> CONTROLFILE:
>
> CREATE CONTROLFILE SET DATABASE "ORATEST" RESETLOGS... (the rest was
> the same)
>
> This time I got the following error-message:
> ORA-01159: file is not from same database as previous files - wrong
> database id
> ORA-01110: data file 2: 'D:\ORA...\RBS01.DBF'
>
> What can I do?
>
> please help, AA.
Received on Fri Apr 05 2002 - 15:03:15 CST