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