This discussion is archived
3 Replies Latest reply: Nov 22, 2012 6:54 AM by ggiulian RSS

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

ggiulian Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points