Re: Recovery Manager (RMAN) problem

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 Received on Tue Jun 03 2008 - 10:12:44 CDT