Database Software

Hi All, I am trying to restore DB from one server to another using RMAN. I took backup of source DB and mounted backup location on Traget server.

I allready created requried directory and pfile on the target server. I am facing problem during restore controlfile from autobackup. Below is what I was trying on my target sever.

oracle@mpbdb:/backup/TEST> . oraenv
ORACLE_SID = [TEST] ?
The Oracle base remains unchanged with value /u01/app/oracle

rman target /


RMAN> startup nomount;

Oracle instance started

Total System Global Area 785227776 bytes

Fixed Size 2106616 bytes
Variable Size 201333512 bytes
Database Buffers 578813952 bytes
Redo Buffers 2973696 bytes


RMAN> set DBID 3194512843

RMAN> restore controlfile from autobackup;

Starting restore at 27-DEC-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=537 device type=DISK

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121227
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121226
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121225
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121224
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121223
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121222
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121221
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 12/27/2012 12:46:13
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece


Here is RMAN setting on my target server for this unmounted database.

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TEST are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default



-------------------------

Rman setting on source sever.

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TEST are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/%d/controlfile_backup_%d_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/%d/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.1.0/dbs/snapcf_TEST1.f'; # default


Can you pleae give some idea why my target DB is not able to see controlfile autobackup.

My source and Target DB is 11.1.0.7 But my source DB is under ASM, and I am trying to migrate from ASM to NonASM.

Thanks