DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: arch....dbf files in $ORACLE_HOME/dbs

  1. #11
    Join Date
    Feb 2009
    Location
    Azerbaijan, Baku
    Posts
    24
    Change value of log_archive_dest_1 parameter to any correct value (directory) you want and archived redo logs will be created there as well

  2. #12
    Join Date
    Apr 2009
    Posts
    21
    Doesn't work:
    I add this in my init.ora file
    *.log_archive_dest_1='/u01/app/oracle/flash_recovery_area/ORCL/archivelog/'



    Enter user-name: sys as sysdba
    Enter password:
    Connected to an idle instance.

    SQL> create spfile from pfile;

    File created.

    SQL> startup
    ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed
    SQL> exit
    Disconnected

  3. #13
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    look in the documentation and see the correct format?

  4. #14
    Join Date
    Feb 2009
    Location
    Azerbaijan, Baku
    Posts
    24
    http://download.oracle.com/docs/cd/B...htm#sthref1068

    *.log_archive_dest_1='location=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/'

  5. #15
    Join Date
    Apr 2009
    Posts
    21
    Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width