1 Reply Latest reply: Feb 22, 2013 7:40 AM by Tony Garabedian RSS

    RMAN Duplicate

    902332
      Hi all,

      i am trying to clone the database using rman with in the same server having 11gr2 version.

      i am using no catalog mode.

      source instance haing 400mb and large_pool_size is 100mb target is also same.

      but it is staying at memory script execution only. not moving further.

      [oracle@localhost ~]$ rman auxiliary /

      Recovery Manager: Release 11.2.0.1.0 - Production on Fri Feb 22 17:59:52 2013

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

      connected to auxiliary database: ORCL (not mounted)

      RMAN> connect target sys/oracle@orcl

      connected to target database: ORCL (DBID=1314445644)

      RMAN> duplicate target database to 'prod' nofilenamecheck;

      Starting Duplicate Db at 22-FEB-13
      using target database control file instead of recovery catalog
      allocated channel: ORA_AUX_DISK_1
      channel ORA_AUX_DISK_1: SID=10 device type=DISK

      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



      please suggest to fix this.

      thank you