Message-ID: <02fb01c3e9e8$dc85da30$eafb23d5@porgand>
From: "Tanel Poder" <tanel.poder.003@mail.ee>
To: <oracle-l@freelists.org>
References: <20040202233350.15324.qmail@web41503.mail.yahoo.com>
Subject: Re: Datafiles transportation from solaris to linux
Date: Tue, 3 Feb 2004 02:01:23 +0200
MIME-Version: 1.0
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: oracle-l@freelists.org

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@yahoo.com>
To: <oracle-l@freelists.org>
Cc: <tanel.poder.003@mail.ee>
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@mail.ee> wrote:
> > Yep, 10g RMAN has the cross-platform transportable
> > tablespace feature...
> > 
> > Tanel.
> > 
> > ----- Original Message ----- 
> > From: "Jared Still" <jkstill@cybcon.com>
> > To: "Oracle-L Freelists" <oracle-l@freelists.org>
> > 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@freelists.org
> > > > put 'unsubscribe' in the subject line.
> > > > --
> > > > Archives are at
> > http://www.freelists.org/archives/oracle-l/
> > > > FAQ is at
> > http://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@freelists.org
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at
> > http://www.freelists.org/archives/oracle-l/
> > > FAQ is at
> > http://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@freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> > http://www.freelists.org/archives/oracle-l/
> > FAQ is at
> > http://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@freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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@freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------