18: i number;
19: indx number := 0;
20: dbcount number;
21: ret boolean;
22: restoreRangeTab sys.dbms_rcvman.restoreRangeTab_t;
23:
24: CURSOR getAllDb_c IS SELECT dbid FROM v$database;
25: dbDetail getAllDb_c%rowtype;
26:
32:
33: while n < dbcount and self.done = 0 loop
34: n := n + 1;
35:
36: sys.dbms_rcvman.resetAll;
37: sys.dbms_rcvman.setAllIncarnations(TRUE);
38:
39: if (opCode = 'V$ANY') then
40: sys.dbms_rcvman.setDeviceTypeAny;
33: while n < dbcount and self.done = 0 loop
34: n := n + 1;
35:
36: sys.dbms_rcvman.resetAll;
37: sys.dbms_rcvman.setAllIncarnations(TRUE);
38:
39: if (opCode = 'V$ANY') then
40: sys.dbms_rcvman.setDeviceTypeAny;
41: elsif (opCode = 'V$DISK') then
36: sys.dbms_rcvman.resetAll;
37: sys.dbms_rcvman.setAllIncarnations(TRUE);
38:
39: if (opCode = 'V$ANY') then
40: sys.dbms_rcvman.setDeviceTypeAny;
41: elsif (opCode = 'V$DISK') then
42: sys.dbms_rcvman.setDeviceType('DISK');
43: elsif (opCode = 'V$SBT') then
44: sys.dbms_rcvman.setDeviceType('SBT_TAPE');
38:
39: if (opCode = 'V$ANY') then
40: sys.dbms_rcvman.setDeviceTypeAny;
41: elsif (opCode = 'V$DISK') then
42: sys.dbms_rcvman.setDeviceType('DISK');
43: elsif (opCode = 'V$SBT') then
44: sys.dbms_rcvman.setDeviceType('SBT_TAPE');
45: end if;
46:
40: sys.dbms_rcvman.setDeviceTypeAny;
41: elsif (opCode = 'V$DISK') then
42: sys.dbms_rcvman.setDeviceType('DISK');
43: elsif (opCode = 'V$SBT') then
44: sys.dbms_rcvman.setDeviceType('SBT_TAPE');
45: end if;
46:
47: fetch getAllDb_c into dbDetail;
48: sys.dbms_rcvman.setdatabase(NULL, NULL, NULL, dbDetail.dbid);
44: sys.dbms_rcvman.setDeviceType('SBT_TAPE');
45: end if;
46:
47: fetch getAllDb_c into dbDetail;
48: sys.dbms_rcvman.setdatabase(NULL, NULL, NULL, dbDetail.dbid);
49:
50: ret := sys.dbms_rcvman.getRestoreRangeSet(restoreRangeTab,
51: opCode,
52: dbDetail.dbid);
46:
47: fetch getAllDb_c into dbDetail;
48: sys.dbms_rcvman.setdatabase(NULL, NULL, NULL, dbDetail.dbid);
49:
50: ret := sys.dbms_rcvman.getRestoreRangeSet(restoreRangeTab,
51: opCode,
52: dbDetail.dbid);
53: i := to_number(null);
54: LOOP