How Do I Place an Oracle Database Log File to a Self-Defined Directory?

1. Log in to the SUSE Linux operating system as the root user.
2. Change the owner directory of the self-defined directory (for example, /log/for/oracle/) to oracle. The self-defined directory must exist.
# chown -R oracle:dba /log/for/oracle/
3. Ensure that you can open the directory using the oracle account, and has read and write permissions. If not, run the following command:
# chmod 700 /log/for/oracle/
# chmod 755 /log/for/
# chmod 755 /log/
4. Switch to the oracle user and run the following commands in SQLPLUS:
# su - oracle
$ sqlplus / as sysdba
> alter system set log_archive_duplex_dest='/log/for/oracle/' scope=both;
5. Check the result.
> archive log listIf the Archive destination field displays as /log/for/oracle/, the setting is successful.