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

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" ?

• Matthew Zito <mzito_at_gridapp.com> wrote:

> 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