DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 22

Thread: RMAN-05019 Warning

Hybrid View

  1. #1
    Join Date
    May 2007
    Posts
    24

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    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.

  3. #3
    Join Date
    May 2007
    Posts
    24

    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!

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    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

  5. #5
    Join Date
    May 2007
    Posts
    24

    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!

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    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
  •  


Click Here to Expand Forum to Full Width