Rman Restore

[pvaliati]

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.

[SANJAY_G]

#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";

You are doing a complete recovery. Do a PIT recovery.

[pvaliati]

OK...Could you explain what PIT recovery is? Do you have any example?
Thanks. Pvaliati

[SANJAY_G]

Point-in-time recovery.
Read this..
http://download-west.oracle.com/docs...spi.htm#443831