Re: Restoring 64 bit database to 32 bit Server

The control files are however, different - they must be recreated when
migrating from 32-bit -> 64 bit.

If I'm not missing something, what about restore the controlfile wherever possible and then startup mount (with any p/spfile, db_name is sufficient) and then alter database backup controlfile to trace to get the right commands?

You could also use the rman resore controlfile from '<path>/<autobackup_file>' (under dbs or restored as normal file) in nomount mode.


$ rman target /

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 9 12:23:50 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ora10gr2 (not mounted)

RMAN> restore controlfile from '/siriofs/oracle/backup/ora10gr2_bck/control_c-3888264759-20060907-00'
2> ;

Starting restore at 09-SEP-06
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:05
output filename=/app/oracle/oradata/ora10gr2/control01.ctl
output filename=/app/oracle/oradata/ora10gr2/control02.ctl
output filename=/app/oracle/oradata/ora10gr2/control03.ctl
Finished restore at 09-SEP-06



Regards
Dimitre 

--
http://www.freelists.org/webpage/oracle-l


Other related posts: