Question: What do
I do to mirror my archived redo logs into two disk
locations. I want to send my archived redo logs to two
separate disks. How do I mirror my archived redo log
Answer: There are several ways to
mirror your archived redo logs. You can do any of
these mirroring options:
1 - Data Guard: Using data guard
will copy the archived redo log files to another server.
You can also write an OS job to poll the archived redo log
destination and copy the archived redo log files once they
have completed being written.
2 - Hardware level mirroring:
Mirroring the disk that contains the archived redo logs will
result in having two copies of the redo logs being written
to two disks.
3 - Mirroring redo log groups:
Having multiple redo log groups pointing to different disk
locations will result in mirrored archived redo logs.
See these notes on multiple redo logs groups
redo log groups.
alter database add logfile
group 5 ('c:\oracle\oradata\booktst\booktst\redo05a.log',
ALTER DATABASE ADD LOGFILE THREAD 2
GROUP 4 ('u01/oracle/redo/file4a',
GROUP 5 ('u02/oracle/redo/file5a',
GROUP 6 ('u03/oracle/redo/file6a',
size 50M ;
4 - Mirroring redo log destinations: You
can use the log_archive_log_dest_n parameters to multiplex
and mirror the redo logs. See
my notes on multiplexing redo log files.
log_archive_dest_1 = '/db1/arch'
log_archive-dest_2 = '/db2/arch'
log_archive-dest_3 = '/db3/arch'
IS NOT NULL;
Using the log_archive_min_succeed_dest parameter is
Oracle Training from Don Burleson
The best on site
training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!
Burleson is the American Team
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
is the registered trademark of Oracle Corporation.