Re: archive logs
Date: Fri, 20 May 2016 13:47:25 -0500
Message-ID: <CAJt=wvUMhJMXJFZjZhG+MLQmQ8AoAMoZYfFwm2XQoR+ibt1AOw_at_mail.gmail.com>
You could schedule a job to perform an ALTER SYSTEM SWITCH ARCHIVELOG every certain time (5 mins, just for example); probably you would have some archives out of that tim sync, but would be just a few.
Regards
David Ramírez Reyes
Profesión: Padre de Familia
On 20 May 2016 at 13:41, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:
> Yes, you are correct and that’s kind of why I was asking if someone had
> something that does give a similar reading…….i couldn’t find anything
> useful…….
>
>
>
>
>
> Brian
>
>
>
>
>
> *From:* Igor Neyman [mailto:igor.neyman_at_gmail.com]
> *Sent:* Friday, May 20, 2016 2:37 PM
> *To:* Zelli, Brian
> *Cc:* oracle-l (oracle-l_at_freelists.org)
> *Subject:* Re: archive logs
>
>
>
> You are comparing different things.
> To simplify: Transaction log in SQL Server combines the info that Oracle
> keeps in UNDO and REDO.
>
> Transaction log will grow until being truncated, REDO log file has fixed
> size.
> Transaction log backed up on schedule, REDO log archived when they get
> full.
>
> Regards,
>
> Igor Neyman
>
>
>
> On Fri, May 20, 2016 at 2:22 PM, Zelli, Brian <Brian.Zelli_at_roswellpark.org>
> wrote:
>
> Ok, we are setting up a matrix of recovery tiers and I’m having a bit of
> a hard time with oracle. SQL Server has t-log backups set up in jobs. How
> do I tell by frequency time when logs get archived? I’ve found a lot of
> scripts that give me the when but they vary so it can be a few minutes, it
> can be an hour. Is there a way to see if it is set to so many minutes?
>
>
>
>
>
> Brian
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 20 2016 - 20:47:25 CEST