Re: 8.1.7 connection problems

Paul,

thanks for your advice. Gotta admit that I'm a bit surprised as at least for 8.1.7 Oracle documentation recommends cold backups whereever possible. Doing that both as physical backup of the datafiles and as export.

As additional security measure I've set up a standby database that runs with a time lag and performs daily (scripted) manual recovery from the archivelogs in the morning before business starts. For 8.1.7 that means without doing it without rman as rman only learned that feature (time lag and recovery at a certain time) with Oracle 9.

What I'll do for now is changing the nightly maintenance schedule from simply time based to time based plus error conditions plus parallelizing as much as possible to reduce database downtime.

Could you elaborate why you consider cold backups a real pain?

Stephan.

Paul Drake wrote:

>Ah. So one possible solution is, have them stop performing offline backups.
>
>Their options would be:
>
>hot physical backups
>rman backups
>
>IMHO, cold backups are a real pain.
>
>

--
http://www.freelists.org/webpage/oracle-l