开启归档修改归档日志路径

最新推荐文章于 2025-01-06 10:21:03 发布

柳暗发明君

最新推荐文章于 2025-01-06 10:21:03 发布

阅读量860

点赞数

分类专栏： oracle

oracle 专栏收录该内容

118 篇文章

订阅专栏

本文展示了如何通过SQL命令将Oracle数据库设置为归档模式，并配置归档日志的目标位置。文章详细记录了从关闭数据库、启动到挂载状态，再到更改系统参数并启用归档模式的全过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 2505338880 bytes
Fixed Size                  2230952 bytes
Variable Size            1392510296 bytes
Database Buffers         1090519040 bytes
Redo Buffers               20078592 bytes
Database mounted.
SQL> alter system set log_archive_dest_1='location=/data/arc' scope =both;

System altered.

SQL> alter database archivelog
2 ;

Database altered.

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.
SQL> SQL> SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 2505338880 bytes
Fixed Size                  2230952 bytes
Variable Size            1392510296 bytes
Database Buffers         1090519040 bytes
Redo Buffers               20078592 bytes

Database mounted.

Database opened.
SQL> SQL> SQL> SQL> SQL> SQL> SQL>
SQL>
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /data/arc
Oldest online log sequence     642
Next log sequence to archive   644
Current log sequence           644
SQL>