归档日志路径冗余配置
当存放日志的存储出现故障时,可以自动切换到第二条路径的存储,保证数据库能正常运行
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;
当存放日志的存储出现故障时,可以自动切换到第二条路径的存储,保证数据库能正常运行
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/