Re: Datafiles transportation from solaris to linux
- From: Scott <oraracdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 2 Feb 2004 17:00:21 -0800 (PST)
My bad Tanel. You are correct.
SQL> alter tablespace REPOSIT read only;
Tablespace altered.
rac10g$ exp userid=\'/ as sysdba\'
transport_tablespace=y tablespaces=reposit
file=tts.dmp log=exp_tts.log statistics=none
Export: Release 10.1.0.1.0 - Beta on Mon Feb 2
19:10:49 2004
...
Note: table data (rows) will not be exported
About to export transportable tablespace
metadata...
For tablespace REPOSIT ...
. exporting cluster definitions
. exporting table definitions
. . exporting table
MTG_COL_DEP_CHG
. . exporting table
MTG_DATABASES
....
. . exporting table
SYBASE11_SYSUSERS
. exporting referential integrity constraints
. exporting triggers
. end transportable tablespace metadata export
Export terminated successfully without warnings.
SQL> select PLATFORM_ID , PLATFORM_NAME from
v$database;
PLATFORM_ID PLATFORM_NAME
----------- ------------------------------
2 Solaris[tm] OE (64-bit)
rac10g$ rman target=/
Recovery Manager: Release 10.1.0.1.0 - 64bit Beta
connected to target database: V101B2
(DBID=3287908659)
RMAN> convert tablespace 'REPOSIT'
2> to platform="Linux IA (32-bit)"
3>
db_file_name_convert='/home/beta10g/datafile/reposit01.dbf',
4> '/tmp/reposit01.dbf';
Starting backup at 02-FEB-04
using target database controlfile instead of
recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=8 devtype=DISK
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00006
name=/home/beta10g/datafile/reposit01.dbf
converted datafile=/tmp/reposit01.dbf
channel ORA_DISK_1: datafile conversion complete,
elapsed time: 00:00:01
Finished backup at 02-FEB-04
rac10g$ ftp raclinux1
raclinux1 FTP server (Version wu-2.6.2(1) Thu Jan 16
11:40:04 MST 2003) ready
Name (raclinux1:ora10b):
331 Password required for ora10b.
Password:
230 User root logged in.
ftp> put tts.dmp
200 PORT command successful.
150 Binary data connection for tts.dmp
(192.168.1.11,55812).
226 Transfer complete.
ftp> put tts.dmp
200 PORT command successful.
150 Binary data connection for tts.dmp
(192.168.1.11,55812).
226 Transfer complete.
ftp> lcd /tmp
Local directory now /tmp
ftp> put reposit01.dbf
200 PORT command successful.
150 Binary data connection for tts.dmp
(192.168.1.11,55812).
226 Transfer complete.
-- Now on Linux node
$ imp userid=\'/ as sysdba\' TRANSPORT_TABLESPACE=Y
datafiles=/tmp/reposit01.dbf file=tts.dmp
log=imp_tts.log
Import: Release 10.1.0.1.0 - Beta on Mon Feb 2
17:30:20 2004
Export file created by EXPORT:V10.01.00 via
conventional path
About to import transportable tablespace(s)
metadata...
...
. importing SYS's objects into SYS
. importing OMWB's objects into OMWB
. . importing table
"MTG_COL_DEP_CHG"
...
. . importing table
"SYBASE11_SYSUSERS"
Import terminated successfully without warnings.
SQL> alter tablespace reposit read write;
Tablespace altered.
Scott
--- Tanel Poder <tanel.poder.003@xxxxxxx> wrote:
> Could you point me where is it stated, that
> crossplatform TTS isn't supported without ASM?
> This command is issued on a database which uses
> datafiles only on regular filesystem:
>
> RMAN> convert tablespace users to platform
> 'Solaris[tm] OE (64-bit)' format 'C:\temp\TS%U';
>
> Starting backup at 03.02.2004
> using channel ORA_DISK_1
> channel ORA_DISK_1: starting datafile conversion
> input datafile fno=00005
> name=C:\ORACLE\ORA10G\OG\USERS01.DBF
> converted
>
datafile=C:\TEMP\TSDATA_D-OG_I-3166553244_TS-USERS_FNO-5_01FD4V6D
> channel ORA_DISK_1: datafile conversion complete,
> elapsed time: 00:00:01
> Finished backup at 03.02.2004
>
> At least generating the tablespace for another
> platform works.
> I haven't tried to plug the resulting TS in to
> Oracle on another platform, but this should be
> normal TTS plug-in procedure anyway...
>
> Tanel.
>
> ----- Original Message -----
> From: "Scott" <oraracdba@xxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Cc: <tanel.poder.003@xxxxxxx>
> Sent: Tuesday, February 03, 2004 1:33 AM
> Subject: Re: Datafiles transportation from solaris
> to linux
>
>
> > RMAN does support this in 10g but you have to use
> > Oracle's Automatic Storage Management instance
> (ASM)
> > to use this feature.
> >
> > You still won't be able to move Oracle datafiles
> > between different OS file systems in 10g even if
> you
> > use RMAN.
> >
> > ASM storage does not present itself to the OS so
> you
> > have to RMAN and Enterprise Manager (Grid Control)
> to
> > manage it for you.
> >
> > Scott
> >
> > --- Tanel Poder <tanel.poder.003@xxxxxxx> wrote:
> > > Yep, 10g RMAN has the cross-platform
> transportable
> > > tablespace feature...
> > >
> > > Tanel.
> > >
> > > ----- Original Message -----
> > > From: "Jared Still" <jkstill@xxxxxxxxxx>
> > > To: "Oracle-L Freelists"
> <oracle-l@xxxxxxxxxxxxx>
> > > Sent: Sunday, February 01, 2004 8:28 PM
> > > Subject: Re: Datafiles transportation from
> solaris
> > > to linux
> > >
> > >
> > > > little-endian vs. big-endian architecture.
> > > >
> > > > There may be methods for this in 10g, but
> > > > not as of 9i.
> > > >
> > > > Jared
> > > >
> > > > On Sun, 2004-02-01 at 05:20, Diego Cutrone
> wrote:
> > > > > Hi list,
> > > > >
> > > > > I know it's not possible to copy datafiles
> from
> > > one platform to another.
> > > > > For example you can't copy datafiles from
> HPUX
> > > to AIX or from Windows to
> > > Linux.
> > > > >
> > > > > But I am not sure about Linux and Solaris,
> if I
> > > remember correctly I
> > > have installed solaris binaries into linux once.
> > > > > So I'm not sure about this question.
> > > > >
> > > > > Can you copy datafiles (or a complete
> database)
> > > from a solaris to linux?
> > > would it work?
> > > > > Have any of you tested it ?
> > > > > (I cat test it as I don't have access to a
> > > Soalris right now)
> > > > >
> > > > >
> > > > > Thanks for your help!
> > > > > Regards
> > > > > Diego
> > > > >
> > > > >
> > >
> >
>
----------------------------------------------------------------
> > > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > >
> > >
> >
>
----------------------------------------------------------------
> > > > > To unsubscribe send email to:
> > > oracle-l-request@xxxxxxxxxxxxx
> > > > > put 'unsubscribe' in the subject line.
> > > > > --
> > > > > Archives are at
> > > //www.freelists.org/archives/oracle-l/
> > > > > FAQ is at
> > >
> //www.freelists.org/help/fom-serve/cache/1.html
> > > > >
> > >
> >
>
-----------------------------------------------------------------
> > > >
> > > >
> > >
> >
>
----------------------------------------------------------------
> > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > >
> > >
> >
>
----------------------------------------------------------------
> > > > To unsubscribe send email to:
> > > oracle-l-request@xxxxxxxxxxxxx
> > > > put 'unsubscribe' in the subject line.
> > > > --
> > > > Archives are at
> > > //www.freelists.org/archives/oracle-l/
> > > > FAQ is at
> > >
> //www.freelists.org/help/fom-serve/cache/1.html
> > > >
> > >
> >
>
-----------------------------------------------------------------
> > > >
> > >
> > >
> > >
> >
>
----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > >
> >
>
----------------------------------------------------------------
> > > To unsubscribe send email to:
> > > oracle-l-request@xxxxxxxxxxxxx
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at
> > > //www.freelists.org/archives/oracle-l/
> > > FAQ is at
> > >
> //www.freelists.org/help/fom-serve/cache/1.html
> > >
> >
>
-----------------------------------------------------------------
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free web site building tool.
> Try it!
> > http://webhosting.yahoo.com/ps/sb/
> >
>
----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >
>
----------------------------------------------------------------
> > To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> //www.freelists.org/archives/oracle-l/
> > FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
> >
>
-----------------------------------------------------------------
>
=== message truncated ===
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
