1 Reply Latest reply: Sep 9, 2013 9:01 AM by DK2010 RSS

    Unusual RMAN RESTORE behavior 11.1 standard edition.

    rafolabi

      Doing an 11.1 standard edition restore of a database from source A to Source B (2 different windows servers). Backup is an old backup and RMAN just seats there and nothing comes back with errors. I don't believe its doing anything. Alert log shows a lot of "ORA-12751: cpu time or run time policy violation" and a tracefile has a lot of indication that the source was an ASM file system(this should be ok as it doesnt change the conversion till the end of my script where i tell it to "switch datafile all" (My script is also below). Not sure what the issue is. Find the behavior very weird.Thanks.

       

       

      Hot Backup end marker scn: 0x0000.00000000

      aux_file is NOT DEFINED

      Plugged readony: NO

      Plugin scnscn: 0x0000.00000000

      Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

      Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

      Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00

      DDE rules only execution for: ORA 1110

      ----- START Event Driven Actions Dump ----

      ---- END Event Driven Actions Dump ----

      ----- START DDE Actions Dump -----

      Executing SYNC actions

      Executing ASYNC actions

      ----- END DDE Actions Dump (total 0 csec) -----

       

       

      *** 2013-09-09 07:58:13.921

      WARNING: Failed to start ASM background process (ASMB)

       

       

      *** 2013-09-09 07:58:20.906

      WARNING: Failed to start ASM background process (ASMB)

      DATA FILE #40:

        (name #49) +DATA/jDIR_NAME/datafile/cvdtat.303.686779457

      creation size=128000 block size=8192 status=0xe head=49 tail=49 dup=1

      tablespace 40, index=41 krfil=40 prev_file=0

      unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00

      Checkpoint cnt:9108 scn: 0x0002.7f538e2a 08/25/2013 04:50:52

      Stop scn: 0xffff.ffffffff 08/11/2013 14:19:07

      Creation Checkpointed at scn:  0x0000.015cc44a 05/13/2009 20:04:23

      thread:1 rba:(0x6b.24144.10)

       

      My RECO SCRIPT and output:

       

      run {

      ALLOCATE CHANNEL C1 DEVICE TYPE DISK;

      ALLOCATE CHANNEL C2 DEVICE TYPE DISK;

      ALLOCATE CHANNEL C3 DEVICE TYPE DISK;

      ALLOCATE CHANNEL C4 DEVICE TYPE DISK;

      ALLOCATE CHANNEL C5 DEVICE TYPE DISK;

      set newname for datafile 1 to 'E:\DATA\DIR_NAME\datafile\system.dbf';                                                                                                                         

      set newname for datafile 2 to 'E:\DATA\DIR_NAME\datafile\sysaux.dbf';                                                                                                                         

      set newname for datafile 3 to 'E:\DATA\DIR_NAME\datafile\undotbs1.dbf';                                                                                                                       

      set newname for datafile 4 to 'E:\DATA\DIR_NAME\datafile\users_01.dbf';                                                                                                                          

      set newname for datafile 5 to 'E:\DATA\DIR_NAME\datafile\undotbs2.dbf';  

      ******

      ****

      *****

      set until sequence 9360;

      RESTORE DATABASE;

      SWITCH DATAFILE ALL;

      RECOVER DATABASE;

      }

       

       

       

      executing command: SET NEWNAME

       

       

      executing command: SET NEWNAME

       

       

      executing command: SET NEWNAME

       

       

      executing command: SET NEWNAME

       

       

      executing command: SET NEWNAME

       

       

      executing command: SET NEWNAME

       

       

      executing command: SET until clause

       

       

      Starting restore at 07-SEP-13

       

       

      datafile 6 not processed because file is offline

      datafile 10 not processed because file is offline

      datafile 14 not processed because file is offline

      datafile 18 not processed because file is offline

      datafile 22 not processed because file is offline

      datafile 26 not processed because file is offline

      datafile 32 not processed because file is offline

      datafile 33 not processed because file is offline

      datafile 34 not processed because file is offline

      datafile 35 not processed because file is offline

      datafile 36 not processed because file is offline

      datafile 37 not processed because file is offline