4 Replies Latest reply: Jan 8, 2013 6:21 AM by SurinderSingh RSS

    RMAN recovery taking long time

    user2015671
      Hi,

      When i am taking RMAN backup it takes 2 hours to complete it.
      But when i am recovering full database then that time it takes 14 hours to do complete recovery.

      I am performing ASM recovery with below script.

      $ORACLE_HOME/bin/rman <<EOF > $DTTMP/rman_recovery.out
      connect target "sys/sys as sysdba"
      STARTUP FORCE MOUNT;
      RESTORE DATABASE;
      RECOVER DATABASE;
      ALTER DATABASE OPEN;
      exit;
      EOF


      Why it is taking so long time?
      Is there any tuning parameter which is available?

      Thanks,