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:\*******\bdump\yanz_arc0_2480.trc:
ORA-16055: FAL request rejected
Wed Jan 13 17:03:32 2010
ARCH: FAL archive failed. Archiver continuing
e:\*******\bdump\yanz_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:\oracle\product\10.2.0\admin\standby\udump\standby_rfs_3420.trc:
ORA-00270: error creating archive log E:\ORACLE\PRODUCT\10.2.0\ADMIN\YANZ\ARCHIVELOG\ARC00071_0704655138.001
ORA-19504: failed to create file "E:\ORACLE\PRODUCT\10.2.0\ADMIN\YANZ\ARCHIVELOG\ARC00071_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
请高手给分析一下,问题可能性出在那里?