Duplicate redo-log files

[mscim]

Hi, would appreciate help on this issue. I would like to have redundant redo-log file on seperate hard disk. How do I set this? There is an option to specify additional redo-logs members in Oracle Enterprise Manager Console. Does this do the job?

What about archive logs? How do we store redundant copies on other hard disk other than the default path?

 

[alexhu]

What version of Oracle ?

Alex

 

[mscim]

Oracle 8.1.7

 

[alexhu]

For duplex archive logs (i.e 2 copies of live logs) alter the init.ora to include 'log_archive_duplex_dest = <path>'

For example (UNIX based)

log_archive_start = true # if you want automatic archiving
log_archive_dest = /u04/archivelogs/pkms/
log_archive_duplex_dest = /u03/archivelogs/pkms
log_archive_min_succeed_dest = 1
log_archive_format = arch%S.arc


I believe you can add log members using Enterprise Manager, but do not use this tool, so suggest you checkout the docs.

To do it manually use:

Read 'Managing the Online Redo Log' in the admin guide

then

use 'ALTER DATABASE
ADD LOGFILE GROUP 10 ('log1c', 'log2c') SIZE 500K;'

to add logfiles to groups

Alex