How to modify the oracle archive path

Modification method: 1. Use "startup mount;" to start the database to the mount state; 2. Use the "alter system set log_archive_dest_1='location=archive path after change';" statement to modify the archive path to the specified Path is enough.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to modify the oracle archive path

1. Oracle needs to be started in the mount state

    mkdir -p /data/arch     ---要修改的归档路径
    archive log list;            ---查看oracle归档
    shutdowm immediate;
    startup mount;            ---oracle需要 启动到mount状态

STARTUP NOMOUNT option: (Read the initialization parameter file and start the instance )

STARTUP NOMOUNT option starts the instance but does not install the database. When the database is started in this mode, the parameter file is read; background processes and memory structures are started; but they are not attached to or communicate with the database's disk structures. While the instance is in this state, the database is unavailable.

2. Modify to the specified path

    alter database archivelog;
    alter system set log_archive_dest_1='location=/data/arch';   ---归档路径修改为 指定路径
    alter database open;

Just modify the archive path directly

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to modify the oracle archive path. For more information, please follow other related articles on the PHP Chinese website!