Hi,
I know this might look a bit strange but I need to duplicate a database on RHEL 5.4 to AIX 7.1 with different directory structure.
The problem I have is restoring the controlfile. Here is what I have done:
1. backup the whole database with controlfile and spfile autobackup on.
2. copy the backup files to destination server
3. startup the instance using a modified version of init file from the source database.
4. the structure is different, so I try the following restore controlfile command, and see what happens :
[CODE]
RMAN> set dbid=2028087173
executing command: SET DBID
RMAN> restore controlfile from '/oradata/c-2028087173-20140215-02';
Starting restore at 15-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/15/2014 18:40:19
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
[/CODE]
I've looked through many solutions and blogs to tackle this issue, but this thing always happens. Even creating a recovery destination (It cannot be the same as source structure because of the allocated LUNs are different and different size) and putting the files there did not help.
Any ideas or tips?