1 Reply Latest reply on Feb 22, 2013 1:40 PM by Tony Garabedian

    RMAN Duplicate

      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 - 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