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?

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?

• 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?

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?

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?

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?

Thanks Received on Fri Feb 14 2003 - 07:43:48 CST