Re: Implementing Archiving of Redo logs some more questions

<Answers embedded
----- Original Message -----
From: <mokat67_at_hotmail.com>
Newsgroups: comp.databases.oracle.server Sent: Friday, February 14, 2003 2:43 PM
Subject: Re: Implementing Archiving of Redo logs some more questions

> Can someone give me an answer on the following:
>
> 1- Does it has any impact if the database (8i) is running in NO
> ARCHIVE mode but the init.ora parameter set >> LOG_ARCHIVE_START=TRUE
> or will this parameter ignored in no archive mode?

It simply doesn't make any sense.

>
> 2- when activating in the DB archiving logging:do i still have to do
> the following command ALTER SYSTEM ARCHIVE LOG START after first time
> open the database ? or is has the LOG_ARCHIVE_START=TRUE parameter in
> the ini.ora file already done this for me?
>

That's what the log_archive_start parameter was invented for in the first place
>
> - I have the tow following archive locations
> log_archive_dest_1 = "LOCATION=E:\ARCH1"
> log_archive_dest_2 = "LOCATION=D:\ARCH2"
>
> 3- If I use the " Archive log list " command then I noticed that the
> the 2nd location on the D drive is mentioned as the archive log
> location. Why is that and why not the 1st location on the E drive or
> both?
>

Archive log list was invented in version 6. It might be considered obsolete and replaced by new functionality, like the v$archive_dest view. I wouldn't bother about it, as long as v$archive_dest is correct.

> 4- In case of recovery operation where is the database looking for
> the log files? In my case location 1, 2 or both as long as he find the
> right log?

c) is the right answer

>
> 5- According to the default parameter settings must one location be
> available for archiving. I gues it does not matter which one of the
> two?
>

It does not matter which one of the two.

> 6-What is the prefered log swith time: every 30 minutes? The data is
> critical bot not that critical? Is the best way to get to a the 30 min
> or whatever to change the size of the redo log files?
>

That's entirely up to you. Usually when you switch more often than every 10 mins the impact on performance becomes noticeable. You will also suffer from a deluge of files to back up. Remember it might be more useful to have a checkpoint every 15 minutes. This may or may not concur with the size of your online redolog file. As usual: it depends, and you have to try what suits you best.

> Thanks

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address