DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 22

Thread: RMAN-05019 Warning

  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.

  7. #7
    Join Date
    May 2007
    Posts
    24

    Results:

    Hi Hrishy;
    I attached the files for those reports, as the outputs were long. The ASM instance is running fine and the FLASH disk group is available in ASM. Those obsolete files, is there something I have to do with those or does Oracle get rid of them. Thanks for all your help!
    All 3 logs are in the zip file
    Paul
    Attached Files Attached Files

  8. #8
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    How does your rman backup script look like is it similar to the one below.

    Code:
    run {
    allocate channel oem_backup_disk1 type disk format 'd:\mad3_nightly_backups\%U';
    backup incremental level 1 database include current controlfile;
    recover copy of database;
    backup as BACKUPSET tag 'mybackupset' archivelog all not backed up delete all input;
    report obsolete;
    crosscheck backup;
    crosscheck copy;
    report need backup;
    report unrecoverable;
    release channel oem_backup_disk1;
    }
    You can get rid of those obsolete copies using the following rman commands

    Code:
    RMAN>DELETE NOPROMPT OBSOLETE EXPIRED BACKUP
    RMAN>DELETE NOPROMPT OBSOLETE EXPIRED ARCHIVELOG ALL
    RMAN>DELETE NOPROMPT OBSOLETE EXPIRED COPY
    the above code is going to delete expired and obsolete backups and copies of datafile and also archived logs

  9. #9
    Join Date
    May 2007
    Posts
    24

    Script

    This job was set up in EM. Here is the "Daily backup Script" it generated:

    run {
    allocate channel oem_disk_backup device type disk;
    recover copy of database with tag 'ORA\$OEM_LEVEL_0';
    backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database;
    }

    Am I better off deleting this job from EM and creating a new job in RMAN? I know RMAN gives more power/functionality than EM. Thanks again

    Paul

  10. #10
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Paul

    Well logically speaking it shouldnt matter much since under the covers those fancy GUI widgets again call RMAN.

    What i would like to try is this manually and see what happens

    Code:
    RMAN>DELETE NOPROMPT OBSOLETE EXPIRED BACKUP
    RMAN>DELETE NOPROMPT OBSOLETE EXPIRED ARCHIVELOG ALL
    RMAN>DELETE NOPROMPT OBSOLETE EXPIRED COPY
    
    run {
    allocate channel oem_disk_backup device type disk;
    recover copy of database with tag 'ORA\$OEM_LEVEL_0';
    backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database;
    }
    regards
    Hrishy

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