9 Replies Latest reply: Dec 6, 2008 11:09 AM by 674289 RSS

    ORA-02778: Name given for the log directory is invalid

    user522961
      Hi,
      I'm creating standby instance for my dataguard project but when creating :
      SQL> STARTUP MOUNT PFILE='C:\oracle\product\10.2.0\db_1\dbs\initSTANDBY.ora';
      ORA-02778: Name given for the log directory is invalid
      SQL> startup mount
      ORA-02778: Name given for the log directory is invalid

      But the folder for logs is correct in my PFILE.

      Here is my PFILE :
      STANDBY.__db_cache_size=88080384
      STANDBY.__java_pool_size=4194304
      STANDBY.__large_pool_size=4194304
      STANDBY.__shared_pool_size=67108864
      STANDBY.__streams_pool_size=0
      *.audit_file_dest='C:\oracle\product\10.2.0/admin/STANDBY/adump'
      *.background_dump_dest='C:\oracle\product\10.2.0/admin/STANDBY/bdump'
      *.compatible='10.2.0.1.0'
      *.control_files='C:\oracle\product\10.2.0\oradata\STANDBY\control01.ctl','C:\oracle\product\10.2.0\oradata\STANDBY\control02.ctl','C:\oracle\product\10.2.0\oradata\STANDBY\control03.ctl'
      *.core_dump_dest='C:\oracle\product\10.2.0/admin/STANDBY/cdump'
      *.db_block_size=8192
      *.db_domain=''
      *.db_file_multiblock_read_count=16
      *.db_file_name_convert='PROD','STANDBY'
      *.db_name='PROD'
      *.db_recovery_file_dest='C:\oracle\product\10.2.0/flash_recovery_area'
      *.db_recovery_file_dest_size=2147483648
      *.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODXDB)'
      *.fal_client='STANDBY'
      *.fal_server='PROD'
      *.job_queue_processes=10
      *.log_archive_config='DG_CONFIG=(PROD,STANDBY)'
      *.log_archive_dest_1='LOCATION=C:\oracle\product\10.2.0\oradata\STANDBY\arch
      VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD'
      *.log_archive_dest_2='SERVICE=standby LGWR ASYNC
      VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
      DB_UNIQUE_NAME=standby'
      *.log_archive_dest_state_1='ENABLE'
      *.log_archive_dest_state_2='ENABLE'
      *.log_archive_format='%t_%s_%r.arc'
      *.log_archive_max_processes=30
      *.log_file_name_convert='C:\oracle\product\10.2.0\oradata\PROD','C:\oracle\product\10.2.0\oradata\STANDBY'
      *.open_cursors=300
      *.pga_aggregate_target=16777216
      *.processes=150
      *.remote_login_passwordfile='EXCLUSIVE'
      *.sga_target=167772160
      *.standby_file_management='AUTO'
      *.undo_management='AUTO'
      *.undo_tablespace='UNDOTBS1'
      *.user_dump_dest='C:\oracle\product\10.2.0/admin/STANDBY/udump'


      What migt be the error ?

      Many thanks.