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.
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!