Forum Discussion

Karthikeyan_Sun's avatar
Karthikeyan_Sun
Level 6
13 years ago
Solved

Question on RMAN DB Restore Channels

 

One of my DBA has triggered this DB Restore which was backed up via RMAN. Even though he have given 3 Channels, it has triggered 12 restore jobs in activity monitor. Not sure how this happened. Any Idea?
 
 
run {
allocate channel ch1 device type 'sbt';
allocate channel ch2 device type 'sbt';
allocate channel ch3 device type 'sbt';
send 'NB_ORA_POLICY=DB_rman_full,NB_ORA_SERV=master-bk';
restore database;
release channel ch1;
release channel ch2;
release channel ch3;
}
 
Agents
Backup and Recovery
NetBackup
  • Yasuhisa_Ishika's avatar
    Yasuhisa_Ishika
    13 years ago
    "it will generate jobs as per the channels given", this is not correct. When oracle request backup pieces to NetBackup througt sbt interface, one job will be generated for each backup piece. From Oracle perspective, 3 channel means you can read and write up to 3 backup pieces simultaneously. In this case, your database backup consist of 12 backup pieces. On each channel, Oracle read backup pieces one by one - one piece is eneded, next piece begins. You can understand this more by comparing RMAN log and reuested files on each restore jobs. Backup piece handle is passed as file name from Oracle to NetBackup.

7 Replies

Sort By
  • Nicolai's avatar
    Nicolai
    Moderator
    13 years ago

    Did he fire off the restore rcv script multiple times?. Check the times in the activity monitor.

  • Will_Restore's avatar
    Will_Restore
    Level 6
    13 years ago

    Check the details of each item. I'm guessing there are child tasks of the three parent jobs.

  • Yasuhisa_Ishika's avatar
    Yasuhisa_Ishika
    Level 6
    13 years ago

    triggered 12 restore jobs in activity monitor

    Does this mean 12 jobs goes active simultaneously or 12 jobs were generated onsecutively?

    If you mean later, it is normal. From Oracle perspective, 12 backup pieces were read for restore.

  • Karthikeyan_Sun's avatar
    Karthikeyan_Sun
    Level 6
    13 years ago

    Yes, I see it was not triggered simultaneously, instead it was one by one..If you say normal, how does the 12 pieces calculated for 3 channels..So does that mean 4 streams will be created for restore read per channel?

    I had time to look at documents which all say me that, it will generate jobs as per the channels given.

    BTW, Appreciate your help. I have seen many of  the discussions on oracle issues during this issue research. You are really helping many of us.

  • Yasuhisa_Ishika's avatar
    Yasuhisa_Ishika
    Level 6
    13 years ago
    "it will generate jobs as per the channels given", this is not correct. When oracle request backup pieces to NetBackup througt sbt interface, one job will be generated for each backup piece. From Oracle perspective, 3 channel means you can read and write up to 3 backup pieces simultaneously. In this case, your database backup consist of 12 backup pieces. On each channel, Oracle read backup pieces one by one - one piece is eneded, next piece begins. You can understand this more by comparing RMAN log and reuested files on each restore jobs. Backup piece handle is passed as file name from Oracle to NetBackup.