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.
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.
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.