NBU RMAN restore from backup can specific to only one tablespace?

[liew_yew_hwa]

I use NBU RMAN backup script to backup the oracle database 11gR1. Just want to confirm that if i dropped one tablespace in the database, can i just restore the dropped tablespace without restore the whole database and affecting other tablespace data?

The command i use to recover the database is like this:

RMAN> run

{

allocate channel ch00 type 'SBT_TAPE';

Set until time "to_date('2015-10-23 10:55:00','yyyy-mm-dd hh24:mi:ss')";

restore database;

recover database;

}

[Marianne]

Have a look at this Oracle blog: http://gavinsoorma.com/2009/08/rman-recovering-a-dropped-tablespace/

[Nicolai]

Yes you can. With RMAN you can even restore tabelspace records.

But you should consult documentation first - RMAN is like a axe. A very effective tool. It can cut down the trees, but it can also hurt your legs using it.

See 6.4.3 and forward :

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/recov004.htm