COPY THE INSTANCE FROM LINUX TO SUN - URGENT

it is 8.1.7 / ARCHIVE LOG MODE

I need to copy one instance from LINUX machine to Sun- Solaris , now the thing is the unix file struture is different in both the machines

like - sun has u1/u2/u3/u4/u5

linux is having usr1/usr2/usr3/usr4/usr5

so what i am going to do is ---

Now the instance is in linux machine

1 Get a copy of the control file by giving command backup
control file to trace.
2 issue a log switch in my linux machine.
3 shut downn the database gracefully.
4 take a cold backup of all the files ( datafiles , control
files , archived redo logs )
5 copy all the files in the SUN machine.
6 edit the control file for changing the path /file location
7 start the database in nomount phase
8 run the create control file script that i have just edited.
9 open the database with RESETLOGS OPTION.

is there any thing i missed out.
i am thinking of doing this in evening, so advise is needed.

--pravin

you cannot do that, the binaries are not compatible

even if i ftp it in a binary mode . wont it help .

Create a new database on the Sun workstation using the same database name and tablespace/datafile names. Create your schema owner. Do an export on the original database, and import into the new database.

Export parfile
userid=system/password@dbname
full=y
inctype=complete
file=name_of_dump_file
log=name_of_log_file

Import parfile
userid=system/password@dbname
full=y
commit=y
file=name_of_export_dump_file
log=name_of_import_log_file

Quote:

---

Originally posted by pravin
even if i ftp it in a binary mode . wont it help .

---

nop, it´s like I take command.com and run it on unix

thanks pando and stecal for ur comments.

But tell me if i had to do from linux to linux and the instance name is same , but the location of the files is different path , what the steps i wrote is correct or not ?

please let me know so that i can keep this steps handy whenver i need it .

pravin

RECOVER DATABASE USING BACKUP CONTROLFILE until cancel ;
ALTER DATABASE OPEN RESETLOGS;
if you changed you database name, then,
alter database rename global_name to .

alter database rename global_name to .

xyz2000 ur answer is not clear to me see my situation is that i have the database name same , and it has to be kept same. so i will have to open with
ALTER DATABASE OPEN RESETLOGS;

Yes. after recover the database with backup controlfile until cancel, then you can open database with resetlog. There is no need to rename database if you database name and domain name are not changed.

The syntax for rename database is:

alter database
rename global_name
to .

I can get that syntax right.

Hope this time it will work.

alter database rename global_name to newdb.domain.

if my O/S is same, and the instance name is same
so what steps i wrote is it right.

Also i have to try from windows 2000 to windows 2000
NT to NT , linux to linux , etc what i wrote the steps 1 to 8 is it right ?

pravin

bcoz these stpes i can note down .

Yes your steps are right if you are moving db's between machines that have the same OSes, ie. Linux to Linux, HPUX to HPUX.

I think it will be a right way. Why don't you have a try using a test database?

Quote:

---

Originally posted by pravin
it is 8.1.7 / ARCHIVE LOG MODE

I need to copy one instance from LINUX machine to Sun- Solaris , now the thing is the unix file struture is different in both the machines

---