Re: Recovery Manager (RMAN) problem

From: gazzag <gareth_at_jamms.org>
Date: Tue, 3 Jun 2008 08:21:22 -0700 (PDT)
Message-ID: <e791187f-2a75-407a-ba2a-201b6df6da6c@c65g2000hsa.googlegroups.com>


On 3 Jun, 16:12, sati_82 <krys_..._at_interia.pl> wrote:
> On 3 Cze, 16:24, sati_82 <krys_..._at_interia.pl> wrote:
>
> Below is a sequel to my previous post:
>
> > ...
> > First: RMAN> run {
> > 2> allocate channel d1 type disk;
> > 3> backup tablespace USERS_CUSTOM format '/home/oracle/rman_002.bus'
> > 4> database;
> > 5> }
>
> Then I do some changes in a table (the table is stored on USERS_CUSTOM
> tablespace)
> After that I introduce the following:
>
> RMAN> SQL 'ALTER TABLESPACE USERS_CUSTOM OFFLINE';
> RMAN> RESTORE TABLESPACE USERS_CUSTOM ;
> RMAN> RECOVER TABLESPACE USERS_CUSTOM ;
> RMAN> SQL 'ALTER TABLESPACE USERS_CUSTOM ONLINE';
>
> RMAN restores
> And as I said the result doesn't satisfy me. After executing all
> commands above RMAN restores tablespace
> USERS_CUSTOM from file rman_002.bus but database stores
> all changes made AFTER I backup it to file rman_002.bus. I supposed
> that those changes will not be
> seen after I restore tablespace USERS_CUSTOM
>
> RMAN throws no error after executing all commands. From this point of
> view everything seems to be fine.
>
> Regards,
> Krystian

As Sybrand said, you are performing COMPLETE recovery. You need to perform INCOMPLETE recovery:

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc2002.htm#sthref411

HTH -g Received on Tue Jun 03 2008 - 10:21:22 CDT

Original text of this message