tablespace restoration

pavand · #1 (**permalink**) 08-17-09, 22:47

Hi...

I have a doubt about tablespace restoration..

Is it possible to restore only tablespace from database backup image.

if so what are the steps we need to follow..?

Please clarify my dbout my friends..!

Thanks in advance..
Pavan

divakargoel · #2 (**permalink**) 08-18-09, 02:20

Yes its possible to restore a tablespace from a full db backup. You would also need the log files associated with the tablespace from the time the backup image was created.
A tablespace is always rollforwarded after recovery.

pavand · #3 (**permalink**) 08-19-09, 00:31

Thank you Divakar...for information

May I know the command to restore the tablespace from the backup image which has log files associated with the tablespace.

divakargoel · #4 (**permalink**) 08-20-09, 05:11

The command remains the same 'RESTORE DATABASE'. It has got a TABLESPACE option.

Internet Services

Web Development

Digital Marketing

Consumer Tech