设为首页 加入收藏

TOP

归档日志
2015-07-24 11:58:43 来源: 作者: 【 】 浏览:20
Tags:归档 日志

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;

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇Mybatis动态传表名(同样适用于动.. 下一篇数据库存储过程简介与实例

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·Error generating ar (2025-12-25 11:24:46)
·Http 和 Https的区别 (2025-12-25 11:24:44)
·python数据分析岗的 (2025-12-25 10:02:21)
·python做数据分析需 (2025-12-25 10:02:19)
·成为一个优秀的pytho (2025-12-25 10:02:16)