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

advertisements

_____________________________________________________________________________________________________________________

Problem Description

RMAN restore command failed with following error. 

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

Example

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