6 Replies Latest reply: Apr 22, 2014 9:35 AM by user10341747 RSS

    Cannot  create standby log file

    GTS (DBA)

      Hi;

       

      Primary site : primary ( 192.168.1.105)

      Standby site : Standby ( 192.168.1.106)


      $ export ORACLE_SID=primary

      $ sqlplus / as sysdba

       

      SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 21 19:05:50 2014

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

      Connected to an idle instance.

       

      SQL> startup pfile='/u03/app/oracle/product/10.2.0/db_1/dbs/initprimary.ora' nomount;

      ORACLE instance started.

       

      Total System Global Area  838860800 bytes

      Fixed Size                  1222168 bytes

      Variable Size             213912040 bytes

      Database Buffers          620756992 bytes

      Redo Buffers                2969600 bytes


      SQL> alter database mount;

      Database altered.

       

      SQL> alter database open;

      Database altered.

       

      SQL> alter database add standby logfile group 3 '/u01/app/oracle/oradata/standby/log3a.log'

        2  size 10m;

      alter database add standby logfile group 3 '/u01/app/oracle/oradata/standby/log3a.log'

      * ERROR at line 1:

      ORA-00301: error in adding log file '/u01/app/oracle/oradata/standby/log3a.log'

      - file cannot be created

      ORA-27040: file create error, unable to create file

      Linux Error: 2: No such file or directory

       

      vi initprimary.ora

       

      db_name=primary

      sga_target=800m

      compatible=10.2.0

      control_files='/u03/app/oracle/oradata/primary/control01.ctl'

      background_dump_dest='/u03/app/oracle/admin/primary/bdump/'

      core_dump_dest='/u03/app/oracle/admin/primary/cdump/'

      user_dump_dest='/u03/app/oracle/admin/primary/udump/'

      db_unique_name=primary

      fal_server=standby

      fal_client=primary

      standby_file_management=auto

      remote_login_passwordfile='exclusive'

      db_file_name_convert='/u01/app/oracle/oradata/standby/','/u03/app/oracle/oradata/primary/'

      log_file_name_convert='/u01/app/oracle/oradata/standby/','/u03/app/oracle/oradata/primary/'

      log_archive_dest_1='location=/u01/archive/'

      log_archive_dest_2='service=standby'

      standby_archive_dest='/u01/standby/archive/'

      ~

       

      vi initstandby.ora

       

      db_name=primary

      sga_target=800m

      compatible=10.2.0

      control_files='/u01/app/oracle/oradata/standby/control01.ctl'

      background_dump_dest='/u01/app/oracle/admin/standby/bdump/'

      core_dump_dest='/u01/app/oracle/admin/standby/cdump/'

      user_dump_dest='/u01/app/oracle/admin/standby/udump/'

      db_unique_name=standby

      fal_server=primary

      fal_client=standby

      standby_file_management=auto

      remote_login_passwordfile='exclusive'

      db_file_name_convert='/u01/app/oracle/oradata/primary/','/u03/app/oracle/oradata/standby/'

      log_file_name_convert='/u01/app/oracle/oradata/primary/','/u03/app/oracle/oradata/standby/'

      log_archive_dest_1='/u01/standby/archive/'

      log_archive_dest_2='service=primary'

      standby_archive_dest='/u01/standby/archive/'