非主备关系数据库之间的远程归档基本实现,但是现在还有一个问题:
当源数据库关闭之后,远程备份在另一个数据库上的归档日志文件跟着就消失了,如果我想一直保存这些文件直到我去删除可以吗?
远程归档的实现方式是
alter system set log_archive_dest_2='SERVICE=standby NOREGISTER reopen=60 MAX_FAILURE=3' scope=BOTH;
...全文
2239打赏收藏
oracle10g 远程归档问题
非主备关系数据库之间的远程归档基本实现,但是现在还有一个问题: 当源数据库关闭之后,远程备份在另一个数据库上的归档日志文件跟着就消失了,如果我想一直保存这些文件直到我去删除可以吗? 远程归档的实现方式是 alter system set log_archive_dest_2='SERVICE=standby NOREGISTER reopen=60 MAX_FAILURE=3' scope=BOTH;
我现在将“备”数据库升级到11g,发现11g里面废除了参数STANDBY_ARCHIVE_DEST,并且现在在实现远程归档时源数据库(10g)总在alter_*.log里面抛这样的错误信息:
------------------------------------------------------------
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 standby
FAL[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 rejected