Hi Subin Hameed,
See Metalink 358171.1 and Note:433335.1. It talks about the change between
9i and 10g and why you need SET PARALLELMEDIARESTORE OFF.
Oracle support recommends the use of RMAN syntax similar to the following to
disable the requirement that the media management layer must pass
SBTBFINFO_SHARE_MULTIPLE to use multiple channels.
SET PARALLELMEDIARESTORE OFF;
RUN {
ALLOCATE CHANNEL ... TYPE 'SBT_TAPE' ... ;
ALLOCATE CHANNEL ... TYPE 'SBT_TAPE' ... ;
RESTORE DATABASE;
}
Regards,
Amar
On Sat, May 7, 2011 at 11:13 PM, Subin Shahul Hameed <subin.hameed AT gmail DOT
com
> wrote:
> Hi,
>
> We are using Networker module for Oracle. Oracle DB 11g release is
> 11.1.0.7. We are not using catalog database. While taking backup we
> are using
> 4 channels and it uses 4 channels to write to single tape. For
> restoration we are using 2 channels, but it is using only 1. Hence
> restore is getting delayed.
> What could be the reason? We are writing INDEX files also to same
> tape as backup tape.
>
>
> Backup scripts are given below:
>
>
> Backup Software:
> EMC Networker 7.5.1 Build 269
> Networker Module for Oracle 4.5
>
> Backup Hardware:
> Tape Library: FibreCAT TX48 with 2 LTO4 Drives and 12 slots (1 slot
> dedicated for cleaning tape).
>
>
> Group details are given below:
> ----
> group details
>
> nsradmin> print
> type: NSR group;
> name: KAU11PUB1_ORCL_LEVEL1;
> comment: DB incremental backup (level 1);
> snapshot: False;
> autostart: Enabled;
> autorestart: Disabled;
> start time: "17:00";
> last start: "Sat May 7 17:00:00 2011";
> last end: "Sat May 7 17:58:00 2011";
> interval: "24:00";
> restart window: "12:00";
> force incremental: No;
> savegrp parallelism: 0;
> client retries: 1;
> clones: No;
> clone pool: Default Clone;
> success threshold: Warning;
> options: Manual restart;
> level: ;
> printer: ;
> schedule: Inc. all days skip Friday;
> schedule time: ;
> expiration time: ;
> inactivity timeout: 30;
> File inactivity threshold: 30;
> File inactivity alert threshold: 30;
> work list: ;
> completion: db1,
> /home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv,
> "succeeded:incr:save:nsrnmo_KAU11PUB1",
> "* savegrp: suppressed 2 lines of verbose output
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv released channel:
> c4
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv Recovery
> Manager complete.
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv RMAN returned
> success.
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv The nwora.res
> has been backed up.
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv Reverse DNS
> lookup failed for address 192.168.255.1
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv
> db1: Oracle Backup:
> /home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv level=full,
> 5712 MB 00:54:28 11 files
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv
> * db1:/home/oracle/scripts/rman_hot_KAU11PUB1_level1.rcv ", db1,
> index, "succeeded:9:index",
> " backup_db: index:db1 level=9, 8 KB 00:00:00 14
> fi\
> les",
> backup_db, bootstrap, "succeeded:0:bootstrap",
> " backup_db: bootstrap level=full, 513 KB 00:03:22 342
> fi\
> les";
> status: idle;
> Snapshot Policy: Daily;
> Snapshot Pool: Default;
> probe based group: False;
> probe interval: 60;
> probe start time: "0:00";
> probe end time: "23:59";
> probe success criteria: all;
> time since successful backup: 0;
> time of the last successful backup: ;
>
> type: NSR group;
> name: KAU11PUB1_ORCL_LEVEL0;
> comment: full DB backup (level 0);
> snapshot: False;
> autostart: Enabled;
> autorestart: Disabled;
> start time: "12:00";
> last start: "Sat May 7 20:14:01 2011";
> last end: ;
> interval: "24:00";
> restart window: "12:00";
> force incremental: No;
> savegrp parallelism: 0;
> client retries: 1;
> clones: No;
> clone pool: Default Clone;
> success threshold: Warning;
> options: ;
> level: ;
> printer: ;
> schedule: Full every friday skip rest;
> schedule time: ;
> expiration time: ;
> inactivity timeout: 30;
> File inactivity threshold: 30;
> File inactivity alert threshold: 30;
> work list: db1, "full:save:nsrnmo_KAU11PUB1",
> /home/oracle/scripts/rman_hot_KAU11PUB1_level0.rcv,
> db1, "full:index", index;
> completion: ;
> status: running;
> Snapshot Policy: Daily;
> Snapshot Pool: Default;
> probe based group: False;
> probe interval: 60;
> probe start time: "0:00";
> probe end time: "23:59";
> probe success criteria: all;
> time since successful backup: 0;
> time of the last successful backup: ;
>
> type: NSR group;
> name: Default;
> comment: ;
> snapshot: False;
> autostart: Disabled;
> autorestart: Disabled;
> start time: "3:33";
> last start: "Sat May 7 20:11:56 2011";
> last end: "Sat May 7 20:12:47 2011";
> interval: "24:00";
> restart window: "12:00";
> force incremental: Yes;
> savegrp parallelism: 0;
> client retries: 1;
> clones: No;
> clone pool: Default Clone;
> success threshold: Warning;
> options: ;
> level: ;
> printer: ;
> schedule: ;
> schedule time: ;
> expiration time: ;
> inactivity timeout: 30;
> File inactivity threshold: 30;
> File inactivity alert threshold: 30;
> work list: backup_db, "full:save", /boot, backup_db,
> "full:save", /, backup_db, "9:index", index;
> completion: ;
> status: idle;
> Snapshot Policy: Daily;
> Snapshot Pool: Default;
> probe based group: False;
> probe interval: 60;
> probe start time: "0:00";
> probe end time: "23:59";
> probe success criteria: all;
> time since successful backup: 0;
> time of the last successful backup: ;
> ----
>
> Thanks in advance and waiting for your inputs.
>
> Thanks,
> Subin Hameed
>
> To sign off this list, send email to listserv AT listserv.temple DOT edu and
> type
> "signoff networker" in the body of the email. Please write to
> networker-request AT listserv.temple DOT edu if you have any problems with
> this
> list. You can access the archives at
> http://listserv.temple.edu/archives/networker.html or
> via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
>
>
To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|
