Restore TS to different database??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Restore TS to different database??

  1. #1
    Join Date
    Aug 2001
    Posts
    27

    Question Restore TS to different database??

    I need to restore several tablespaces from an RMAN database backup (DB-1) to a different database (DB-2) on a different server than where they originated. These tablespaces currently do not exist in DB-2. Other tablespaces do exist, so datafiles will not have the same file number in the target database. Both source and target databases are 9iRAC. Can this be done? If so, how? Export/import isn't feasible due to file sizes and nature of data.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    transportable tablespaces is your only option, you cant do it from an rman backup

  3. #3
    Join Date
    Aug 2001
    Posts
    27
    From what I understand, in order to use transportable tablespaces as a means to copy the tablespaces, I would need to set up a temporary database, do a full restore from the rman backup, alter the tablespaces to be copied to be transportable, and then export/import the tablespaces. Is this correct?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, transportable tablespace is when you take a tablespace from one database directly to another (as long as they are the same versiob and os)

    It involves taking the tablespace offline, checking for violations then exporting the basic files and importing the tbs into a different database.

    You said you were short of space so this may not be an option for you either (but you are limited in what you can do)

  5. #5
    Join Date
    Aug 2001
    Posts
    27
    The source database is a 24x7 production database so I can't take the ts offline. I would have to build an intermediate db in order to do that, in which case it would probably be easier to just create a temporary database and do a full restore.

    Thanks for all the input. You definitely saved me some time & trouble.

Posting Permissions

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



Click Here to Expand Forum to Full Width