Re: Rman across windows/aix

bob wrote:
>
> Hi all, I have to move a database from oracle9i on windows 2000 to
> oracle 9i on Aix. I backup the database on windows with rman with
> options "include current controlfile" and "backup archivelog all". I
> created a new database on Aix with the same name as in windows. How
> can I now recover my backup on Aix? Because on windows's controlfile,
> for example, the location of datafile is samething like "c:\....", but
> in Aix "/oracle/....
> How can I risolve this problem? Or rman do so automatically?
> Does exist another way to move a database across platform?
> Thanks!
> PS. I moved the backup file from windows to a folder in aix via ftp
> and I tried to restore database:
> rman>run {
> allocate channel disco1 type disk;
> restore database;
> recover database;
> alter database open;
> }
> But it result an error:
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: restore
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: IRESTORE
> RMAN-06026: some targets not found - aborting restore
> RMAN-06023: no backup or copy of datafile 7 found to restore
> RMAN-06023: no backup or copy of datafile 6 found to restore
> RMAN-06023: no backup or copy of datafile 5 found to restore
> RMAN-06023: no backup or copy of datafile 4 found to restore
> RMAN-06023: no backup or copy of datafile 3 found to restore
> RMAN-06023: no backup or copy of datafile 2 found to restore
> RMAN-06023: no backup or copy of datafile 1 found to restore
> It seems rman can't see the backup file!
> Any suggestion?

Bob,
I don't think you can use RMAN to this kind of thing. Export/Import is the way to go.

Hth.
Anthony Hogan Received on Wed Apr 02 2003 - 08:10:30 CST