Hi all,
I was performing restore tests in my Oracle 9i server. With RMAN, I backup a tablespace 'EXAMPLE' in the file 'example.bak'. Then I dropped the table 'jobs', off user 'hr', in tablespace 'EXAMPLE'. After that I restored the tablespace 'EXAMPLE', but the table was not restored, and the restore script did not returned any error. There goes the backup and restore script:
# backup script
Run {
allocate channel canaldefault device type disk format'd:\EXAMPLE.bak';
backup (tablespace 'EXAMPLE'); }

#restore script
SQL "ALTER TABLESPACE EXAMPLE OFFLINE for restore";
run {
allocate channel canaldefault device type disk format'd:\EXAMPLE.bak';
restore (Tablespace 'EXAMPLE');
recover tablespace 'EXAMPLE';}
SQL "ALTER TABLESPACE EXAMPLE ONLINE";

Is there something wrong with my script? How can I make a 'restorable' backup?

Since now thanks, Pvaliati.