-
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
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
you cannot do that, the binaries are not compatible
-
even if i ftp it in a binary mode . wont it help .
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
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
-
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
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
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;
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
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 .
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|