归档日志

最新推荐文章于 2025-08-23 23:16:00 发布

jenya007

最新推荐文章于 2025-08-23 23:16:00 发布

阅读量726

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签： 11g application database dba oracle

本文链接：https://blog.youkuaiyun.com/jenya007/article/details/40298913

Oracle 专栏收录该内容

227 篇文章

订阅专栏

本文详细介绍如何在Oracle RAC及非RAC环境中配置归档日志模式，包括设置归档格式、启动归档功能、指定归档路径等关键步骤。

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

RAC
sqlplus / as sysdba
SQL> alter system set cluster_database=false scope=spfile; --in node1
SQL> create pfile='/opt/oracle/pfile_20120301' from spfile; --in node1
SQL> alter system set log_archive_format='ora11g_%r_%t_%s.log' scope=spfile; --in node1, using default value is ok
SQL> alter system set log_archive_start=TRUE scope=spfile; --in node1
SQL> alter system set log_archive_dest='' scope=spfile; --in node1
SQL> alter system set log_archive_dest_1='LOCATION=/oracle/ora_arch' scope=spfile; --in node1 using the specificated DIR
SQL> shutdown immediate; --two nodes
SQL> startup mount; --in node1
SQL> alter database archivelog; --in node1
SQL> alter database open; --in node1
SQL> alter system set cluster_database=true scope=spfile; --in node1
SQL> shutdown immediate; --in node1
SQL> startup; --in two nodes

NORAC
sqlplus / as sysdba
SQL> create pfile='/opt/oracle/pfile_20120301' from spfile;
SQL> alter system set log_archive_format='ora11g_%r_%t_%s.log' scope=spfile; --using default value is ok
SQL> alter system set log_archive_start=TRUE scope=spfile;
SQL> alter system set log_archive_dest='' scope=spfile;
SQL> alter system set log_archive_dest_1='LOCATION=/oracle/ora_arch' scope=spfile; --using the specificated DIR
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list;