Re: Backup Oracle ? Online Redo Log.
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Wed, 25 Jul 2012 07:31:57 -0700 (PDT)
Message-ID: <4a2d8cd2-0180-4727-9c40-62043893c1ed_at_googlegroups.com>
On Wednesday, July 25, 2012 3:40:18 AM UTC-4, sredh..._at_gmail.com wrote:
> It is illogical by want to take backup of online redolog file..
> why because, lgwr process generate archive log when every checkpoint occurs..the checkpoint occurs when the transaction commits/rollback..If you want to take backup of online redo that will become as a invalid transaction(transaction not ends)..no need of taking that as a backup..even if you want to take a copy of online redo then generate the archive log by issuing log switch/checkpoing manually.
>
> Thanks,
> Sredhar.
>
> On Thursday, 10 January 2002 13:46:23 UTC+5:30, cm wrote:
> > Hi,
> >
> > It is useful to backup regularly the online redo log ?
> > If yes, how should I do it ? Just an OS copy ?
> >
> > Thanks in advance.
> >
> > Christian.
Date: Wed, 25 Jul 2012 07:31:57 -0700 (PDT)
Message-ID: <4a2d8cd2-0180-4727-9c40-62043893c1ed_at_googlegroups.com>
On Wednesday, July 25, 2012 3:40:18 AM UTC-4, sredh..._at_gmail.com wrote:
> It is illogical by want to take backup of online redolog file..
> why because, lgwr process generate archive log when every checkpoint occurs..the checkpoint occurs when the transaction commits/rollback..If you want to take backup of online redo that will become as a invalid transaction(transaction not ends)..no need of taking that as a backup..even if you want to take a copy of online redo then generate the archive log by issuing log switch/checkpoing manually.
>
> Thanks,
> Sredhar.
>
> On Thursday, 10 January 2002 13:46:23 UTC+5:30, cm wrote:
> > Hi,
> >
> > It is useful to backup regularly the online redo log ?
> > If yes, how should I do it ? Just an OS copy ?
> >
> > Thanks in advance.
> >
> > Christian.
Why would anyone post a response to a thread last updated in 2002? Received on Wed Jul 25 2012 - 09:31:57 CDT