Backup and restore the tablespace

From: Collin Leung <collinl_at_vtc.edu.hk>
Date: Tue, 7 Jul 1998 11:08:06 +0800
Message-ID: <6ns3fk$j2l@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 Mon Jul 06 1998 - 22:08:06 CDT