Re: RMAN restore to lower point release/different OS?

"Malcolm Dunnett" <nothome_at_spammers.are.scum> wrote in message news:4994a7b2$1_at_flight...
> This is probably going to sound like a very weird thing to do, but please
> bear with me for a minute:
>
> I have an Oracle 10.2.0.4 database running on RedHat Linux on an HP
> Itanium server. I'm playing around with the possibility of copying the
> database to a VMS 8.3 Alphaserver (for disaster recovery scenarios).
>
> I have a level 0 plus incremental backups of the database from the Linux
> server. I copied these files to the VMS server and used RMAN to do a
> "restore database". This ran with no errors (of course I had made sure
> that the VMS system had compatible logical names and directories to match
> the directory structure on the linux system) and restored all the
> datafiles from the level 0 backup.
>
> When I tried to "recover database" rman appeared to proceed successfully
> through the application of the incremental backups (ie restoring the
> changed blocks to the datafiles), it restored the first archived logfile
> to disk, but when it went to apply that file I got an ORA-00600 error
> [Kddummy_blkchk].
>
> One of the wrinkles is that the VMS server is currently running Oracle
> 10.2.0.2 (Oracle hasn't yet released 10.2.0.4 for VMS).
>
> I am able to open the database on VMS by doing a "STARTUP DOWNGRADE". When
> I check various schemas it appears that the data from the Linux database
> is present and correct (though possibly inconsistent because of the
> failure to apply the archived logfiles).
>
> I'm wondering if the ORA-0600 error is due to the difference in database
> versions or if there is something else wrong with my backup/restore
> procedure.
>
> Both servers are 64bit database and little-endian, so it seems that in
> principle there shouldn't be an issue moving the files. I know that Oracle
> supports moving database files between VMS on Alpha and VMS on Itanium
> (I've successfully done that numerous times) but I'm not sure if the
> database running on Linux on Itanium makes a difference.

Do you have an Oracle support contract ? If yes, try contacting support.

Matthias Received on Thu Feb 12 2009 - 17:09:24 CST