非主备关系数据库之间的远程归档基本实现,但是现在还有一个问题:
当源数据库关闭之后,远程备份在另一个数据库上的归档日志文件跟着就消失了,如果我想一直保存这些文件直到我去删除可以吗?
远程归档的实现方式是
alter system set log_archive_dest_2='SERVICE=standby NOREGISTER reopen=60 MAX_FAILURE=3' scope=BOTH;
当源数据库关闭之后,远程备份在另一个数据库上的归档日志文件跟着就消失了,如果我想一直保存这些文件直到我去删除可以吗?
远程归档的实现方式是
alter system set log_archive_dest_2='SERVICE=standby NOREGISTER reopen=60 MAX_FAILURE=3' scope=BOTH;
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
It may be necessary to define the DB_ALLOWED_LOGON_VERSION
initialization parameter to the value "10". Check the
manual for information on this initialization parameter.
------------------------------------------------------------
Sat Dec 29 15:35:35 2007
Errors in file d:\oracle\product\10.2.0\admin\oradb\bdump\oradb_arc1_3284.trc:
ORA-16191: Primary log shipping client not logged on standbyFAL[server, ARC1]: Error 16191 creating remote archivelog file 'orabi'
FAL[server, ARC1]: FAL archive failed, see trace file.
Sat Dec 29 15:35:35 2007
Errors in file d:\oracle\product\10.2.0\admin\oradb\bdump\oradb_arc1_3284.trc:
ORA-16055: FAL request rejectedARCH: FAL archive failed. Archiver continuing我已确认两边SYS用户的密码是一样的,能互相用SQLPLUS访问,并且在两边的sqlnet.ora文件中加入了:
SQLNET.DB_ALLOWED_LOGON_VERSION=10
问题还是没能解决。
是版本问题吗??或者是我还没找到正确的方法?