3 Replies Latest reply: Nov 22, 2012 8:54 AM by ggiulian RSS

    recovery until time, I don't understand where is my error....

    ggiulian
      Hi All,

      sorry but I don't understand....

      I need to restore one full backup for recover until time at 18-nov of all database on a second server

      I'v a new server with the same oracle version and the same directory structure of the primary server. Oracle is 11.2.0.2.

      I've daily full backup, and in a zffsa storage I've all copy of last 3 day of backup; The second server access to the samce zfssa storage.

      With list backup I can see backup about 18 november and I can see backup about 19 november.

      How I can select backup about 18 november and restore only this?

      I've the same AMS structure, too.

      Can i restore all db and recover until time?

      Edited by: ggiulian on 19-nov-2012 16.03
        • 1. Re: recovery until time, I don't understand where is my error....
          ggiulian
          For example,

          in the second server, i start in nomount a duplicate instance, restore controlfile from backup, and startup mount.

          After, i connect to rman target / auxiliary /
          and run:

          run {
          allocate channel C1 device type disk;
          allocate auxiliary channel C2 device type disk;
          set until time "to_date('18-nov-2012 13:00:00','dd-mon-rrrr hh24:mi:ss')";
          restore database;
          recover database;
          }

          I receive
          RMAN-03002: failure of restore command at 11/20/2012 01:44:21
          RMAN-06026: some targets not found - aborting restore
          RMAN-06023: no backup or copy of datafile 16 found to restore
          RMAN-06023: no backup or copy of datafile 15 found to restore
          RMAN-06023: no backup or copy of datafile 14 found to restore
          RMAN-06023: no backup or copy of datafile 13 found to restore
          RMAN-06023: no backup or copy of datafile 12 found to restore
          RMAN-06023: no backup or copy of datafile 11 found to restore
          RMAN-06023: no backup or copy of datafile 10 found to restore
          RMAN-06023: no backup or copy of datafile 9 found to restore
          RMAN-06023: no backup or copy of datafile 8 found to restore
          RMAN-06023: no backup or copy of datafile 7 found to restore
          RMAN-06023: no backup or copy of datafile 6 found to restore
          • 2. Re: recovery until time, I don't understand where is my error....
            mseberg
            Hello;

            You need to restore the control file first in NOMOUNT :
            CONNECT TARGET /
            STARTUP NOMOUNT;
            
            run {
            allocate channel C1 device type disk;
            allocate auxiliary channel C2 device type disk;
            RESTORE CONTROLFILE FROM '/<yourlocation>'
            ALTER DATABASE MOUNT;
            
            
            set until time "to_date('18-nov-2012 13:00:00','dd-mon-rrrr hh24:mi:ss')";
            restore database;
            recover database;
            }
            Going offline as Da Bears are playing...

            Detailed example here :

            Using RMAN to restore a database to another server in an ASM environment

            http://johnpjeffries.wordpress.com/2009/12/07/using-rman-to-restore-a-database-to-another-server-in-an-asm-environment/


            Best Regards

            mseberg