Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    4

    Unanswered: tablespace restoration

    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

  2. #2
    Join Date
    May 2005
    Location
    Bangalore, India
    Posts
    35
    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.

  3. #3
    Join Date
    Aug 2009
    Posts
    4
    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.

  4. #4
    Join Date
    May 2005
    Location
    Bangalore, India
    Posts
    35
    The command remains the same 'RESTORE DATABASE'. It has got a TABLESPACE option.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •