Re: Restoring 64 bit database to 32 bit Server

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Sat, 9 Sep 2006 12:26:33 +0200
Message-ID: <006e01c6d3fa$6d271380$eb00a8c0@ETNOTEAM6XUQ9V>

> 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

Received on Sat Sep 09 2006 - 05:26:33 CDT