Networker

[Networker] rman restore using only 1 channel

2011-05-07 13:43:53
Subject: [Networker] rman restore using only 1 channel
From: Subin Shahul Hameed <subin.hameed AT GMAIL DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Sat, 7 May 2011 21:43:17 +0400
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

Attachment: scripts.txt
Description: Text document

<Prev in Thread] Current Thread [Next in Thread>