RMAN Restore Failed RMAN-06100: no channel to restore a backup or copy of datafile n

_____________________________________________________________________________________________________________________

Problem Description

Rman restore command failed with following error.

RMAN-06100: no channel to restore a backup or copy of datafile

RMAN> run {

set newname for database to new;

restore database;

}

executing command: SET NEWNAME

Starting restore at 07-NOV-16

Starting implicit crosscheck backup at 07-NOV-16

allocated channel: ORA_DISK_1

Crosschecked 7 objects

Finished implicit crosscheck backup at 07-NOV-16

Starting implicit crosscheck copy at 07-NOV-16

using channel ORA_DISK_1

Crosschecked 2 objects

Finished implicit crosscheck copy at 07-NOV-16

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: +DATA/CAMUAT/ARCHIVELOG/2016_10_24/thread_1_seq_569.437.926035203

File Name: +DATA/CAMUAT/ARCHIVELOG/2016_10_23/thread_2_seq_361.434.926035055

File Name: +DATA/CAMUAT/DATAFILE/p_data.269.923107265

File Name: +DATA/CAMUAT/DATAFILE/p_indexes.270.923107265

File Name: +DATA/CAMUAT/DATAFILE/p_lobs.296.923107265

File Name: +DATA/CAMUAT/DATAFILE/ggs_data.265.923147011

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 11/07/2016 04:57:23

RMAN-06026: some targets not found - aborting restore

RMAN-06100: no channel to restore a backup or copy of datafile 9

……..

………..

RMAN-06100: no channel to restore a backup or copy of datafile 1

RMAN> restore database;

Starting restore at 07-NOV-16

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 11/07/2016 05:01:54

RMAN-06026: some targets not found - aborting restore

RMAN-06100: no channel to restore a backup or copy of datafile 9

……..

………..

RMAN-06100: no channel to restore a backup or copy of datafile 1

Solution Description

Catalog the backup files in RMAN to get it identified.

RMAN> catalog start with '/u02/DBBKUP/CAMUAT/FULL_';

searching for all files that match the pattern /u02/DBBKUP/CAMUAT/FULL_

List of Files Unknown to the Database

=====================================

File Name: /u02/DBBKUP/CAMUAT/FULL_1srgas5s_60_1

File Name: /u02/DBBKUP/CAMUAT/FULL_07rfp3qn_7_1

File Name: /u02/DBBKUP/CAMUAT/FULL_1rrgas5d_59_1

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /u02/DBBKUP/CAMUAT/FULL_1srgas5s_60_1

File Name: /u02/DBBKUP/CAMUAT/FULL_07rfp3qn_7_1

File Name: /u02/DBBKUP/CAMUAT/FULL_1rrgas5d_59_1

RMAN> run {

set newname for database to new;

restore database;

}

executing command: SET NEWNAME

Starting restore at 07-NOV-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to +DATA

channel ORA_DISK_1: restoring datafile 00002 to +DATA

channel ORA_DISK_1: restoring datafile 00003 to +DATA

channel ORA_DISK_1: restoring datafile 00004 to +DATA

channel ORA_DISK_1: restoring datafile 00005 to +DATA

channel ORA_DISK_1: restoring datafile 00006 to +DATA

channel ORA_DISK_1: restoring datafile 00007 to +DATA

channel ORA_DISK_1: restoring datafile 00008 to +DATA

channel ORA_DISK_1: restoring datafile 00009 to +DATA

channel ORA_DISK_1: reading from backup piece /u02/DBBKUP/CAMUAT/FULL_1rrgas5d_59_1

_____________________________________________________________________________________________________________________

Website Stats