Re: Physical backup/recovery between different platforms?

Merku <imerku_at_acegas.ts.it> wrote in message news:<atn0on$fak$1_at_half.spin.it>...
> All right then, here's the update.
>
> I have created a database on AIX, one with raw logical volumes, one on file
> system.
> I have backed up both cold and hot.
> Cold: Restored db onto SuSE linux did not open or access anything at all.
> Hot: Created new control file but said, that sys001 (SYSTEM tablespace) was
> not a valid datafile. And, all datafiles are reported 100% corrupted (page
> per page) on SuSE (dbv). Oracle support confirmed in two different
> occasions, that physical backup/restore between platforms is not possible.
>
> I just verified that this statement is true.
>
> What a pity.
>
> I can understand about raw logical volume, but not necessarly about file
> system, but looks like data file structure/header is different.
> What a pity, really.
>
> sigh.
>
> Have a nice day and thank you for all constructive critic or contributes.
>
> Please refrain from comments like "I said it in the first place". I have
> read them, too. _I_ tried it.
>
> Best regards, Igor

1. Please do not cross-post [Quoted]
2. Why would you expect binary files to be compatible accross operating systems and/or platforms? This has never been true. Even [Quoted] plan text files can require conversion such as the fact UNIX ends text file lines with only a new line character while MS uses carriage return newline. My PC based FTP program automatically handles the coversion on ASCII transfers but if you use a binary transfer from the PC to AIX you can see the unnecessary CR at the end of every line in the text file.

HTH -- Mark D Powell -- Received on Tue Dec 17 2002 - 15:41:59 CET