oracle日志不应用,dataguard中，在备库的日志不能被应用

这是主库的参数文件：

*.aq_tm_processes=1

*.background_dump_dest='/oracle/app/admin/ofdata/bdump'

*.compatible='9.2.0.0.0'

*.control_files='/database/oradata/ofdata/control01.ctl','/database/oradata/ofdata/control02.ctl','/database/oradata/ofdata/control03.ctl'

*.core_dump_dest='/oracle/app/admin/ofdata/cdump'

*.db_block_size=8192

*.db_cache_size=1073741824

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='ofdata'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=ofdataXDB)'

*.fast_start_mttr_target=300

*.hash_join_enabled=TRUE

*.instance_name='ofdata'

*.java_pool_size=33554432

*.job_queue_processes=10

*.large_pool_size=83886080

*.open_cursors=300

*.pga_aggregate_target=104857600

*.processes=250

*.query_rewrite_enabled='FALSE'

*.remote_login_passwordfile='EXCLUSIVE'

*.shared_pool_size=318767104

*.sort_area_size=524288

*.star_transformation_enabled='FALSE'

*.timed_statistics=TRUE

*.undo_management='AUTO'

*.undo_retention=10800

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/oracle/app/admin/ofdata/udump'

*.log_archive_dest_1='LOCATION=/rmantest/archivelog'

*.log_archive_dest_2='SERVICE=oftest REOPEN=300'

*.log_archive_dest_state_2='ENABLE'

*.log_archive_dest_state_1='ENABLE'

*.log_archive_format='%t_%s.dbf'

*.log_archive_start=true

*.remote_archive_enable=true

~

~

这是备库的参数文件：

*.aq_tm_processes=1

*.background_dump_dest='/oracle/app/admin/ofdata/bdump'

*.compatible='9.2.0.0.0'

*.control_files='/database/oradata/ofdata/control01.ctl','/database/oradata/ofdata/control02.ctl','/database/oradata/ofdata/control03.ctl'

*.core_dump_dest='/oracle/app/admin/ofdata/cdump'

*.db_block_size=8192

*.db_cache_size=1073741824

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='ofdata'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=ofdataXDB)'

*.fast_start_mttr_target=300

*.hash_join_enabled=TRUE

*.instance_name='ofdata'

*.java_pool_size=33554432

*.job_queue_processes=10

*.large_pool_size=83886080

*.open_cursors=300

*.pga_aggregate_target=104857600

*.processes=250

*.query_rewrite_enabled='FALSE'

*.remote_login_passwordfile='EXCLUSIVE'

*.shared_pool_size=318767104

*.sort_area_size=524288

*.star_transformation_enabled='FALSE'

*.timed_statistics=TRUE

*.undo_management='AUTO'

*.undo_retention=10800

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/oracle/app/admin/ofdata/udump'

*.log_archive_dest_1='LOCATION=/archivelog'

*.log_archive_dest_state_1='ENABLE'

*.log_archive_format='%t_%s.dbf'

*.log_archive_start=true

*.standby_archive_dest='/archivelog'

*.standby_file_management=auto

*.fal_server=ofdata

*.fal_client=oftest

*.remote_archive_enable=true

备库做好了，在主库切换日志，归档日志也可以传到备库。但是，备库不能应用归档日志：

SQL> select sequence#,applied from v$archived_log;

SEQUENCE# APP

---------- ---

1347 YES

1346 YES

1348 YES

1349 NO

1350 NO

1351 NO

1352 NO

1353 NO

不知道为什么？还有*.fal_server=ofdata，*.fal_client=oftest。其中，ofdata是主库的服务名，oftest是备库的服务名。不知道这样

对不对？

还有，我手动归档，有下列错误？

SQL>  recover managed standby database;

ORA-00283: recovery session canceled due to errors

ORA-01111: name for data file 32 is unknown - rename to correct file

ORA-01110: data file 32: '/oracle/app/product/9.2.0/dbs/UNNAMED00032'

ORA-01157: cannot identify/lock data file 32 - see DBWR trace file

ORA-01111: name for data file 32 is unknown - rename to correct file

ORA-01110: data file 32: '/oracle/app/product/9.2.0/dbs/UNNAMED00032'

这是备库的alert中的日志：

Thu Jul 10 09:06:27 2008

ALTER DATABASE RECOVER  managed standby database

Media Recovery Start: Managed Standby Recovery

Media Recovery failed with error 1111

ORA-283 signalled during: ALTER DATABASE RECOVER  managed standby database  ...

Thu Jul 10 09:07:41 2008

Restarting dead background process QMN0

QMN0 started with pid=15

不知道怎样解决？

[本帖最后由 congya 于 2008-7-10 09:12 编辑]