Home > Database > Oracle > body text

How to modify the oracle archive path

WBOY
Release: 2022-05-25 18:30:41
Original
7813 people have browsed it

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.

How to modify the oracle archive path

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状态
Copy after login

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.

How to modify the oracle archive path

2. Modify to the specified path

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

Just modify the archive path directly

How to modify the oracle archive path

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template