[Tina]

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.

Thanks!

[marist89]

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

[clio_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