This discussion is archived
1 2 Previous Next 19 Replies Latest reply: May 20, 2013 5:34 AM by 864103 RSS

controlfile repositoty

864103 Newbie
Currently Being Moderated
HI all ,

if my controlfile store the below information could be i restore to which seq?
also if i have rac and then i need to do a cloning in another server but with single nore which seq should be i restore ?
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3>  parms
4> 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=MEDI,OB2BARLIST=Mediation DB Whole Online - Archive Delete)';
5> restore database preview summary;
6> }

allocated channel: dev_0
channel dev_0: SID=37 device type=SBT_TAPE
channel dev_0: Data Protector A.06.11/243

Starting restore at 15-MAY-13


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
5050    B  0  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T030027

no backup of archived log for thread 1 with sequence 1312 and starting SCN of 9785043871 found to restore
no backup of archived log for thread 1 with sequence 1313 and starting SCN of 9785310775 found to restore
no backup of archived log for thread 2 with sequence 591 and starting SCN of 9785043850 found to restore
no backup of archived log for thread 2 with sequence 592 and starting SCN of 9785130246 found to restore
no backup of archived log for thread 2 with sequence 593 and starting SCN of 9785220640 found to restore
no backup of archived log for thread 2 with sequence 594 and starting SCN of 9785326555 found to restore

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
5051    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T040851
5054    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T130051
5055    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T130051
5056    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T130051
5057    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T130051
5058    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T130051
5059    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T130051
5060    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T130051
5062    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5063    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5064    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5065    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5066    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5067    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5068    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5069    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5070    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5071    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5072    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5073    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5074    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5075    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5076    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
5077    B  A  A SBT_TAPE    13-MAY-13       1       1       NO         TAG20130513T200456
List of Archived Log Copies for database with db_unique_name MEDI
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
50390   2    263     A 13-MAY-13
        Name: /u01/app/oracle/backup/MEDI/archivelog/2013_05_15/o1_mf_2_263_8s68n6rf_.arc

50817   2    370     A 13-MAY-13
        Name: /u01/app/oracle/backup/MEDI/archivelog/2013_05_15/o1_mf_2_370_8s6ghzwj_.arc

validation succeeded for backup piece
Media recovery start SCN is 9739157023
Recovery must be done beyond SCN 9739184111 to clear datafile fuzziness
validation succeeded for backup piece
Finished restore at 15-MAY-13
released channel: dev_0
please advise in both option this controlfile is from rac db and i restore it to cloning server single node
which seq should i restore to it ?

thanks
  • 1. Re: controlfile repositoty
    sybrand_b Guru
    Currently Being Moderated
    Obviously to restore a RAC database to a single instance database you'll need all nodes, as transactions are being performed by all nodes.

    ---------
    Sybrand Bakker
    Senior Oracle DBA
  • 2. Re: controlfile repositoty
    864103 Newbie
    Currently Being Moderated
    so i my list i should use 370
    set until sequence 370 thread 2
  • 3. Re: controlfile repositoty
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    The listing doesn't show that you have archivelogs (from both threads !) that you would need.

    Do you have archivelog backups ?


    Hemant K Chitale
  • 4. Re: controlfile repositoty
    864103 Newbie
    Currently Being Moderated
    Hi , yes i have backup of archivelog please check the below :
    list backup of archivelog all;
    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    5077    3.76G      SBT_TAPE    00:00:59     13-MAY-13
            BP Key: 5077   Status: AVAILABLE  Compressed: NO  Tag: TAG20130513T200456
            Handle: Mediation DB - Archive Logs 2HRS<MEDI_5236:815343981:1>.dbf   Media: c8c8c80a:4f84360a:1eac:0001
    
      List of Archived Logs in backup set 5077
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    1278    9780905228 13-MAY-13 9781026471 13-MAY-13
      1    1279    9781026471 13-MAY-13 9781324640 13-MAY-13
      1    1280    9781324640 13-MAY-13 9781610148 13-MAY-13
      1    1281    9781610148 13-MAY-13 9781915360 13-MAY-13
      1    1282    9781915360 13-MAY-13 9782586401 13-MAY-13
      1    1283    9782586401 13-MAY-13 9782825381 13-MAY-13
      1    1284    9782825381 13-MAY-13 9783046223 13-MAY-13
      1    1285    9783046223 13-MAY-13 9783119911 13-MAY-13
      1    1286    9783119911 13-MAY-13 9783205011 13-MAY-13
      1    1287    9783205011 13-MAY-13 9783291754 13-MAY-13
      1    1288    9783291754 13-MAY-13 9783366577 13-MAY-13
      1    1289    9783366577 13-MAY-13 9783436459 13-MAY-13
      1    1290    9783436459 13-MAY-13 9783505913 13-MAY-13
      1    1291    9783505913 13-MAY-13 9783573562 13-MAY-13
      1    1292    9783573562 13-MAY-13 9783640679 13-MAY-13
      1    1293    9783640679 13-MAY-13 9783705499 13-MAY-13
      1    1294    9783705499 13-MAY-13 9783771104 13-MAY-13
      1    1295    9783771104 13-MAY-13 9783838409 13-MAY-13
      1    1296    9783838409 13-MAY-13 9783905016 13-MAY-13
      1    1297    9783905016 13-MAY-13 9783983419 13-MAY-13
      1    1298    9783983419 13-MAY-13 9784069047 13-MAY-13
      1    1299    9784069047 13-MAY-13 9784143611 13-MAY-13
      1    1300    9784143611 13-MAY-13 9784223461 13-MAY-13
      1    1301    9784223461 13-MAY-13 9784294181 13-MAY-13
      1    1302    9784294181 13-MAY-13 9784374338 13-MAY-13
      1    1303    9784374338 13-MAY-13 9784442391 13-MAY-13
      1    1304    9784442391 13-MAY-13 9784514875 13-MAY-13
      1    1305    9784514875 13-MAY-13 9784598235 13-MAY-13
      1    1306    9784598235 13-MAY-13 9784663487 13-MAY-13
      1    1307    9784663487 13-MAY-13 9784745026 13-MAY-13
      1    1308    9784745026 13-MAY-13 9784816777 13-MAY-13
      1    1309    9784816777 13-MAY-13 9784886393 13-MAY-13
      1    1310    9784886393 13-MAY-13 9784985993 13-MAY-13
      1    1311    9784985993 13-MAY-13 9785043871 13-MAY-13
      2    565     9780793701 13-MAY-13 9781017455 13-MAY-13
      2    566     9781017455 13-MAY-13 9781135905 13-MAY-13
      2    567     9781135905 13-MAY-13 9781230523 13-MAY-13
      2    568     9781230523 13-MAY-13 9781320704 13-MAY-13
      2    569     9781320704 13-MAY-13 9781418964 13-MAY-13
      2    570     9781418964 13-MAY-13 9781516648 13-MAY-13
      2    571     9781516648 13-MAY-13 9781607674 13-MAY-13
      2    572     9781607674 13-MAY-13 9781715328 13-MAY-13
      2    573     9781715328 13-MAY-13 9781847449 13-MAY-13
      2    574     9781847449 13-MAY-13 9782338616 13-MAY-13
      2    575     9782338616 13-MAY-13 9782466374 13-MAY-13
      2    576     9782466374 13-MAY-13 9782584485 13-MAY-13
      2    577     9782584485 13-MAY-13 9782703418 13-MAY-13
      2    578     9782703418 13-MAY-13 9782844907 13-MAY-13
      2    579     9782844907 13-MAY-13 9782924895 13-MAY-13
      2    580     9782924895 13-MAY-13 9783042941 13-MAY-13
      2    581     9783042941 13-MAY-13 9783217223 13-MAY-13
      2    582     9783217223 13-MAY-13 9783441622 13-MAY-13
      2    583     9783441622 13-MAY-13 9783643254 13-MAY-13
      2    584     9783643254 13-MAY-13 9783841276 13-MAY-13
      2    585     9783841276 13-MAY-13 9784070499 13-MAY-13
      2    586     9784070499 13-MAY-13 9784302876 13-MAY-13
      2    587     9784302876 13-MAY-13 9784521349 13-MAY-13
      2    588     9784521349 13-MAY-13 9784749594 13-MAY-13
      2    589     9784749594 13-MAY-13 9784992458 13-MAY-13
      2    590     9784992458 13-MAY-13 9785043850 13-MAY-13
    
    RMAN>
    the above list is a last list of the archv backup ?
  • 5. Re: controlfile repositoty
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    The highest SCN you can recover to would be 9785043850 - 1

    Since you are using RAC with two threads, I would recommending using CHANGE# (instead of SEQUENCE#) as the Recovery Point


    Hemant K Chitale
  • 6. Re: controlfile repositoty
    864103 Newbie
    Currently Being Moderated
    HI , thanks man for your reply
    set until scn 9785043849 
    restore database;
    recover database;
    ?
  • 7. Re: controlfile repositoty
    864103 Newbie
    Currently Being Moderated
    HI please check with me
    run {
    allocate channel 'dev_0' type 'sbt_tape'
    parms 
    'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=MEDI,OB2BARLIST=Mediation DB Whole Online - Archive Delete)'
    ;
     set newname for datafile 1 to  '/u01/app/oracle/oradata/MEDI/system.dbf';
     set newname for datafile 3 to '/u01/app/oracle/oradata/MEDI/undotbs01.dbf';
     set newname for datafile 4 to '/u01/app/oracle/oradata/MEDI/undotbs02.dbf';
     set newname for datafile 2 to  '/u01/app/oracle/oradata/MEDI/sysaux01.dbf';
     set newname for datafile 5 to  '/u01/app/oracle/oradata/MEDI/users.dbf';
     set newname for datafile 6 to  '/u01/app/oracle/oradata/MEDI/abs_mid1.dbf';
     set newname for datafile 7 to '/u01/app/oracle/oradata/MEDI/abs_mid_ind1.dbf';
     set newname for datafile 8 to  '/u01/app/oracle/oradata/MEDI/abs_mid2.dbf';
     set newname for datafile 9 to  '/u01/app/oracle/oradata/MEDI/abs_mid_ind2';
     set newname for datafile 10 to '/u01/app/oracle/oradata/MEDI/abs_mid3.dbf';
     set newname for datafile 11 to '/u01/app/oracle/oradata/MEDI/abs_mid_ind3.dbf';
     set newname for datafile 12 to '/u01/app/oracle/oradata/MEDI/abs_mid4.dbf';
     set newname for datafile 13 to '/u01/app/oracle/oradata/MEDI/abs_mid5.dbf';
     set newname for datafile 14 to '/u01/app/oracle/oradata/MEDI/abs_mid6.dbf';
     set newname for datafile 15 to '/u01/app/oracle/oradata/MEDI/abs_mid7.dbf';
     set newname for datafile 16 to '/u01/app/oracle/oradata/MEDI/abs_mid8.dbf';
     set newname for datafile 17 to '/u01/app/oracle/oradata/MEDI/abs_mid9.dbf';
     set newname for datafile 18 to '/u01/app/oracle/oradata/MEDI/abs_mid10.dbf';
     set newname for datafile 19 to '/u01/app/oracle/oradata/MEDI/abs_mid11.dbf';
     set newname for datafile 20 to '/u01/app/oracle/oradata/MEDI/abs_mid12.dbf';
     set newname for datafile 21 to '/u01/app/oracle/oradata/MEDI/abs_mid13.dbf';
     set newname for datafile 22 to '/u01/app/oracle/oradata/MEDI/abs_mid14.dbf';
     set newname for datafile 23 to '/u01/app/oracle/oradata/MEDI/abs_mid15.dbf';
     set newname for datafile 24 to '/u01/app/oracle/oradata/MEDI/abs_mid16.dbf';
     set newname for datafile 25 to '/u01/app/oracle/oradata/MEDI/abs_mid17.dbf';
     set newname for datafile 26 to '/u01/app/oracle/oradata/MEDI/abs_mid18.dbf';
     set newname for datafile 27 to '/u01/app/oracle/oradata/MEDI/abs_mid19.dbf';
     set newname for datafile 28 to '/u01/app/oracle/oradata/MEDI/abs_mid20.dbf';
     set newname for datafile 29 to '/u01/app/oracle/oradata/MEDI/abs_mid21.dbf';
     set newname for datafile 30 to '/u01/app/oracle/oradata/MEDI/abs_mid22.dbf';
     set newname for datafile 31 to '/u01/app/oracle/oradata/MEDI/abs_mid23.dbf';
     set newname for datafile 32 to '/u01/app/oracle/oradata/MEDI/abs_mid24.dbf';
     set newname for datafile 33 to '/u01/app/oracle/oradata/MEDI/abs_mid25.dbf';
     set newname for datafile 34 to '/u01/app/oracle/oradata/MEDI/abs_mid26.dbf';
     set newname for datafile 35 to '/u01/app/oracle/oradata/MEDI/abs_mid27.dbf';
     set newname for datafile 36 to '/u01/app/oracle/oradata/MEDI/abs_mid28.dbf';
     set newname for datafile 37 to '/u01/app/oracle/oradata/MEDI/abs_mid29.dbf';
     set newname for datafile 38 to '/u01/app/oracle/oradata/MEDI/abs_mid30.dbf';
     set newname for datafile 39 to '/u01/app/oracle/oradata/MEDI/undotbs2011.dbf';
     set newname for datafile 40 to '/u01/app/oracle/oradata/MEDI/undotbs2012.dbf';
     set newname for datafile 41 to '/u01/app/oracle/oradata/MEDI/undotbs111.dbf';
     set newname for datafile 42 to '/u01/app/oracle/oradata/MEDI/undotbs112.dbf';
     set newname for datafile 43 to '/u01/app/oracle/oradata/MEDI/undotbs113.dbf';
     set newname for datafile 44 to '/u01/app/oracle/oradata/MEDI/abs_mid31.dbf';
     set newname for datafile 45 to '/u01/app/oracle/oradata/MEDI/abs_mid32.dbf';
     set newname for datafile 46 to '/u01/app/oracle/oradata/MEDI/abs_mid33.dbf';
     set newname for datafile 47 to '/u01/app/oracle/oradata/MEDI/undotbs20121.dbf';
     set newname for datafile 48 to '/u01/app/oracle/oradata/MEDI/abs_mid34.dbf';
     set newname for datafile 49 to '/u01/app/oracle/oradata/MEDI/abs_mid35.dbf';
     set newname for datafile 50 to '/u01/app/oracle/oradata/MEDI/abs_mid36.dbf';
     set newname for datafile 51 to '/u01/app/oracle/oradata/MEDI/abs_mid37.dbf';
     set newname for datafile 52 to '/u01/app/oracle/oradata/MEDI/abs_mid38.dbf';
     set newname for datafile 53 to '/u01/app/oracle/oradata/MEDI/abs_mid39.dbf';
     set newname for datafile 54 to '/u01/app/oracle/oradata/MEDI/abs_mid40.dbf';
     set until scn 9785043849;
     RESTORE DATABASE;      
     SWITCH DATAFILE ALL;       
     Recover database;        
    }
    and i get the below error
    channel dev_0: reading from backup piece Mediation DB - Archive Logs 2HRS<MEDI_5217:815318138:1>.dbf
    channel dev_0: ORA-19870: error while restoring backup piece Mediation DB - Archive Logs 2HRS<MEDI_5217:815318138:1>.dbf
    ORA-19507: failed to retrieve sequential file, handle="Mediation DB - Archive Logs 2HRS<MEDI_5217:815318138:1>.dbf", parms=""
    ORA-27029: skgfrtrv: sbtrestore returned error
    ORA-19511: Error received from media manager layer, error text:
       Vendor specific error: OB2_StartObjectRestoreFullName() failed ERR(-2
    failover to previous backup
    released channel: dev_0
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 05/16/2013 08:59:39
    RMAN-20506: no backup of archived log found
    RMAN-06053: unable to perform media recovery because of missing log
    RMAN-06025: no backup of archived log for thread 1 with sequence 504 and starting SCN of 9755631314 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 503 and starting SCN of 9755613699 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 294 and starting SCN of 9755610075 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 502 and starting SCN of 9755595370 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 501 and starting SCN of 9755576438 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 500 and starting SCN of 9755554482 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 293 and starting SCN of 9755547048 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 499 and starting SCN of 9755535210 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 498 and starting SCN of 9755516906 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 497 and starting SCN of 9755498381 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 292 and starting SCN of 9755491214 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 496 and starting SCN of 9755479553 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 495 and starting SCN of 9755459805 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 494 and starting SCN of 9755440420 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 291 and starting SCN of 9755440399 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 493 and starting SCN of 9755420471 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 492 and starting SCN of 9755398167 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 491 and starting SCN of 9755378754 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 290 and starting SCN of 9755375636 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 490 and starting SCN of 9755359969 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 489 and starting SCN of 9755342026 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 488 and starting SCN of 9755323828 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 289 and starting SCN of 9755319417 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 487 and starting SCN of 9755305738 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 486 and starting SCN of 9755287387 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 485 and starting SCN of 9755269134 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 288 and starting SCN of 9755265497 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 484 and starting SCN of 9755247361 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 483 and starting SCN of 9755230105 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 482 and starting SCN of 9755211983 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 287 and starting SCN of 9755197877 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 481 and starting SCN of 9755188163 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 480 and starting SCN of 9755167192 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 479 and starting SCN of 9755144886 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 286 and starting SCN of 9755124904 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 478 and starting SCN of 9755117933 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 477 and starting SCN of 9755096304 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 476 and starting SCN of 9755077533 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 285 and starting SCN of 9755073479 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 475 and starting SCN of 9755058155 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 474 and starting SCN of 9755035544 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 473 and starting SCN of 9755018152 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 284 and starting SCN of 9755004585 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 472 and starting SCN of 9754997355 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 471 and starting SCN of 9754977698 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 470 and starting SCN of 9754959913 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 283 and starting SCN of 9754951053 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 469 and starting SCN of 9754941482 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 468 and starting SCN of 9754923167 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 467 and starting SCN of 9754903391 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 282 and starting SCN of 9754893996 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 466 and starting SCN of 9754882577 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 465 and starting SCN of 9754865231 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 464 and starting SCN of 9754847945 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 281 and starting SCN of 9754835920 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 463 and starting SCN of 9754828879 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 462 and starting SCN of 9754810320 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 461 and starting SCN of 9754793102 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 280 and starting SCN of 9754782320 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 460 and starting SCN of 9754769586 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 459 and starting SCN of 9754749783 found to restore
    RMAN-06025: no backup of archived log for thread 1 with sequence 458 and starting SCN of 9754731520 found to restore
    RMAN-06025: no backup of archived log for thread 2 with sequence 279 and starting SCN of 9754718944 found to restore
    
    RMAN>
  • 8. Re: controlfile repositoty
    swapnil kambli Journeyer
    Currently Being Moderated
    861100 wrote:
    run {
    allocate channel 'dev_0' type 'sbt_tape'
    parms
    'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=MEDI,OB2BARLIST=Mediation DB Whole Online - Archive Delete)'
    ;

    channel dev_0: reading from backup piece Mediation DB - Archive Logs 2HRS<MEDI_5217:815318138:1>.dbf
    channel dev_0: ORA-19870: error while restoring backup piece Mediation DB - Archive Logs 2HRS<MEDI_5217:815318138:1>.dbf
    ORA-19507: failed to retrieve sequential file, handle="Mediation DB - Archive Logs 2HRS<MEDI_5217:815318138:1>.dbf", parms=""
    ORA-27029: skgfrtrv: sbtrestore returned error
    ORA-19511: Error received from media manager layer, error text:
    Vendor specific error: OB2_StartObjectRestoreFullName() failed ERR(-2
    failover to previous backup
    Call up team that maintains the tape library anng give them above error also check the channel allocation string you used is correct?
  • 9. Re: controlfile repositoty
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    The tape library says that the backup piece is not accessible

    ORA-19507: failed to retrieve sequential file, handle="Mediation DB - Archive Logs 2HRS<MEDI_5217:815318138:1>.dbf", parms=""
    ORA-27029: skgfrtrv: sbtrestore returned error
    ORA-19511: Error received from media manager layer, error text:
    Vendor specific error: OB2_StartObjectRestoreFullName() failed ERR(-2


    Has the backup piece been obsoleted and purged by the tape library ?

    This is not an Oracle error. Check with your tape library administrator.


    Hemant K Chitale
  • 10. Re: controlfile repositoty
    864103 Newbie
    Currently Being Moderated
    Hi ,
    Has the backup piece been obsoleted and purged by the tape library ? no it's normal
    but the i can restore the backup and it get successful why when i do a recovery it get failed ?
    please help me i always do this cloning but today i tested on tape drive , and before 2 day i do a full restore
    on production server ?so the tape is ok and also the channel ?please advise
  • 11. Re: controlfile repositoty
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Isn't the error message explicit enough :
    ORA-19511: Error received from media manager layer, error text:
    Vendor specific error: OB2_StartObjectRestoreFullName() failed ERR(-2
    I cannot help you. Oracle is unable to get the files from the tape library.



    Hemant K Chitale
  • 12. Re: controlfile repositoty
    864103 Newbie
    Currently Being Moderated
    i know you're right but before 1 week i do full restore and now i do a restore and i done ,
    so just the issue with recovery? can you please guide me okay i just need to test the backup it's restore-able or not ,
    so how can i do a restore without recover ?until cancel?
  • 13. Re: controlfile repositoty
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    You have tested the RESTORE.

    However, the RECOVER is failing --- and you need to be able to RECOVER else the RESTORE is utterly useless.



    Hemant K Chitale
  • 14. Re: controlfile repositoty
    864103 Newbie
    Currently Being Moderated
    yes the restore is done , but the recover not yet? show me error
1 2 Previous Next

Legend

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