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
files?
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',
'd:\oracle\oradata\booktst\booktst\redo05b.log')
size 50m;
ALTER DATABASE ADD LOGFILE THREAD 2
GROUP 4 ('u01/oracle/redo/file4a',
'u02/oracle/redo/file4a') size
50M,
GROUP 5 ('u02/oracle/redo/file5a',
'u02/oracle/redo/file5a')
size 50M,
GROUP 6 ('u03/oracle/redo/file6a',
'u02/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'
SELECT
DEST_NAME,
STATUS,
DESTINATION
FROM
V$ARCHIVE_DEST
WHERE
DESTINATION
IS NOT NULL;
DEST_NAME
STATUS DESTINATION
------------------------------------------------------------
LOG_ARCHIVE_DEST_1 ALTERNATE
/u01/archives
LOG_ARCHIVE_DEST_2 ALTERNATE
/u02/oratest/TESTDB/arch
Using the log_archive_min_succeed_dest parameter is
related, see
log_archive_min_succeed_dest.
|
|
|
|
|
Oracle Training from Don Burleson
The best on site
"Oracle
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
Note:
This Oracle
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
Oracle forum.
Verify
experience!
Anyone
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
publish
their Oracle
qualifications.
Errata?
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
feedback. Just
e-mail:
 and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
Burleson
Oracle ®
is the registered trademark of Oracle Corporation.
|
|
