Re: archive logs
Date: Fri, 20 May 2016 13:49:46 -0500
Message-ID: <CAJt=wvUYx2RvpcvL-ToQg8s24=RfXZRm-psQLAbiaQAbp5KrYA_at_mail.gmail.com>
Just correcting the syntax: ALTER SYSTEM SWITCH LOGFILE;
David Ramírez Reyes
Profesión: Padre de Familia
On 20 May 2016 at 13:47, David Ramírez Reyes <dramirezr_at_gmail.com> wrote:
> 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:49:46 CEST