Re: Recovery Manager (RMAN) problem
Date: Tue, 3 Jun 2008 08:12:44 -0700 (PDT)
Message-ID: <0b50cc6c-421d-45bd-af6a-45fd03df6e9f@59g2000hsb.googlegroups.com>
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