Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002

    Unanswered: Backup & recovery time

    I am new to Oracle DBA.
    I am using Oralce 9i in nonarchive mode & win2k. The total size of control(3)$data(7)$redo(5 group, 3members/group) files is 15G.
    It will be backed up once a week.
    Anybody can tell me how long it will take to backup and recovery normally? Say the backup media is harddrive.


  2. #2
    Join Date
    Oct 2002
    Depends on how fast your media is. I can backup a 15G database to NFS mounted RAID 0 disk in about 5 minutes.

  3. #3
    Join Date
    Apr 2002
    California, USA


    SCSI drives can write data from 60 to 160 Mb/s. Of course there is some OS kernel overhead. Divide your 15 Gb of data to the write speed of your drives and backup time will be estimated.

    For the restore, again drives speed first + ORACLE DBA speed to resolve db crash scenarious :-)) . Even the most seasoned DBA's panic when production db goes down, so get your best estimated time, multiply it by 2, and scale up once. So if you usually restore for 1 hour - that might take up to 2 days (according to Murphy :-)) )

    Hope that helps,

    clio_usa - OCP - DBA

Posting Permissions

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