This discussion is archived
5 Replies Latest reply: Aug 16, 2013 1:40 AM by 2f445178-c6b6-4865-b500-396039f41a2c RSS

DUPLICATE DATABASE FROM TAPE BACKUPS

2f445178-c6b6-4865-b500-396039f41a2c Newbie
Currently Being Moderated


Hi,

 

I wonder if anyone can help me. My environment is Linux and the Oracle version is 11.2.0.3.0. I am attempting to clone a database from one server to another utilising a tape backup (not from active database). I have set up the relevant TNS entries, so the two systems can communicate. I created a password file and a PFILE in the destination server and I started up (NOMOUNT) the instance.

 

Initially I attempted the operation from the destination server; I received error such as: RMAN-06100: no channel to restore a backup or copy of datafile 11

 

Suspecting that the destination server may not have the appropriate access level in the MLL, I attempted the operation from the source server.

But I am getting: RMAN-06101: no channel to restore a backup or copy of the control file

 

Source database: MM1

Destination (cloned) database: MBA

 

RMAN script

------------------

connect target /
connect auxiliary sys/********@MBA

run {
allocate channel 'dev_01' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
allocate channel 'dev_02' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
allocate channel 'dev_03' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
allocate channel 'dev_04' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE disk;
set until time "to_date('14-aug-2013:16:20','dd-mon-YYYY:hh24:mi')";
DUPLICATE TARGET DATABASE TO MBA NOFILENAMECHECK;
release channel c1;
release channel 'dev_01';
release channel 'dev_02';
release channel 'dev_03';
release channel 'dev_04';
}

 

Log:

------

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Aug 15 11:27:24 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN>
RMAN>
connected to target database: MM1 (DBID=1713891644)

RMAN>
connected to auxiliary database: MBA (not mounted)

RMAN>
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>
using target database control file instead of recovery catalog
allocated channel: dev_01
channel dev_01: SID=188 device type=SBT_TAPE
channel dev_01: Data Protector A.06.20/PHSS_42081/PHSS_42082/DPSOL_00448/DPLNX_

allocated channel: dev_02
channel dev_02: SID=17 device type=SBT_TAPE
channel dev_02: Data Protector A.06.20/PHSS_42081/PHSS_42082/DPSOL_00448/DPLNX_

allocated channel: dev_03
channel dev_03: SID=191 device type=SBT_TAPE
channel dev_03: Data Protector A.06.20/PHSS_42081/PHSS_42082/DPSOL_00448/DPLNX_

allocated channel: dev_04
channel dev_04: SID=31 device type=SBT_TAPE
channel dev_04: Data Protector A.06.20/PHSS_42081/PHSS_42082/DPSOL_00448/DPLNX_

allocated channel: c1
channel c1: SID=161 device type=DISK

executing command: SET until clause

Starting Duplicate Db at 15-AUG-13

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    6631034880 bytes

Fixed Size                     2240744 bytes
Variable Size               2315259672 bytes
Database Buffers            4294967296 bytes
Redo Buffers                  18567168 bytes
allocated channel: c1
channel c1: SID=11 device type=DISK

contents of Memory Script:
{
   set until scn  208772810;
   sql clone "alter system set  db_name =
''MM1'' comment=
''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name =
''MBA'' comment=
''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile;
   alter clone database mount;
}
executing Memory Script

executing command: SET until clause

sql statement: alter system set  db_name =  ''MM1'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''MBA'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    6631034880 bytes

Fixed Size                     2240744 bytes
Variable Size               2315259672 bytes
Database Buffers            4294967296 bytes
Redo Buffers                  18567168 bytes
allocated channel: c1
channel c1: SID=160 device type=DISK

Starting restore at 15-AUG-13

released channel: dev_01
released channel: dev_02
released channel: dev_03
released channel: dev_04
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/15/2013 11:28:44
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06101: no channel to restore a backup or copy of the control file

RMAN>
RMAN>

Recovery Manager complete.

  • 1. Re: DUPLICATE DATABASE FROM TAPE BACKUPS
    Javier Francisco Ruiz Explorer
    Currently Being Moderated

    Does the auxiliary have access to the tape library? Using rman connect to target and auxiliary and do a show backup. Do you see the expected backups that you are trying to use?

  • 2. Re: DUPLICATE DATABASE FROM TAPE BACKUPS
    2f445178-c6b6-4865-b500-396039f41a2c Newbie
    Currently Being Moderated

    Yes. In fact I took another backup of the source database and the archive logs in the meantime. I can see these backups:

     

    RMAN> connect target /

    connected to target database: MM1 (DBID=1713891644)

    RMAN> connect auxiliary sys/*******@MBA

    connected to auxiliary database: MM1 (not mounted)

     

    RMAN> list backup of database completed between "to_date('15-aug-2013 10:00','dd-mon-yyyy hh24:mi')" and "to_date('15-aug-2013 14:40','dd-mon-yyyy hh24:mi')";

    using target database control file instead of recovery catalog

    List of Backup Sets
    ===================


    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27856   Full    6.85G      SBT_TAPE    00:01:16     15-AUG-13
            BP Key: 27856   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T122050
            Handle: 9lohbth2_1_1   Media: 8169830f:5208d804:64fa:00bd
      List of Datafiles in backup set 27856
      File LV Type Ckp SCN    Ckp Time  Name
      ---- -- ---- ---------- --------- ----
      2       Full 208885980  15-AUG-13 /oracle/MM1/sapdata1/sysaux_1/sysaux.data1
      5       Full 208885980  15-AUG-13 /oracle/MM1/sapdata1/mob_1/mob.data1
      11      Full 208885980  15-AUG-13 /oracle/MM1/sapdata1/system_2/system.data2

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27857   Full    2.33G      SBT_TAPE    00:01:48     15-AUG-13
            BP Key: 27857   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T122050
            Handle: 9mohbth2_1_1   Media: 8169830f:5208d804:64fa:00bd
      List of Datafiles in backup set 27857
      File LV Type Ckp SCN    Ckp Time  Name
      ---- -- ---- ---------- --------- ----
      1       Full 208885981  15-AUG-13 /oracle/MM1/sapdata1/system_1/system.data1
      3       Full 208885981  15-AUG-13 /oracle/MM1/sapdata1/undo_1/undo.data1
      7       Full 208885981  15-AUG-13 /oracle/MM1/sapdata1/mobusr_1/mobusr.data1

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27858   Full    1.62G      SBT_TAPE    00:02:04     15-AUG-13
            BP Key: 27858   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T122050
            Handle: 9nohbth3_1_1   Media: 8169830f:5208d804:64fa:00bd
      List of Datafiles in backup set 27858
      File LV Type Ckp SCN    Ckp Time  Name
      ---- -- ---- ---------- --------- ----
      4       Full 208885982  15-AUG-13 /oracle/MM1/sapdata1/undo_2/undo.data2
      8       Full 208885982  15-AUG-13 /oracle/MM1/sapdata1/saux_1/saux.data1
      10      Full 208885982  15-AUG-13 /oracle/MM1/sapdata1/sysaux_3/sysaux.data3

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27859   Full    13.05G     SBT_TAPE    00:03:48     15-AUG-13
            BP Key: 27859   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T122050
            Handle: 9kohbth2_1_1   Media: 8169830f:5208d804:64fa:00bd,8169830f:5208c83c:4f6a:001a
      List of Datafiles in backup set 27859
      File LV Type Ckp SCN    Ckp Time  Name
      ---- -- ---- ---------- --------- ----
      6       Full 208885979  15-AUG-13 /oracle/MM1/sapdata1/mob710_1/mob710.data1
      9       Full 208885979  15-AUG-13 /oracle/MM1/sapdata1/sysaux_2/sysaux.data2

     

    RMAN> list backup of archivelog time between "to_date('15-aug-2013 10:00','dd-mon-yyyy hh24:mi')" and "to_date('15-aug-2013 14:40','dd-mon-yyyy hh24:mi')";


    List of Backup Sets
    ===================


    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27862   43.75M     SBT_TAPE    00:00:40     15-AUG-13
            BP Key: 27862   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T122507
            Handle: 9rohbtp4_1_1   Media: 8169830f:5208c83c:4f6a:001a

      List of Archived Logs in backup set 27862
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12972   208880966  15-AUG-13 208884692  15-AUG-13
      1    12973   208884692  15-AUG-13 208886157  15-AUG-13
      1    12974   208886157  15-AUG-13 208886165  15-AUG-13

    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27863   81.50M     SBT_TAPE    00:02:17     15-AUG-13
            BP Key: 27863   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T122507
            Handle: 9qohbtp4_1_1   Media: 8169830f:5208c83c:4f6a:001a

      List of Archived Logs in backup set 27863
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12970   208877076  15-AUG-13 208880552  15-AUG-13
      1    12971   208880552  15-AUG-13 208880966  15-AUG-13

    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27872   256.00K    SBT_TAPE    00:05:23     15-AUG-13
            BP Key: 27872   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T123211
            Handle: a0ohbu6b_1_1   Media: 8169830f:5208c83c:4f6a:001a

      List of Archived Logs in backup set 27872
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12976   208886439  15-AUG-13 208886499  15-AUG-13

    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27873   256.00K    SBT_TAPE    00:05:23     15-AUG-13
            BP Key: 27873   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T123211
            Handle: 9vohbu6b_1_1   Media: 8169830f:5208c83c:4f6a:001a

      List of Archived Logs in backup set 27873
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12975   208886165  15-AUG-13 208886439  15-AUG-13

    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27915   7.50M      SBT_TAPE    00:00:15     15-AUG-13
            BP Key: 27915   Status: AVAILABLE  Compressed: YES  Tag: AELWIUCK
            Handle: MM1_aelwiuck.28016_1   Media: 8169830f:5208ce91:64fa:0052

      List of Archived Logs in backup set 27915
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12971   208880552  15-AUG-13 208880966  15-AUG-13

    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27916   8.50M      SBT_TAPE    00:00:15     15-AUG-13
            BP Key: 27916   Status: AVAILABLE  Compressed: YES  Tag: AELWIUCK
            Handle: MM1_aelwiuck.28015_1   Media: 8169830f:5208d370:64fa:0087

      List of Archived Logs in backup set 27916
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12970   208877076  15-AUG-13 208880552  15-AUG-13

    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27917   9.25M      SBT_TAPE    00:00:31     15-AUG-13
            BP Key: 27917   Status: AVAILABLE  Compressed: YES  Tag: AELWIUCK
            Handle: MM1_aelwiuck.28017_1   Media: 8169830f:5208d370:64fa:0087

      List of Archived Logs in backup set 27917
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12972   208880966  15-AUG-13 208884692  15-AUG-13

    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27918   3.75M      SBT_TAPE    00:00:31     15-AUG-13
            BP Key: 27918   Status: AVAILABLE  Compressed: YES  Tag: AELWIUCK
            Handle: MM1_aelwiuck.28018_1   Media: 8169830f:5208ce91:64fa:0052

      List of Archived Logs in backup set 27918
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12973   208884692  15-AUG-13 208886157  15-AUG-13

    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27919   256.00K    SBT_TAPE    00:00:13     15-AUG-13
            BP Key: 27919   Status: AVAILABLE  Compressed: YES  Tag: AELWIUCK
            Handle: MM1_aelwiuck.28019_1   Media: 8169830f:5208d370:64fa:0087

      List of Archived Logs in backup set 27919
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12974   208886157  15-AUG-13 208886165  15-AUG-13

    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27920   256.00K    SBT_TAPE    00:00:13     15-AUG-13
            BP Key: 27920   Status: AVAILABLE  Compressed: YES  Tag: AELWIUCK
            Handle: MM1_aelwiuck.28020_1   Media: 8169830f:5208ce91:64fa:0052

      List of Archived Logs in backup set 27920
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12975   208886165  15-AUG-13 208886439  15-AUG-13

    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    27921   256.00K    SBT_TAPE    00:00:20     15-AUG-13
            BP Key: 27921   Status: AVAILABLE  Compressed: YES  Tag: AELWIUCK
            Handle: MM1_aelwiuck.28021_1   Media: 8169830f:5208d370:64fa:0087

      List of Archived Logs in backup set 27921
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    12976   208886439  15-AUG-13 208886499  15-AUG-13

    RMAN>

  • 3. Re: DUPLICATE DATABASE FROM TAPE BACKUPS
    Javier Francisco Ruiz Explorer
    Currently Being Moderated

    In your list I do not see a control file backup do you have you control file auto backup. You error was stating that no control file backup was found.

  • 4. Re: DUPLICATE DATABASE FROM TAPE BACKUPS
    2f445178-c6b6-4865-b500-396039f41a2c Newbie
    Currently Being Moderated

    There are backups of the control file:

     

    RMAN> list backup of controlfile completed after "to_date('12-aug-2013','dd-mon-yyyy')";


    List of Backup Sets
    ===================


    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27623   Full    63.50M     SBT_TAPE    00:03:50     12-AUG-13
            BP Key: 27623   Status: AVAILABLE  Compressed: NO  Tag: TAG20130812T114133
            Handle: 29oh3u3d_1_1   Media: 1069830f:51d5cdaf:4245:0001
      Control File Included: Ckp SCN: 208502234    Ckp time: 12-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27646   Incr 1  63.75M     SBT_TAPE    00:00:13     12-AUG-13
            BP Key: 27646   Status: AVAILABLE  Compressed: NO  Tag: BELVVFHH
            Handle: MM1_belvvfhh.27745_1   Media: 8169830f:5208eed1:64fa:0139
      Control File Included: Ckp SCN: 208528129    Ckp time: 12-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27725   Incr 1  63.75M     SBT_TAPE    00:00:07     13-AUG-13
            BP Key: 27725   Status: AVAILABLE  Compressed: NO  Tag: BELWADCK
            Handle: MM1_belwadck.27824_1   Media: 8169830f:52090261:64fa:01e4
      Control File Included: Ckp SCN: 208653584    Ckp time: 13-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27776   Full    64.50M     SBT_TAPE    00:00:42     14-AUG-13
            BP Key: 27776   Status: AVAILABLE  Compressed: NO  Tag: TAG20130814T164033
            Handle: c-1713891644-20130814-00   Media: 8169830f:5208d359:64fa:0086
      Control File Included: Ckp SCN: 208773597    Ckp time: 14-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27779   Full    64.50M     SBT_TAPE    00:00:04     14-AUG-13
            BP Key: 27779   Status: AVAILABLE  Compressed: NO  Tag: TAG20130814T181802
            Handle: c-1713891644-20130814-01   Media: 8169830f:5208c858:64fa:0017
      Control File Included: Ckp SCN: 208780498    Ckp time: 14-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27781   Full    64.50M     SBT_TAPE    00:00:17     14-AUG-13
            BP Key: 27781   Status: AVAILABLE  Compressed: NO  Tag: TAG20130814T181833
            Handle: c-1713891644-20130814-02   Media: 8169830f:5208c858:64fa:0017
      Control File Included: Ckp SCN: 208780576    Ckp time: 14-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27812   Full    64.50M     SBT_TAPE    00:00:28     15-AUG-13
            BP Key: 27812   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T073541
            Handle: c-1713891644-20130815-00   Media: 8169830f:5208c82f:64fa:0015
      Control File Included: Ckp SCN: 208864345    Ckp time: 15-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27855   Full    64.50M     SBT_TAPE    00:00:17     15-AUG-13
            BP Key: 27855   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T074154
            Handle: c-1713891644-20130815-01   Media: 8169830f:5208c82f:64fa:0015
      Control File Included: Ckp SCN: 208864625    Ckp time: 15-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27860   Full    64.50M     SBT_TAPE    00:00:09     15-AUG-13
            BP Key: 27860   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T122446
            Handle: c-1713891644-20130815-02   Media: 8169830f:5208c83c:4f6a:001a
      Control File Included: Ckp SCN: 208886080    Ckp time: 15-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27864   Full    64.50M     SBT_TAPE    00:00:09     15-AUG-13
            BP Key: 27864   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T122733
            Handle: c-1713891644-20130815-03   Media: 8169830f:5208c83c:4f6a:001a
      Control File Included: Ckp SCN: 208886248    Ckp time: 15-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27874   Full    64.50M     SBT_TAPE    00:00:42     15-AUG-13
            BP Key: 27874   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T123736
            Handle: c-1713891644-20130815-04   Media: 8169830f:5208c83c:4f6a:001a
      Control File Included: Ckp SCN: 208886649    Ckp time: 15-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27910   Full    64.50M     SBT_TAPE    00:00:30     15-AUG-13
            BP Key: 27910   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T125320
            Handle: c-1713891644-20130815-05   Media: 8169830f:5208d370:64fa:0087
      Control File Included: Ckp SCN: 208887329    Ckp time: 15-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27922   Full    64.50M     SBT_TAPE    00:00:06     15-AUG-13
            BP Key: 27922   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T125700
            Handle: c-1713891644-20130815-06   Media: 8169830f:5208d370:64fa:0087
      Control File Included: Ckp SCN: 208889080    Ckp time: 15-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27925   Full    64.50M     SBT_TAPE    00:00:29     15-AUG-13
            BP Key: 27925   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T181835
            Handle: c-1713891644-20130815-07   Media: 8169830f:5208c6c6:4f6a:000e
      Control File Included: Ckp SCN: 208908552    Ckp time: 15-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27927   Full    64.50M     SBT_TAPE    00:00:05     15-AUG-13
            BP Key: 27927   Status: AVAILABLE  Compressed: NO  Tag: TAG20130815T182046
            Handle: c-1713891644-20130815-08   Media: 8169830f:5208c6c6:4f6a:000e
      Control File Included: Ckp SCN: 208908711    Ckp time: 15-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27939   Full    64.50M     SBT_TAPE    00:00:12     16-AUG-13
            BP Key: 27939   Status: AVAILABLE  Compressed: NO  Tag: TAG20130816T072811
            Handle: c-1713891644-20130816-00   Media: 8169830f:5208cc59:4f6a:003c
      Control File Included: Ckp SCN: 208992543    Ckp time: 16-AUG-13

    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    27970   Full    64.50M     SBT_TAPE    00:00:05     16-AUG-13
            BP Key: 27970   Status: AVAILABLE  Compressed: NO  Tag: TAG20130816T073317
            Handle: c-1713891644-20130816-01   Media: 8169830f:5208cc59:4f6a:003c
      Control File Included: Ckp SCN: 208992771    Ckp time: 16-AUG-13

    RMAN>

  • 5. Re: DUPLICATE DATABASE FROM TAPE BACKUPS
    2f445178-c6b6-4865-b500-396039f41a2c Newbie
    Currently Being Moderated

    I finally realised what was wrong with my approach. I had missed a bit in the documentation: the AUXILIARY channel definition must be the same as the one used for the backup. Of course, RMAN normally does not give you a clear clue in its mystic error messages.

     

    Also, according to the document, it is a good idea to create a SPFILE in the auxiliary instance. I did that.

     

    So, in my case, it should be the same tape channels as the ones used for the tape backups. So, the syntax I used successfully is:

     

    connect target /
    connect auxiliary sys/********@MBA

    run {
    allocate channel 'dev_01' type 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
    allocate channel 'dev_02' type 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
    allocate channel 'dev_03' type 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
    allocate channel 'dev_04' type 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
    ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=SAP,OB2APPNAME=MM1,OB2BARLIST=WYC_CENTRICA_wycvlsapx115_SAP_MM1_ON_Weekly),SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
    set until time "to_date('15-aug-2013:12:30:46','dd-mon-YYYY:hh24:mi:ss')";
    DUPLICATE TARGET DATABASE TO MBA NOFILENAMECHECK;
    release channel aux1;
    release channel 'dev_01';
    release channel 'dev_02';
    release channel 'dev_03';
    release channel 'dev_04';
    }

     

    To improve the timings, next time I may increase the number of auxiliary channels. I need to find out how many tape drives I have in my disposal.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points