4 Replies Latest reply on Feb 20, 2011 11:32 AM by Karan

    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error be

    ora_tech-2063898
      Hi,

      I am trying rman duplicate from RAC to NON-RAC and getting below error. Restore is successfull, but while recover i am getting below issue.

      I referred tech note RMAN-06102 DURING DUPLICATE OR RESTORE [ID 436637.1]

      I have tried until cancel using controlfile;

      To Implement solution " I restored controlfie from the backup peice of contrll file" , Any pointers appreciated.
      contents of Memory Script:
      {
         set until scn  5968419799614;
         recover
         clone database
          delete archivelog
         ;
      }
      executing Memory Script
      
      executing command: SET until clause
      
      Starting recover at 19-FEB-11
      
      starting media recovery
      
      Oracle Error:
      ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
      ORA-01194: file 1 needs more recovery to be consistent
      ORA-01110: data file 1: '/u01/oracle/PROD/db/clonedata/system01.dbf'
      
      released channel: ch1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 02/19/2011 14:39:27
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-06053: unable to perform media recovery because of missing log
      RMAN-06025: no backup of log thread 2 seq 184399 lowscn 5968419794646 found to restore
      RMAN-06025: no backup of log thread 2 seq 184398 lowscn 5968419759510 found to restore
      RMAN-06025: no backup of log thread 2 seq 184397 lowscn 5968419736368 found to restore
      RMAN-06025: no backup of log thread 2 seq 184396 lowscn 5968419726043 found to restore
      RMAN-06025: no backup of log thread 2 seq 184395 lowscn 5968419705565 found to restore
      RMAN-06025: no backup of log thread 2 seq 184394 lowscn 5968419678283 found to restore
      RMAN-06025: no backup of log thread 2 seq 184393 lowscn 5968419665940 found to restore
      RMAN-06025: no backup of log thread 2 seq 184392 lowscn 5968419647797 found to restore
      RMAN-06025: no backup of log thread 2 seq 184391 lowscn 5968419630414 found to restore
      RMAN-06025: no backup of log thread 2 seq 184390 lowscn 5968419626580 found to restore
      RMAN-06025: no backup of log thread 2 seq 184389 lowscn 5968419593858 found to restore
      RMAN-06025: no backup of log thread 2 seq 184388 lowscn 5968419527543 found to restore
      RMAN-06025: no backup of log thread 2 seq 184387 lowscn 5968419501163 found to restore
      RMAN-06025: no backup of log thread 2 seq 184386 lowscn 5968419485951 found to restore
      RMAN-06025: no backup of log thread 2 seq 184385 lowscn 5968419469937 found to restore
      RMAN-06025: no backup of log thread 2 seq 184384 lowscn 5968419440393 found to restore
      RMAN-06025: no backup of log thread 2 seq 184383 lowscn 5968419422292 found to restore
      RMAN-06025: no backup of log thread 2 seq 184382 lowscn 5968419397028 found to restore
      RMAN-06025: no backup of log thread 2 seq 184381 lowscn 5968419366574 found to restore
      RMAN-06025: no backup of log thread 2 seq 184380 lowscn 5968419352992 found to restore
      RMAN-06025: no backup of log thread 2 seq 184379 lowscn 5968419338522 found to restore
      RMAN-06025: no backup of log thread 2 seq 184378 lowscn 5968419326774 found to restore
      RMAN-06025: no backup of log thread 2 seq 184377 lowscn 5968419313956 found to restore
      RMAN-06025: no backup of log thread 2 seq 184376 lowscn 5968419300847 found to restore
      RMAN-06025: no backup of log thread 2 seq 184375 lowscn 5968419282136 found to restore
      RMAN-06025: no backup of log thread 2 seq 184374 lowscn 5968419265656 found to restore
      RMAN-06025: no backup of log thread 2 seq 184373 lowscn 5968419254578 found to restore
      RMAN-06025: no backup of log thread 2 seq 184372 lowscn 5968419229337 found to restore
      RMAN-06025: no backup of log thread 2 seq 184371 lowscn 5968419218373 found to restore
      RMAN-06025: no backup of log thread 2 seq 184370 lowscn 5968419178539 found to restore
      RMAN-06025: no backup of log thread 2 seq 184369 lowscn 5968419167027 found to restore
      RMAN-06025: no backup of log thread 2 seq 184368 lowscn 5968419143802 found to restore
      RMAN-06025: no backup of log thread 2 seq 184367 lowscn 5968419139461 found to restore
      RMAN-06025: no backup of log thread 2 seq 184366 lowscn 5968419133683 found to restore
      RMAN-06025: no backup of log thread 2 seq 184365 lowscn 5968419099514 found to restore
      RMAN-06025: no backup of log thread 2 seq 184364 lowscn 5968419094146 found to restore
      RMAN-06025: no backup of log thread 2 seq 184363 lowscn 5968419072193 found to restore
      RMAN-06025: no backup of log thread 2 seq 184362 lowscn 5968419055733 found to restore
      RMAN-06025: no backup of log thread 2 seq 184361 lowscn 5968419047459 found to restore
      RMAN-06025: no backup of log thread 2 seq 184360 lowscn 5968419005913 found to restore
      RMAN-06025: no backup of log thread 2 seq 184359 lowscn 5968419001578 found to restore
      RMAN-06025: no backup of log thread 2 seq 184358 lowscn 5968418983975 found to restore
      RMAN-06025: no backup of log thread 2 seq 184357 lowscn 5968418950115 found to restore
      RMAN-06025: no backup of log thread 2 seq 184356 lowscn 5968418945661 found to restore
      RMAN-06025: no backup of log thread 2 seq 184355 lowscn 5968418909994 found to restore
      RMAN-06025: no backup of log thread 2 seq 184354 lowscn 5968418891366 found to restore
      RMAN-06025: no backup of log thread 2 seq 184353 lowscn 5968418884733 found to restore
      RMAN-06025: no backup of log thread 1 seq 217710 lowscn 5968419793223 found to restore
      RMAN-06025: no backup of log thread 1 seq 217709 lowscn 5968419779424 found to restore
      RMAN-06025: no backup of log thread 1 seq 217708 lowscn 5968419776035 found to restore
      RMAN-06025: no backup of log thread 1 seq 217707 lowscn 5968419775408 found to restore
      RMAN-06025: no backup of log thread 1 seq 217706 lowscn 5968419774817 found to restore
      MAN-06025: no backup of log thread 1 seq 217705 lowscn 5968419758
      RMAN>
      thanks in advance.