Hot backups
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Hot backups

  1. #1
    Join Date
    Jan 2001
    Posts
    216

    Hot backups

    If a tablespace has 2 files, is the foll backup methodology valid?

    alter tablespace APPUSER begin backup;
    host copy G:\APPUSER01.DBF F:\backup;
    alter tablespace APPUSER end backup;

    alter tablespace APPUSER begin backup;
    host copy G:\APPUSER02.DBF F:\backup;
    alter tablespace APPUSER end backup;

    Or should we always back it up as

    alter tablespace APPUSER begin backup;
    host copy G:\APPUSER01.DBF F:\backup;
    host copy G:\APPUSER02.DBF F:\backup;
    alter tablespace APPUSER end backup;

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Both methods are valid.

    However, if you intend to backup both files during the same "backup session" (i.e. one after another right away), then I see no reason why one would use method 1.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jan 2001
    Posts
    216
    Thank you.

    I have recently "inherited" this database and dont know why they have set it up like that. The APPUSER tablespace has over 50 datafiles and the backup script goes over and does this thing 50 times...

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