错误如下:
在STANDBY库上的SVRMGRL中:
SVRMGR> recover managed standby database timeout 60;
ORA-00308: ???????? 'D:\ORACLE\ORADATA\ORACLE\ARCHIVE\ORACLET001S00277.ARC'
ORA-27041: ??????
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
可主服务器上的归档日志才到276啊。
于是我不管,在主服务器上切换日志后错误:
SQL> alter system archive log current;
alter system archive log current
*
ERROR at line 1:
ORA-16038: log 3 sequence# 277 cannot be archived
ORA-00000: normal, successful completion
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\ORACLE\REDO03.LOG'
看警告日志:
ARC0: Beginning to archive log# 3 seq# 277
ARC0: Failed to archive log# 3 seq# 277
Wed Apr 02 09:19:09 2003
ARCH: Error 12154 connecting to standby host 'standydb'
ARCH: Error 12154 creating archivelog file 'standydb'
ARCH: Failed to archive log# 3 seq# 277。
主数据库参数文件:
log_archive_dest_2 = "SERVICE=standydb MANDATORY REOPEN=60"
log_archive_dest_state_2 = enable STANDBY库参数文件:
STANDBY_ARCHIVE_DEST = f:\oracle\archive_man
log_archive_dest_1 = "location=f:\Oracle\archive"
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
LOG_ARCHIVE_TRACE = 8
DB_FILE_NAME_CONVERT = d:\oracle\oradata\oracle, f:\oracle
LOG_FILE_NAME_CONVERT = d:\oracle\oradata\oracle, f:\oracle
control_files = ("F:\Oracle\STANDBYCTL.CTL")
log_archive_start = true
在STANDBY库上的SVRMGRL中:
SVRMGR> recover managed standby database timeout 60;
ORA-00308: ???????? 'D:\ORACLE\ORADATA\ORACLE\ARCHIVE\ORACLET001S00277.ARC'
ORA-27041: ??????
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
可主服务器上的归档日志才到276啊。
于是我不管,在主服务器上切换日志后错误:
SQL> alter system archive log current;
alter system archive log current
*
ERROR at line 1:
ORA-16038: log 3 sequence# 277 cannot be archived
ORA-00000: normal, successful completion
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\ORACLE\REDO03.LOG'
看警告日志:
ARC0: Beginning to archive log# 3 seq# 277
ARC0: Failed to archive log# 3 seq# 277
Wed Apr 02 09:19:09 2003
ARCH: Error 12154 connecting to standby host 'standydb'
ARCH: Error 12154 creating archivelog file 'standydb'
ARCH: Failed to archive log# 3 seq# 277。
主数据库参数文件:
log_archive_dest_2 = "SERVICE=standydb MANDATORY REOPEN=60"
log_archive_dest_state_2 = enable STANDBY库参数文件:
STANDBY_ARCHIVE_DEST = f:\oracle\archive_man
log_archive_dest_1 = "location=f:\Oracle\archive"
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
LOG_ARCHIVE_TRACE = 8
DB_FILE_NAME_CONVERT = d:\oracle\oradata\oracle, f:\oracle
LOG_FILE_NAME_CONVERT = d:\oracle\oradata\oracle, f:\oracle
control_files = ("F:\Oracle\STANDBYCTL.CTL")
log_archive_start = true
http://www.itpub.net/showthread.php?s=38921d6030adcd71d172f3d3ca534c49&threadid=7888&perpage=15&pagenumber=2