Anyone syncing database files?

[Eric Whiting]

You can do a hot backup by simply setting all the tablespaces in backup 
mode (alter tablespace 'BLAA' begin backup).
Then you can rsync the database files and do an 'end backup' on each 
tablespace after.

This will give you files that are consistient and the database will be 
recoverable from those files. A hot backup is useless unless you do this...

eric



Brian Cuttler wrote:

>I second that. We backup Oracle on Solaris but we insist that the
>oracle is down.
>
>On Fri, Aug 20, 2004 at 10:48:20PM +0200, Jan-Benedict Glaw wrote:
>  
>
>>On Fri, 2004-08-20 16:43:07 -0400, Loukinas, Jeremy <Jeremy.Loukinas at evenflo.com>
>>wrote in message <F7CAE41A098CD5119FA700A0C9E5F9F7051B5FDA at evvan1exc1.evenflo.com>:
>>    
>>
>>>Anyone syncing say 18-20gb Oracle dbf files..?
>>>      
>>>
>>No problem--as long as you don't try to backup hot database files.
>>Shutdown Oracle first:)
>>
>>MfG, JBG
>>
>>-- 
>>Jan-Benedict Glaw       jbglaw at lug-owl.de    . +49-172-7608481             _ O _
>>"Eine Freie Meinung in  einem Freien Kopf    | Gegen Zensur | Gegen Krieg  _ _ O
>> fuer einen Freien Staat voll Freier Bürger" | im Internet! |   im Irak!   O O O
>>ret = do_actions((curr | FREE_SPEECH) & ~(NEW_COPYRIGHT_LAW | DRM | TCPA));
>>    
>>
>
>
>
>  
>
>>-- 
>>To unsubscribe or change options: http://lists.samba.org/mailman/listinfo/rsync
>>Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html
>>    
>>
>---
>   Brian R Cuttler                 brian.cuttler at wadsworth.org
>   Computer Systems Support        (v) 518 486-1697
>   Wadsworth Center                (f) 518 473-6384
>   NYS Department of Health        Help Desk 518 473-0773
>
>  
>