Re: Backup Oracle ? Online Redo Log.
From: joel garry <joel-garry_at_home.com>
Date: Wed, 25 Jul 2012 09:18:18 -0700 (PDT)
Message-ID: <26704fb4-95de-4822-9b12-0ac506887d91_at_x6g2000pbh.googlegroups.com>
On Jul 25, 7:31 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> 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?
Date: Wed, 25 Jul 2012 09:18:18 -0700 (PDT)
Message-ID: <26704fb4-95de-4822-9b12-0ac506887d91_at_x6g2000pbh.googlegroups.com>
On Jul 25, 7:31 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> 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?
And how? Google was disallowing group replies to posts more than some months old... even in this thread, I see it only allowing group replies to yours and his. I see from his headers he's using google... ohhhhh, the new google groups doesn't make that age distinction. I wish there was some way to tell them that is stupid. I've submitted under the "why you are switching back to the old google groups," but that's kind of like posting that Oracle should keep supporting hp-ux.
At least Howard's explanation is still the best on the subject.
jg
-- _at_home.com is bogus. http://www.utsandiego.com/news/2012/jul/24/states-ask-help-collecting-internet-sales-taxes/?apReceived on Wed Jul 25 2012 - 11:18:18 CDT