-
RMAN-05019 Warning
I have a "Oracle recommended backup" running on disk. It backsup to the FLASH recovery area. The job runs and it completes every time with this warning:
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile n
Where n= 1-19
I tried looking this error up but can't find much info on it. I found some info that said to use the LIST command and then allocate the proper type to stop the error. I'm a little new to Oracle. Where do I see what type needs to be allocated? And how do I change the allocation? I am using a combonation of command line and EM. Thanks for the help
Paul
-
Hi Paul
Can you please post the generated script here.
ALso at the RMAN prompt can you say
RMAN>SHOW DEVICE TYPE
and then post the contents here
RMAN>SHOW DATAFILE BACKUP COPIES
regards
Hrishy
Last edited by hrishy; 09-11-2007 at 01:13 AM.
-
RMAN Script
Here is the output log:
connected to target database: AX (DBID=2713737753)
using target database control file instead of recovery catalog
echo set on
Starting recover at 11-SEP-07
run {
allocate channel oem_disk_backup device type disk;
recover
allocated channel: oem_disk_backup
channel oem_disk_backup: sid=499 instance=ax1 devtype=DISK
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 1
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 2
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 3
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 4
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 5
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 6
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 7
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 8
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 9
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 10
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 11
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 12
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 13
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 14
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 15
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 16
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 17
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 18
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile 19
Finished recover at 11-SEP-07
Starting backup at 11-SEP-07
channel oem_disk_backup: starting incremental level 1 datafile backupset
channel oem_disk_backup: specifying datafile(s) in backupset
input datafile fno=00009 name=+DATA/ax/datafile/phigh1.ora
input datafile fno=00010 name=+DATA/ax/datafile/pgrow1.ora
input datafile fno=00013 name=+DATA/ax/datafile/phuge1.ora
input datafile fno=00002 name=+DATA/ax/datafile/undotbs1.258.622126609
input datafile fno=00016 name=+DATA/ax/datafile/ihigh1.ora
input datafile fno=00017 name=+DATA/ax/datafile/igrow1.ora
input datafile fno=00011 name=+DATA/ax/datafile/pmedium1.ora
input datafile fno=00003 name=+DATA/ax/datafile/sysaux.257.622126609
input datafile fno=00018 name=+DATA/ax/datafile/imedium1.ora
input datafile fno=00006 name=+DATA/ax/datafile/undotbs2.265.622126955
input datafile fno=00001 name=+DATA/ax/datafile/system.256.622126607
input datafile fno=00004 name=+DATA/ax/datafile/users.259.622126609
input datafile fno=00008 name=+DATA/ax/datafile/pstatic1.ora
input datafile fno=00012 name=+DATA/ax/datafile/pdynamo1.ora
input datafile fno=00015 name=+DATA/ax/datafile/istatic1.ora
input datafile fno=00005 name=+DATA/ax/datafile/example.264.622126791
input datafile fno=00007 name=+DATA/ax/datafile/pblob1.ora
input datafile fno=00019 name=+DATA/ax/datafile/idynamo1.ora
input datafile fno=00014 name=+DATA/ax/datafile/iblob1.ora
channel oem_disk_backup: starting piece 1 at 11-SEP-07
channel oem_disk_backup: finished piece 1 at 11-SEP-07
piece handle=+FLASH/ax/backupset/2007_09_11/nnndn1_tag20070911t020015_0.2503.632973617 tag=TAG20070911T020015 comment=NONE
channel oem_disk_backup: backup set complete, elapsed time: 00:04:45
Finished backup at 11-SEP-07
Starting Control File and SPFILE Autobackup at 11-SEP-07
piece handle=+FLASH/ax/autobackup/2007_09_11/s_632973901.2504.632973903 comment=NONE
Finished Control File and SPFILE Autobackup at 11-SEP-07
released channel: oem_disk_backup
exit;
SHow device type;
RMAN configuration parameters are:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
RMAN> show datafile backup copies;
RMAN configuration parameters are:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
I have Symantec Backup Exec running at other times, it backs up to tape. This backup that is failing is supposed to go to Disk. Thanks for your help!
-
Hi
Whats the output of
RMAN> LIST COPY OF DATAFILE 1, 2, 3
My suspicion is that the symantic backup you ran backed up a.k.a moved the contents (datafile copies) to the tape am i right ?
regards
Hrishy
-
RMAN Output
Here is the result of that RMAN command:
RMAN> list copy of datafile 1, 2, 3;
using target database control file instead of recovery catalog
List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
30 1 A 24-AUG-07 5011977798 23-AUG-07 +FLASH/ax/datafile/sys
tem.2130.631249999
32 2 A 24-AUG-07 5011977798 23-AUG-07 +FLASH/ax/datafile/und
otbs1.2123.631249633
23 3 A 24-AUG-07 5011977798 23-AUG-07 +FLASH/ax/datafile/sys
aux.2127.631249883
RMAN>
SYamntec BAckup Exec does backup files onto the tape unit. Thanks for your help!
-
Hi
Whats the output of the following commands
report obsolete;
crosscheck backup;
crosscheck copy;
I asked arounf about this problem to friends and
Here is what Niall Litchfeild asked me can you post answers to this questions too
Is your ASM instance up and running ?
is the FLASH disk group available within ASM
regards
Hrishy
Last edited by hrishy; 09-13-2007 at 07:13 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|