Re: Migrating from Win2k3 to linux

#1

"Jan Lühr" <usenet (AT) stephan (DOT) homeunix.net> wrote

Quote:

Hello,

I'm trying to migrate an existing database. So far I've done a cold backup
and copied all database and control files to the new host.
However - some paths are messed up - of course, since Linux can't handle
c:\.
Do you know a(convienient, efficient ;-) way to identify and change messy
paths of data files, log files, etc.?

Thanks in advance,
Keep smiling
yanosz
Just copying the database files etc. may not do it. I would do a full

export from the original and then do a full import in the target.
(pre-create the tablespaces in the target db)
Jim

#2

On Nov 23, 3:34*am, Jan Lühr <use... (AT) stephan (DOT) homeunix.net> wrote:

Quote:

Hello,

I'm trying to migrate an existing database. So far I've done a cold
backup and copied all database and control files to the new host.
However - some paths are messed up - of course, since Linux can't handle
c:\.
Do you know a(convienient, efficient ;-) way to identify and change
messy paths of data files, log files, etc.?

Thanks in advance,
Keep smiling
yanosz

Given the same bitness and endianness of source and target there
shouldn't be any issues with binary compatibility of that backup To
rename the files, you need to record the file names in the source
database by querying V$LOGFILE, V$DATAFILE and V$TEMPFILE and saving
the results of these queries for reference; CREATE PFILE='c:\init.ora'
FROM SPFILE at the source, copy that init.ora to the target, fix the
paths to control file copies in it (as well as various xxx_dest
destinations) and issue STARTUP MOUNT PFILE='/path/to/copied-and-
edited/init.ora' at the target; and finally ALTER DATABASE RENAME FILE
'c:\source\dir\filename.dbf' TO '/whatever/the/new/path/is/
filename.dbf' for each file name you recorded earlier. Then you can
issue ALTER DATABASE OPEN to verify that all files were properly
renamed and are accessible to Oracle. When you are sure Oracle is
working as expected at its new home, you CREATE SPFILE FROM PFILE='/
path/to/copied-and-edited/init.ora' followed by SHUTDOWN and STARTUP.

Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

#3

On Nov 23, 3:34*am, Jan Lühr <use... (AT) stephan (DOT) homeunix.net> wrote:

Quote:

Hello,

I'm trying to migrate an existing database. So far I've done a cold
backup and copied all database and control files to the new host.
However - some paths are messed up - of course, since Linux can't handle
c:\.
Do you know a(convienient, efficient ;-) way to identify and change
messy paths of data files, log files, etc.?

Thanks in advance,
Keep smiling
yanosz

Given the same bitness and endianness of source and target there
shouldn't be any issues with binary compatibility of that backup To
rename the files, you need to record the file names in the source
database by querying V$LOGFILE, V$DATAFILE and V$TEMPFILE and saving
the results of these queries for reference; CREATE PFILE='c:\init.ora'
FROM SPFILE at the source, copy that init.ora to the target, fix the
paths to control file copies in it (as well as various xxx_dest
destinations) and issue STARTUP MOUNT PFILE='/path/to/copied-and-
edited/init.ora' at the target; and finally ALTER DATABASE RENAME FILE
'c:\source\dir\filename.dbf' TO '/whatever/the/new/path/is/
filename.dbf' for each file name you recorded earlier. Then you can
issue ALTER DATABASE OPEN to verify that all files were properly
renamed and are accessible to Oracle. When you are sure Oracle is
working as expected at its new home, you CREATE SPFILE FROM PFILE='/
path/to/copied-and-edited/init.ora' followed by SHUTDOWN and STARTUP.

Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

#4

On Nov 23, 3:34*am, Jan Lühr <use... (AT) stephan (DOT) homeunix.net> wrote:

Quote:

Hello,

I'm trying to migrate an existing database. So far I've done a cold
backup and copied all database and control files to the new host.
However - some paths are messed up - of course, since Linux can't handle
c:\.
Do you know a(convienient, efficient ;-) way to identify and change
messy paths of data files, log files, etc.?

Thanks in advance,
Keep smiling
yanosz

Given the same bitness and endianness of source and target there
shouldn't be any issues with binary compatibility of that backup To
rename the files, you need to record the file names in the source
database by querying V$LOGFILE, V$DATAFILE and V$TEMPFILE and saving
the results of these queries for reference; CREATE PFILE='c:\init.ora'
FROM SPFILE at the source, copy that init.ora to the target, fix the
paths to control file copies in it (as well as various xxx_dest
destinations) and issue STARTUP MOUNT PFILE='/path/to/copied-and-
edited/init.ora' at the target; and finally ALTER DATABASE RENAME FILE
'c:\source\dir\filename.dbf' TO '/whatever/the/new/path/is/
filename.dbf' for each file name you recorded earlier. Then you can
issue ALTER DATABASE OPEN to verify that all files were properly
renamed and are accessible to Oracle. When you are sure Oracle is
working as expected at its new home, you CREATE SPFILE FROM PFILE='/
path/to/copied-and-edited/init.ora' followed by SHUTDOWN and STARTUP.

Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

#5

On Nov 23, 3:34*am, Jan Lühr <use... (AT) stephan (DOT) homeunix.net> wrote:

Quote:

Hello,

I'm trying to migrate an existing database. So far I've done a cold
backup and copied all database and control files to the new host.
However - some paths are messed up - of course, since Linux can't handle
c:\.
Do you know a(convienient, efficient ;-) way to identify and change
messy paths of data files, log files, etc.?

Thanks in advance,
Keep smiling
yanosz

Given the same bitness and endianness of source and target there
shouldn't be any issues with binary compatibility of that backup To
rename the files, you need to record the file names in the source
database by querying V$LOGFILE, V$DATAFILE and V$TEMPFILE and saving
the results of these queries for reference; CREATE PFILE='c:\init.ora'
FROM SPFILE at the source, copy that init.ora to the target, fix the
paths to control file copies in it (as well as various xxx_dest
destinations) and issue STARTUP MOUNT PFILE='/path/to/copied-and-
edited/init.ora' at the target; and finally ALTER DATABASE RENAME FILE
'c:\source\dir\filename.dbf' TO '/whatever/the/new/path/is/
filename.dbf' for each file name you recorded earlier. Then you can
issue ALTER DATABASE OPEN to verify that all files were properly
renamed and are accessible to Oracle. When you are sure Oracle is
working as expected at its new home, you CREATE SPFILE FROM PFILE='/
path/to/copied-and-edited/init.ora' followed by SHUTDOWN and STARTUP.

Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Migrating from Win2k3 to linux

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Migrating from Win2k3 to linux - 11-22-2008 , 08:27 PM

Re: Migrating from Win2k3 to linux - 11-23-2008 , 10:53 AM

Re: Migrating from Win2k3 to linux - 11-23-2008 , 10:53 AM

Re: Migrating from Win2k3 to linux - 11-23-2008 , 10:53 AM

Re: Migrating from Win2k3 to linux - 11-23-2008 , 10:53 AM