Results 1 to 5 of 5
  1. #1
    Join Date
    May 2010
    Posts
    5

    Unanswered: RMAN-06100 no channel to restore a backup or copy of datafile 1

    Hi,

    i have a problem with the rman restore from a diffrent Location.

    i receive always this error message:
    statement:
    run {
    allocate channel 'd1' TYPE DISK;
    allocate channel 'd2' TYPE DISK;
    allocate channel 'd3' TYPE DISK;
    allocate channel 'd4' TYPE DISK;
    set newname for datafile 1 to 'D:\oraData\DB1\name1';
    set newname for datafile 2 to 'D:\oraData\DB1\name2';
    set newname for datafile 3 to 'D:\oraData\DB1\name3';
    set newname for datafile 4 to 'D:\oraData\DB1\name4';
    restore database;
    switch datafile all;
    }

    error message:
    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

    i need the change the path because the normal db is running on a asm storage and it began with a + and not with the drive letter like "D:\"
    statement: select name from v$datafile

    +Database1/name1
    +Database1/name2
    +Database1/name3
    +Database1/name4

    how can i change that.

    Thanks
    Chris

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    6100, 1, "no channel to restore a backup or copy of datafile %d"
    // *Cause:  A datafile, tablespace, or database restore could not proceed
    //          because the backup of the indicated file exists on a device type
    //          that was not allocated for restore.
    // *Action: None - this is an informational message.  See message 6026 for
    //          further details.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2010
    Posts
    5
    Hi,

    thank you for your fast reply on my Thread.

    but could you tell me how to fix this, i am new in Oracle things.

    Thanks
    Chris

  4. #4
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    kolti,

    you seem to think, these RMAN commands copy the datafiles of your db from ASM to a filesystem.

    In fact, you told RMAN to restore the last backup of the database (with the indicated datafiles on filesystem instead on ASM and all other database files where they are).
    By the way: Restore ist not enough. You also have to recover

    The error message more or less indicates, you don't have access to the backup device or the backup pieces.

    If you wanted to CLONE the database, you have used a wrong approach (google for "clone oracle database with rman", there are dozens of to-do's out on the web).
    But at least you'd need access to the backup.
    (only in 11.2. In versions up to 11.1 you also need a DBA connect into the source database and access to the not-yet-backed-up archive logs)
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  5. #5
    Join Date
    May 2010
    Posts
    5
    this works now i miss to use the catalog pieces before running db restore script, this works now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •