Hi,
I am in the process of implementing Failover to our production
database. Inorder to able to restore to the last archive log, I have
cron job from the production database that runs every 5-10min to check
if there are any new archive logs and copy new archive logs to the
remote stand by
...I have a
cron job from the production database that runs every 5-10min to check
if there are any new archive logs and copy new archive logs to the
remote stand by failover machine.
The problem with this scenario is that there might be a possibility that
I might scp a partially filled archi
Steve Crawford wrote:
...I have a
cron job from the production database that runs every 5-10min to
check if there are any new archive logs and copy new archive logs to
the remote stand by failover machine.
The problem with this scenario is that there might be a possibility
that I might scp a
Hi Steve,
Thanks! for the quick reply, I thought about rsync too, but wasnt
sure about completely how it handles partial files. I use rsync for all
the backups, it works fine for all the application except for our mail
application it copies the files but at the end of the job it gives me
m
On Thu, Mar 23, 2006 at 12:28:41PM -0800, Steve Crawford wrote:
> >...I have a
> >cron job from the production database that runs every 5-10min to check
> >if there are any new archive logs and copy new archive logs to the
> >remote stand by failover machine.
> >
> >The problem with this scenario
Jim C. Nasby wrote:
On Thu, Mar 23, 2006 at 12:28:41PM -0800, Steve Crawford wrote:
...I have a
cron job from the production database that runs every 5-10min to check
if there are any new archive logs and copy new archive logs to the
remote stand by failover machine.
The problem with this
On Fri, Mar 24, 2006 at 10:39:41AM -0500, Pallav Kalva wrote:
> What do you think about this option ? If I just do scp from the
> /archives folder, I will be ok and wont copy any partial files at any
> time right ?
> archive_command = 'cp %p /archives-temp/%f && mv /archives-temp/%f
> /archive
Jim C. Nasby wrote:
On Fri, Mar 24, 2006 at 10:39:41AM -0500, Pallav Kalva wrote:
What do you think about this option ? If I just do scp from the
/archives folder, I will be ok and wont copy any partial files at any
time right ?
archive_command = 'cp %p /archives-temp/%f && mv /archives-temp
On Fri, Mar 24, 2006 at 12:12:54PM -0500, Pallav Kalva wrote:
> Jim C. Nasby wrote:
> >On Fri, Mar 24, 2006 at 10:39:41AM -0500, Pallav Kalva wrote:
> >
> >> What do you think about this option ? If I just do scp from the
> >>/archives folder, I will be ok and wont copy any partial files at any