RAC下启动日志归档模式
来源:互联网 发布:淘宝买发票怎么搜 编辑:程序博客网 时间:2024/06/06 06:39
将数据库调整为archive模式
(0)查看当前数据库是否为归档模式
[oracle@node1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 17 02:08:05 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SYS@PROD1> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 21
Current log sequence 22
(1)将该实例的cluster_database设置为false:
[oracle@node1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 17 01:52:47 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SYS@PROD1> alter system set cluster_database=false scope=spfile sid=‘prod1';
System altered.
(2)关闭所有访问该数据库的实例:
[oracle@node1 ~]$ su - grid
[grid@node1 ~]$ srvctl stop database -d prod
(3)使用本地实例挂载数据库:
[grid@node1 ~]$ su - oracle
[oracle@node1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 17 02:04:50 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@PROD1> startup mount
ORACLE instance started.
Total System Global Area 1269366784 bytes
Fixed Size 2227984 bytes
Variable Size 838861040 bytes
Database Buffers 419430400 bytes
Redo Buffers 8847360 bytes
Database mounted.
(4)启动archive
SYS@PROD1> alter database archivelog;
Database altered.
(5)将实例prod1的参数cluster_database设为为true:
SYS@PROD1> alter system set cluster_database=true scope=spfile sid='prod1';
System altered.
(6) 关闭本地实例:
SYS@PROD1> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
(7) 启动所有实例
[grid@node1 ~]$ srvctl start database -d prod
(8) 查看启动归档日志后的结果
[oracle@node1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 17 02:08:05 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SYS@PROD1> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 21
Next log sequence to archive 22
Current log sequence 22
(8) 查看启动归档日志后的结果
[oracle@node1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 17 02:08:05 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SYS@PROD1> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 21
Next log sequence to archive 22
Current log sequence 22
0 0
- RAC下启动日志归档模式
- rac下启动关闭与更改归档模式
- RAC 环境下修改归档模式
- RAC 环境下修改归档模式
- RAC 环境下修改归档模式
- RAC启用归档日志
- 修改Orace RAC+ASM下归档日志路径
- Oracle Rac集群环境下删除归档日志
- Oracle Rac集群环境下删除归档日志
- oracle9i rac环境下如何更改归档模式
- RAC知识更新之-RAC下管理归档日志+修改VIP(摘自文平书)
- RAC环境中非归档改为归档模式
- 130531修改RAC归档模式
- ORACLE11g 更改RAC归档模式
- oracle rac启用归档模式
- RAC中如何备份归档日志
- 更改rac oracle归档日志路径
- oracle 11g rac 环境下 静态监听的配置 以及 归档日志备份
- 异常
- Gallery 实现图片逐一展示 和 显示当前图片张数
- UVA - 12470 Tribonacci 矩阵快速幂
- 真正的轻量级WebService框架——使用JAX-WS(JWS)发布WebService
- 明源售楼系统技术解析 销售控制(更名查询与变更查询)
- RAC下启动日志归档模式
- 某文件的权限为d-rw-_r--_r--,用数值形式表示该权限,则八进制数为644,文件属性为目录,为什么呢?(最近在复习linux,明天考试, 今天先总结下)
- [转发]霍夫变换直线检测的基本原理
- 用Python和Pygame写游戏-从入门到精通(3)
- 凯云水利水电工程造价管理系统 技术解析(七) 机械单价(二)
- 关于修改表结构
- hough变换是如何检测出直线和圆的
- Android AsyncTask详解
- hdu 5249 KPI 【二分查找】