Re: archive logs

From: Igor Neyman <igor.neyman_at_gmail.com>
Date: Fri, 20 May 2016 14:37:05 -0400
Message-ID: <CAJoeKmuQhaiX+n0pAwYC6kqTBatB+JgxCSJVbbZJ2MU4p0vD9A_at_mail.gmail.com>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 20 2016 - 20:37:05 CEST