归档日志路径冗余配置

归档日志路径冗余配置
当存放日志的存储出现故障时，可以自动切换到第二条路径的存储，保证数据库能正常运行

alter system set log_archive_dest_1='location=d:\oracle\product\10.2.0\oradata\arch\mgf\ alternate=log_archive_dest_2 reopen=5 max_failure=6' scope=both;
alter system set log_archive_dest_2='location=d:\oracle\backup\arch\' scope=both;
alter system set log_archive_dest_state_1=enable scope=both;
alter system set log_archive_dest_state_2=alternate scope=both;

LOCATION=d:\oracle\product\10.2.0\oradata\arch\mgf

alter system set log_archive_dest_state_1=enable;
alter system set log_archive_dest_state_2=alternate;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24668589/viewspace-716597/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24668589/viewspace-716597/