概述
win+oracle10g
primary DATABASE ALERT.LOG
Wed Jan 13 17:03:32 2010
ARCH: FAL archive failed. Archiver continuing
Wed Jan 13 17:03:32 2010
Errors in file e:*******bdumpyanz_arc0_2480.trc:
ORA-16055: FAL request rejected
Wed Jan 13 17:03:32 2010
ARCH: FAL archive failed. Archiver continuing
e:*******bdumpyanz_arc0_2480.trc:内容如下:
*** 2010-01-13 16:03:50.890
Redo shipping client performing standby login
*** 2010-01-13 16:03:52.031 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
Error 270 creating standby archive log file at host 'db_standby'
*** 2010-01-13 16:03:53.890 60680 kcrr.c
ARC2: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
*** 2010-01-13 16:03:53.906 60680 kcrr.c
ARC2: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
ORA-00270: error creating archive log
*** 2010-01-13 16:03:53.968 58942 kcrr.c
kcrrfail: dest:2 err:270 force:0 blast:1
kcrrwkx: unknown error:270
ORA-16055: FAL request rejected
kcrrwkx: work to do 0x2 (end)
FAL[server]: Selected inactive destination; resetting temporarily
STANDBY DATABASE ALERT.LOG:
Wed Jan 13 17:09:29 2010
Errors in file e:oracleproduct10.2.0adminstandbyudumpstandby_rfs_3420.trc:
ORA-00270: error creating archive log E:ORACLEPRODUCT10.2.0ADMINYANZARCHIVELOGARC00071_0704655138.001
ORA-19504: failed to create file "E:ORACLEPRODUCT10.2.0ADMINYANZARCHIVELOGARC00071_0704655138.001"
ORA-27056: could not delete file
OSD-04024: 无法删除文件。
O/S-Error: (OS 32) 另一个程序正在使用此文件,进程无法访问。
参数配置:
primary:
SQL> show parameter LOG_ARCHIVE_DEST_2;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=db_standby lgwr async
valid_for=(online_logfiles,pri
mary_role) db_unique_name=stan
dby
standby:
SQL> show parameter LOG_ARCHIVE_DEST_2;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=db_yanz lgwr async val
id_for=(online_logfiles,primar
y_role) db_unique_name=yanz
备库运行模式:
SQL> select database_role,db_unique_name,open_mode,protection_mode from v$database;
DATABASE_ROLE DB_UNIQUE_NAME OPEN_MODE PROTECTION_MODE
---------------- ------------------------------ ---------- --------------------
PHYSICAL STANDBY STANDBY MOUNTED MAXIMUM PERFORMANCE
请高手给分析一下,问题可能性出在那里?
最后
以上就是冷艳泥猴桃为你收集整理的oracle不能自动传归档,DATAGUARD归档无法传输的全部内容,希望文章能够帮你解决oracle不能自动传归档,DATAGUARD归档无法传输所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。
发表评论 取消回复