Recover Database without RBS segments and Temporary Segments, Is It possible ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Recover Database without RBS segments and Temporary Segments, Is It possible ?

  1. #1
    Join Date
    Sep 2004
    Posts
    54

    Recover Database without RBS segments and Temporary Segments, Is It possible ?

    Dear All,

    We have dataware house system which is over 100G in size, due to the size we are planning NOT to backup RBS segments and Temporary tablespaces.

    At the moment, we are taking complete file backup.

    My question is, in case we had to restore from tapes,

    Could re-build the database without RBS and TEMP segments ?

    I have studied that, we could drop rollback segments including contents and re-create them ?


    Please advice.


    Thanks

    V.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you HAVE to back up RBS segments (well the tablespace they are in). You wont be able to recover the database without them, no need to backup TEMP

  3. #3
    Join Date
    Sep 2004
    Posts
    54
    We have a rollback segment called RBS_BIG01 with 4 datafiles (12g). mostly it is offline, can we avoid backing-up this one ?

    Thanks

    V.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, you must backup the rbs tablespace

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you want to save space use RMAN and if you are in 10g use RMAN Compression, it reduces to around 15%

  6. #6
    Join Date
    Sep 2004
    Posts
    54
    Thanks to Davey, and Pando for thier help.

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