2 Replies Latest reply on Oct 10, 2013 6:51 AM by jnrjian

    Creating Standby From RMAN Compressed backup taken on Primary ....

      I am creating a Standby from RMAN Compressed backup taken on Primary.

      On Primary, I have taken Compressed backup as follows:
      RMAN> run
      allocate channel c1 type disk;
      allocate channel c2 type disk;
      allocate channel c3 type disk;
      BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG format '/dboracle/orbit_pr_bkp/primary_%U';

      backup current controlfile for standby format '/dboracle/orbit_pr_bkp/primary_cntl.bkp';

      oracle@apl06635orbvu1:/dboracle/orbit_pr_bkp>ls -ltr
      total 51652
      -rw-r----- 1 oracle dba 11972608 Jan 7 13:45 primary_0tm1h32n_1_1
      -rw-r----- 1 oracle dba 15762432 Jan 7 13:45 primary_0sm1h32n_1_1
      -rw-r----- 1 oracle dba 16785920 Jan 7 13:45 primary_0rm1h32n_1_1
      -rw-r----- 1 oracle dba 1088000 Jan 7 13:45 primary_0um1h32v_1_1
      -rw-r----- 1 oracle dba 32768 Jan 7 13:45 primary_12m1h33r_1_1
      -rw-r----- 1 oracle dba 7143424 Jan 7 13:47 primary_cntl.bkp

      On Standby, I restored the control file as below:

      RMAN> restore standby controlfile from '/dboracle/orbit_pr_bkp/primary_cntl.bkp';

      Starting restore at 10-JAN-11
      using target database control file instead of recovery catalog
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=156 devtype=DISK

      channel ORA_DISK_1: restoring control file
      channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
      output filename=/dboracle/orbit_dr/oradata/ORBIT_DR/controlfile/o1_mf_6lo6nwfr_.ctl
      output filename=/dboracle/orbit_dr/flash_recovery_area/ORBIT_DR/controlfile/o1_mf_6lo6nwky_.ctl
      Finished restore at 10-JAN-11

      But, When I am trying to restore the datafiles, RMAN is throwing error:

      RMAN> run {
      allocate channel d1 type disk format '/dboracle/orbit_pr_bkp/primary_%U';
      allocate channel d2 type disk format '/dboracle/orbit_pr_bkp/primary_%U';
      restore database;
      2> 3> 4> 5>
      released channel: ORA_DISK_1
      allocated channel: d1
      channel d1: sid=155 devtype=DISK

      allocated channel: d2
      channel d2: sid=151 devtype=DISK

      Starting restore at 10-JAN-11

      released channel: d1
      released channel: d2
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 01/10/2011 05:38:56
      RMAN-06026: some targets not found - aborting restore
      RMAN-06023: no backup or copy of datafile 4 found to restore
      RMAN-06023: no backup or copy of datafile 3 found to restore
      RMAN-06023: no backup or copy of datafile 2 found to restore
      RMAN-06023: no backup or copy of datafile 1 found to restore

      What would be the correct RMAN command?

      Regards, Anirban