Home » RDBMS Server » Backup & Recovery » RMAN-06100: no channel to restore a backup or copy of datafile (oracle 10g,win2003)
RMAN-06100: no channel to restore a backup or copy of datafile [message #527611] Wed, 19 October 2011 05:28
spoutnick
Messages: 1
Registered: October 2011
Junior Member
Hi,
I am cuurently ty to restore and recover my database , i have made a backup using rman
RUN{
ALLOCATE CHANNEL DISK1 TYPE DISK ;
BACKUP FORMAT 'E:/sav_ora/disk1/df/df_%d_%t_%s_%p' INCREMENTAL LEVEL 1 CUMULATIVE DATABASE tag='TEST_BACK_DATAFILE
SQL 'ALTER SYSTEM SWITCH LOGFILE' ;
BACKUP FORMAT 'E:/sav_ora/disk1/al/al_%d_%t_%s_%p' archivelog all delete input tag='TEST_BACK_ARCHIVE
BACKUP FORMAT 'E:/sav_ora/disk1/ctl/ctl_%d_%t_%s_%p' current controlfile tag='TEST_BACK_CONTROL
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE SPFILE FORMAT 'E:/sav_ora/disk1/spfile/spfile_%d_%s_%T.bak' tag 'spfile backup'
}

i try to restore and recover to the new host , i follow this steps:

step 1
RMAN TARGET SYS
SET DBID ******
STARTUP NOMOUNT

STEP 2
run
{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'E:/sav_ora/disk1/spfile/spfile_%d_%s_%T.bak
RESTORE SPFILE TO PFILE 'E:/Oracle/orahome/database/spfile.ora' from 'E:/sav_ora/DISK1/spfile/SPFILE_1_20111011.BAK' ;
shutdown abort;
}
STEP 3
EDITE SPFILE( NEW LOCATIOPN FOR CONTROL FILE )

STEP 4
startup force nomount pfile='E:/Oracle/ora/spfilE.ora'
run
{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'e:/sav_ora/disk1/ctl/ctl_%d_%t_%s_%p
restore controlfile from 'e:/sav_ora/disk1/ctl/CTL_764351445_58_1
}
step 5
ALTER DATABASE MOUNT;
step 6
rman>catalog backuppiece 'E:/sav_ora/disk1/df/DF_763986691_1661_1'
run{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'E:/sav_ora/disk1/df/df_%d_%t_%s_%p';
RESTORE DATABASE;
SWITCH DATAFILE ALL;
ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT 'E:/sav_ora/disk1/al/al_%d_%t_%s_%p';
RECOVER DATABASE;
}


after that i got error in
Starting restore at 19/10/11
using channel ORA_DISK_1

RMAN-00571: ==========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==============
RMAN-00571: ==========================================================
RMAN-03002: failure of restore command at 10/19/2011 09:47:07
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 63
RMAN-06100: no channel to restore a backup or copy of datafile 62
RMAN-06100: no channel to restore a backup or copy of datafile 61
RMAN-06100: no channel to restore a backup or copy of datafile 60
RMAN-06100: no channel to restore a backup or copy of datafile 57
RMAN-06100: no channel to restore a backup or copy of datafile 56
RMAN-06100: no channel to restore a backup or copy of datafile 55
RMAN-06100: no channel to restore a backup or copy of datafile 54
RMAN-06100: no channel to restore a backup or copy of datafile 53
RMAN-06100: no channel to restore a backup or copy of datafile 52
RMAN-06100: no channel to restore a backup or copy of datafile 51
RMAN-06100: no channel to restore a backup or copy of datafile 50
RMAN-06100: no channel to restore a backup or copy of datafile 49
RMAN-06100: no channel to restore a backup or copy of datafile 48
RMAN-06100: no channel to restore a backup or copy of datafile 47
RMAN-06100: no channel to restore a backup or copy of datafile 46
RMAN-06100: no channel to restore a backup or copy of datafile 45
RMAN-06100: no channel to restore a backup or copy of datafile 44
RMAN-06100: no channel to restore a backup or copy of datafile 43
RMAN-06100: no channel to restore a backup or copy of datafile 42
RMAN-06100: no channel to restore a backup or copy of datafile 41
RMAN-06100: no channel to restore a backup or copy of datafile 40
RMAN-06100: no channel to restore a backup or copy of datafile 39
RMAN-06100: no channel to restore a backup or copy of datafile 38
RMAN-06100: no channel to restore a backup or copy of datafile 37
RMAN-06100: no channel to restore a backup or copy of datafile 36
RMAN-06100: no channel to restore a backup or copy of datafile 35
RMAN-06100: no channel to restore a backup or copy of datafile 34
RMAN-06100: no channel to restore a backup or copy of datafile 33
RMAN-06100: no channel to restore a backup or copy of datafile 32
RMAN-06100: no channel to restore a backup or copy of datafile 31
RMAN-06100: no channel to restore a backup or copy of datafile 30
RMAN-06100: no channel to restore a backup or copy of datafile 29
RMAN-06100: no channel to restore a backup or copy of datafile 28
RMAN-06100: no channel to restore a backup or copy of datafile 27
RMAN-06100: no channel to restore a backup or copy of datafile 26
RMAN-06100: no channel to restore a backup or copy of datafile 25
RMAN-06100: no channel to restore a backup or copy of datafile 24
RMAN-06100: no channel to restore a backup or copy of datafile 23
RMAN-06100: no channel to restore a backup or copy of datafile 22
RMAN-06100: no channel to restore a backup or copy of datafile 21
RMAN-06100: no channel to restore a backup or copy of datafile 20
RMAN-06100: no channel to restore a backup or copy of datafile 19
RMAN-06100: no channel to restore a backup or copy of datafile 18
RMAN-06100: no channel to restore a backup or copy of datafile 17
RMAN-06100: no channel to restore a backup or copy of datafile 16
RMAN-06100: no channel to restore a backup or copy of datafile 15
RMAN-06100: no channel to restore a backup or copy of datafile 14
RMAN-06100: no channel to restore a backup or copy of datafile 13
RMAN-06100: no channel to restore a backup or copy of datafile 12
RMAN-06100: no channel to restore a backup or copy of datafile 11
RMAN-06100: no channel to restore a backup or copy of datafile 10
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 8
RMAN-06100: no channel to restore a backup or copy of datafile 7
RMAN-06100: no channel to restore a backup or copy of datafile 6
RMAN-06100: no channel to restore a backup or copy of datafile 5
RMAN-06100: no channel to restore a backup or copy of datafile 4
RMAN-06100: no channel to restore a backup or copy of datafile 3
RMAN-06100: no channel to restore a backup or copy of datafile 2
RMAN-06100: no channel to restore a backup or copy of datafile 1





thanks in advance,

Sincerely Merouan
Previous Topic: RMAN script query
Next Topic: RMAN Cloning issues
Goto Forum:
  


Current Time: Wed Jul 23 09:21:00 CDT 2014

Total time taken to generate the page: 0.11836 seconds