عاجل كيف اعمل نسخة احتياطية

We have a server runs windows 2003 server and contains 4

HD, each Hd contains one partition.

on that server we have oracle server holds database working in

archivelog mode. that server work from 8:00 am to 8:00 pm each day

including friday.

that database contains the following Tablespaces:

- system (on C:\ Drive)

- Undo (on D:\ Drive)

- temp (on D:\ Drive)

- users (on E:\ Drive)

- indx (on F:\ Drive)

- archive (on E:\ Drive)

- stock (on E:\ Drive)

- accounts (on E:\ Drive)

and contains 4 control files seperated among the 4 disks and 4 log

groups each group contains 2 members (on C:\ and d:\ respectively).

the Archive destnation is a folder of F:\

First : please put a plan to backup the database without using RMAN

everyweek

Second : explain how to recover database in 4 cases :

a- The first disk (corresponds to C:\) is lost

b- the second disk (corresponds to d:\) is lost

c- the forth disk (corresponds to e:\) is lost

d- the tablespace stock is dropped by mistake on "2008-09-11:18:05:04"