为什么log_archive_dest_1归档满掉之后不会切换到log_archive_dest_2

Yong Huang

原帖由 zhoul777 于 2008-8-3 03:03 发表
这样设置就可以了：
log_archive_dest_1 = 'LOCATION=/archlog NOREOPEN ALTERNATE=log_archive_dest_2'
log_archive_dest_2 = 'LOCATION=/expfile/archlog NOREOPEN'
log_archive_dest_state_1 =enable
log_archive_dest_state_2 =alternate

Your original setting is:

log_archive_dest_1='location=/other/arch alternate=log_archive_dest_2'
log_archive_dest_2='location=/ora9data/stbtest/arch'
log_archive_dest_state_1=enable
log_archive_dest_state_2=ALTERNATE

The only real difference is that you removed "NOREOPEN". So that's the problem? Do you mind you do another test by adding NOREOPEN back? Perhaps adding it to both, and then adding only to one of the two?

Yong Huang

anycall2010

原帖由 zhoul777 于 2008-8-3 17:03 发表
这样设置就可以了：
log_archive_dest_1 = 'LOCATION=/archlog NOREOPEN ALTERNATE=log_archive_dest_2'
log_archive_dest_2 = 'LOCATION=/expfile/archlog NOREOPEN'
log_archive_dest_state_1 =enable
log_archive_dest_state_2 =alternate

能告诉一下 noreopen参数的详细含义？