Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tried "rsync" for Database (Hot/Cold/Snapshot), Binaries, Arc hiveLogs

RE: Tried "rsync" for Database (Hot/Cold/Snapshot), Binaries, Arc hiveLogs

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Fri, 10 Nov 2006 07:23:13 +0800 (SGT)
Message-ID: <1163114593.4553b8610476d@discus.singnet.com.sg>

Could it be used for Online (Hot) Backups ? When you say "consistent" do you mean "no I/O running on the datafile" (eg as in Duncan's case, a Standby Database in frozen recovery) or do you just mean "the files are in BEGIN BACKUP mode" ?

> It absolutely does make sense to use for datafiles, you just have
> to
> make sure they're consistent. I've done a couple of environments
> with
> rsync as poor man's replication/DR/backups/etc.
>
> Matt
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lawie, Duncan
> >
> > I've used it to "revert" a physical standby database which
> > had been opened but not much changed.
> >
> > However, my source database was another physical standby
> > which had been taken out of recovery so that it was in a
> > non-changing state.
> >
> > I can't remember the exact syntax now, but using large rsync
> > block sizes made sense, as a relatively small proportion of
> > (database) blocks had changed.
> >

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 09 2006 - 17:23:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US