Re: Hot backups vs. Offline Backups

In article <4asd5s$855_at_romeo.logica.co.uk>, mcdonaldr_at_logica.com says...
>
>proberts_at_isc901.jsc.nasa.gov (Paul Roberts) wrote:
>
>
>>HOWEVER, if you export the database, Oracle guarantees that you will
>>have a copy of the database contents which is internally consistent.
>>You can back this file up whenever you want.
>
> [...]
>
>The only way this will work is if you prevent writes to the table
>during export which may not be acceptable.
>

It is possible to do read consistent exports. Check for the Export Parameter CONSISTENT=Y   [Server Utilities User's Guide p.1-11]

(However this can be very rollback-consuming and hence should be used  with care.)

greetings

-- 
    _/_/_/   _/_/_/ _/    _/  // Reinhard Kuhn             /  It can be      
   _/    _/ _/     _/  _/    //         (kuhn_at_cas-ps.com) /  done quickly,   
  _/_/_/   _/_/_/ _/_/      // CAS GmbH                  /  cheaply or well  
 _/  _/   _/     _/  _/    // Lemberger Strasse 14      /   - pick any two!  
_/   _/  _/_/_/ _/    _/  // 66955 Pirmasens, Germany  /