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

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: Matthew Zito <mzito@xxxxxxxxxxx>
  • Date: Fri, 10 Nov 2006 07:23:13 +0800 (SGT)

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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx 
> > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: