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

Thread: Can I do 2+ database backup's in one RMAN session?

  1. #1
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204

    Can I do 2+ database backup's in one RMAN session?

    Platform RedHat 3/SuSe 8
    Ver 9.2

    I want to backup multiple databases on one allocated "channel". Is this possible?

    Example script:
    CONNECT TARGET sys/pwd@DB1;
    run {
    allocate channel t1 type 'sbt_tape';
    backup database format '/oracle/backup/DB1/%u';
    }
    CONNECT TARGET sys/pwd@DB2;
    run {
    backup database format '/oracle/backup/DB2/%u';
    release channel t1;
    }
    exit;
    Last edited by KenEwald; 03-22-2004 at 11:34 AM.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Why would you want to do that?
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Just thinking I'd save the couple of minutes it takes to queue the tape up between each database backup.

    I logged a TAR and basically they said I couldn't do it that way.

    I'd really like some constructive help here.

    What's a good way to backup multiple databases and keep the tape drive hoppin'?

    -Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Well you could invoke two simultaneous rman sessions, have you given that a try? Also does your tape device support streams so that you might really get it hopin?

    Regards,

    Steve
    I'm stmontgo and I approve of this message

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