backup tablespaces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: backup tablespaces

  1. #1
    Join Date
    Jun 2000
    Location
    Memphis,TN
    Posts
    30
    8.1.6.0.0,nt 4.0

    We are running hot backups .what happens if we do not backup contents of all the tablespaces i.e we do not run following for, let us say, 2 out of 7 ts:
    alter ts ts_1 begin backup
    copy df using host command
    alter ts ts_1 end backup;

    how will it affect the recovery when it becomes necessary?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Not sure but if you have all archived logs there is always a posibility to recover a database.
    Although who would do partial backups...?

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    That's one of those things where depending on the activity of those datafiles it might work, and it might not work. The better solution is to fix the backup script for good.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jun 2000
    Location
    Memphis,TN
    Posts
    30
    well looks like cannot escape the obvious.
    I was trying to avoid backing up ts like tools etc which for the time being are not being used much.also there are some ts which contain large lookup tables which get replaced each night thru sql loader.

    but I guess there is no shortcut to peacefull nights.


    thanks

  5. #5
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    If u are using 8i , did you try doing transportable tablespaces. However, this works if you have carefully selected tables going to each TS, which you may want to backup and TS which you dont need to back up. That might be helpful
    Thanks
    Kishore Kumar

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    If you have a large disk space where you keep the archived log files since the last hot back up of a tablespace was taken, you can very well go for partial Tablespaces hot back up. Note that you must have one backup of all tablespaces if you want to perform full recovery of the database.

  7. #7
    Join Date
    Jun 2000
    Location
    Memphis,TN
    Posts
    30
    thanks everyone.

    rt now I have no clue on transportable tablespaces but will be xploring .but yes ,We have pretty clearly marked up tables which can be reconstructed and loaded using scripts anytime and hence need not be backed up every night and those that must be.

    [Edited by BRAUK on 12-18-2000 at 03:32 PM]

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