Re: Backup and restore the tablespace

Er, I think you are getting a bit confused over what 'recover' actually means. It doesn't mean 'put my database back to a prior state'. It means, 'put my bad database back into it's last know good state', which is what you got. You deleted 100 records. Period. When you 'recovered', that's what you got: Your 'good' database with the transaction that deleted 100 complete - not your 'good' database minus one of it's successful transactions.

Read the Oracle Concepts Manual and DBA Guides.

MotoX.

Collin Leung wrote in message <6ns3fk$j2l_at_is1.vtc.edu.hk>...
>I have created a single field table "table_01" with 13000 records on a
>tablespace name test01. And I backup the tablespace test01 though recover
>manger on following script (The database in NOARCHIVELOG mode).
>
>run {
>allocate channel dev1 type disk;
>sql "alter tablespace test01 offline";
>backup tablespace test01 format '/home/collin/backup_%d_%t');
>sql "alter tablespace test01 online";
>release channel dev1;
>}
>
>Then I delete 100 records on table table_01. I tried to restore the
>tablespace test01 with the following script.
>
>run {
>allocate channel dev1 type disk;
>sql "alter tablespace test01 offline";
>restore tablespace test01;
>recover tablespace test01;
>sql "alter tablespace test01 online";
>release channel dev1;
>}
>
>I except there are 13000 records on table table_01, in fact it has 12900
>records. Please give me to check do I make any mistakes and give me some
>best way to backup and recover the tablespace.
>
>
>
Received on Tue Jul 07 1998 - 04:23:47 CDT