Hai,

I need to know which backup method best for 24x7 database.

Our database is archive log mode and we are maintaing daily full export dump and maintaining archive log backup also.

One scenario I will tell here.

I am taking full export backup at 4.30 am database is working continuously and morning 10 am database going to crash.

my way recovery is

1st I should I put full export and load the data upto 4.30 am.

after 4.30 am to 10am data how should I get it.

1st I put full dump and I should do recovery and I need to apply archive log.

Here I have a doubt from which point to I start recovery. plz tell me.

because I don't know 4.31 am what is the log sequence ?.

So how should I get data from 4.31 am to 10 am.


mail me soon.........



Thanking you,


G.Shankar.