Re: Oracle logging and recovery

In article <C1tDC6.1D4_at_jbecpor.demon.co.uk> smj_at_jbecpor.demon.co.uk (Martin Jarvis) writes:
>
>The method of backup I perform is to take a full export of the database to disk,then our system manager backs up all the files on the system. This gives me
>three options for recovery. Either full restore of database files (quickest),
>full restore of database tables or restore of individual tables. The only floors
>in this method are that in the event of failure we have to go back to the
>situation as of the previous night and that the database is unavailable for 1/2
>hour at 11:00pm every night.

It's not clear here whether your system manager is backing up files while the database is shut down. File backups of database files on a live database are not possible except in combination with archive log mode.

-- 
Norman Soley, Software Specialist                    Digital Equipment of Canada
soley_at_trooa.enet.dec.com  | Opinions expressed are mine and do not reflect those
                          | of Digital Equipment Corporation or my cat Marge. 
"I saw the fox, but I did not see it eat the Pekinese dog"