Re: Super easy ? for you gurus

From: Adrian Beane <ajbeane_at_zetnet.co.uk>
Date: 1997/05/12
Message-ID: <1997051212574079437@zetnet.co.uk>#1/1

> Our database is actually a datawarehouse 300+ gig. We are not running
> in archivelog mode.
> My question: Why does the database need to be shutdown in order to
> perform a backup? Isn't it a read only process as far as the DB is
> concerned?
> Most of the data is historic and therefore static. Users are not able
> to add, insert or delete.
> Any answer is greatly appreciated.

Not really an answer but ...
Why aren't you running in archivelog mode? It sounds ideally suited to the setup you've described. You would generate very few redologs (if any) and could do your online backup safely.

-- 
 Adrian Beane
 ajbeane_at_zetnet.co.uk

 "Hey, these opinions aren't even mine"

Received on Mon May 12 1997 - 00:00:00 CDT