_____________________________________________________________________________________________________________________
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
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment