ORACLE 11GR2 RAC 开启归档和flashback

最新推荐文章于 2023-03-23 10:22:40 发布
最新推荐文章于 2023-03-23 10:22:40 发布
阅读量1.5k 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ljsjr/article/details/8827548
版权 
  开启归档和flashback，现在对于11g来说开启RAC和单实例没有什么差别，测试了这么的一个例子，
需求：把归档日志存放到ASM上，orcl1的归档存放在+DATA/ARC1下，orcl2的归档放到+DATA/ARC2下。
Flashbask area是需要单独的一个diskgroup，所以特地给他创建了个新的DG -- SHFLASH

一、under asm environment


[grid@node1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 9 15:06:35 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> CREATE DISKGROUP SHFLASH EXTERNAL REDUNDANCY DISK '/dev/raw/raw2';----此处也可用asmca图形化界面去创建
SQL> desc v$asm_diskgroup            
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP_NUMBER                                       NUMBER
 NAME                                               VARCHAR2(30)
 SECTOR_SIZE                                        NUMBER
 BLOCK_SIZE                                         NUMBER
 ALLOCATION_UNIT_SIZE                               NUMBER
 STATE                                              VARCHAR2(11)
 TYPE                                               VARCHAR2(6)
 TOTAL_MB                                           NUMBER
 FREE_MB                                            NUMBER
 HOT_USED_MB                                        NUMBER
 COLD_USED_MB                                       NUMBER
 REQUIRED_MIRROR_FREE_MB                            NUMBER
 USABLE_FILE_MB                                     NUMBER
 OFFLINE_DISKS                                      NUMBER
 COMPATIBILITY                                      VARCHAR2(60)
 DATABASE_COMPATIBILITY                             VARCHAR2(60)
 VOTING_FILES                                       VARCHAR2(1)

SQL> select  group_number,name from v$asm_diskgroup;

GROUP_NUMBER NAME
------------ ------------------------------
           1 DATA
           2 SHFLASH

SQL> alter diskgroup data add directory '+DATA/ARC1';

Diskgroup altered.

SQL>  alter diskgroup data add directory '+DATA/ARC2';

Diskgroup altered.

SQL> EXIT
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

二、under oracle environment
[grid@node1 ~]$ su - oracle
Password:
[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 9 15:15:38 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> alter system set log_archive_dest_1 ='location=+DATA/ARC1' scope=spfile sid='orcl1';

System altered.

SQL> alter system set log_archive_dest_1 ='location=+DATA/ARC2' scope=spfile sid='orcl2';

System altered.

SQL> show parameter db_recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +DATA
db_recovery_file_dest_size           big integer 3882M


SQL> alter system set  db_recovery_file_dest_size=2G scope=both sid='*';

System altered.

SQL> alter system set db_recovery_file_dest ='+SHFLASH' scope=both sid='*';

System altered.

SQL> show parameter db_flashback

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target        integer     1440


三、shutdown immediate instance in all nodes
on node1:
SQL> show user
USER is "SYS"
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> !     
[oracle@node1 ~]$ srvctl status database -d orcl
Instance orcl1 is not running on node node1
Instance orcl2 is running on node node2
on node2:

SQL> show user
USER is "SYS"
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

[oracle@node1 ~]$ export ORACLE_SID=orcl1
[oracle@node1 ~]$ srvctl status database -d orcl
Instance orcl1 is not running on node node1
Instance orcl2 is not running on node node2

四、startup mount one instance and enable ARCHIVELOG and FLASHBACK


[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 9 15:52:06 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1269366784 bytes
Fixed Size                  2212976 bytes
Variable Size             889195408 bytes
Database Buffers          369098752 bytes
Redo Buffers                8859648 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database flashback on;

Database altered.

SQL> desc v$database
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DBID                                               NUMBER
 NAME                                               VARCHAR2(9)
 CREATED                                            DATE
 RESETLOGS_CHANGE#                                  NUMBER
 RESETLOGS_TIME                                     DATE
 PRIOR_RESETLOGS_CHANGE#                            NUMBER
 PRIOR_RESETLOGS_TIME                               DATE
 LOG_MODE                                           VARCHAR2(12)
 CHECKPOINT_CHANGE#                                 NUMBER
 ARCHIVE_CHANGE#                                    NUMBER
 CONTROLFILE_TYPE                                   VARCHAR2(7)
 CONTROLFILE_CREATED                                DATE
 CONTROLFILE_SEQUENCE#                              NUMBER
 CONTROLFILE_CHANGE#                                NUMBER
 CONTROLFILE_TIME                                   DATE
 OPEN_RESETLOGS                                     VARCHAR2(11)
 VERSION_TIME                                       DATE
 OPEN_MODE                                          VARCHAR2(20)
 PROTECTION_MODE                                    VARCHAR2(20)
 PROTECTION_LEVEL                                   VARCHAR2(20)
 REMOTE_ARCHIVE                                     VARCHAR2(8)
 ACTIVATION#                                        NUMBER
 SWITCHOVER#                                        NUMBER
 DATABASE_ROLE                                      VARCHAR2(16)
 ARCHIVELOG_CHANGE#                                 NUMBER
 ARCHIVELOG_COMPRESSION                             VARCHAR2(8)
 SWITCHOVER_STATUS                                  VARCHAR2(20)
 DATAGUARD_BROKER                                   VARCHAR2(8)
 GUARD_STATUS                                       VARCHAR2(7)
 SUPPLEMENTAL_LOG_DATA_MIN                          VARCHAR2(8)
 SUPPLEMENTAL_LOG_DATA_PK                           VARCHAR2(3)
 SUPPLEMENTAL_LOG_DATA_UI                           VARCHAR2(3)
 FORCE_LOGGING                                      VARCHAR2(3)
 PLATFORM_ID                                        NUMBER
 PLATFORM_NAME                                      VARCHAR2(101)
 RECOVERY_TARGET_INCARNATION#                       NUMBER
 LAST_OPEN_INCARNATION#                             NUMBER
 CURRENT_SCN                                        NUMBER
 FLASHBACK_ON                                       VARCHAR2(18)
 SUPPLEMENTAL_LOG_DATA_FK                           VARCHAR2(3)
 SUPPLEMENTAL_LOG_DATA_ALL                          VARCHAR2(3)
 DB_UNIQUE_NAME                                     VARCHAR2(30)
 STANDBY_BECAME_PRIMARY_SCN                         NUMBER
 FS_FAILOVER_STATUS                                 VARCHAR2(22)
 FS_FAILOVER_CURRENT_TARGET                         VARCHAR2(30)
 FS_FAILOVER_THRESHOLD                              NUMBER
 FS_FAILOVER_OBSERVER_PRESENT                       VARCHAR2(7)
 FS_FAILOVER_OBSERVER_HOST                          VARCHAR2(512)
 CONTROLFILE_CONVERTED                              VARCHAR2(3)
 PRIMARY_DB_UNIQUE_NAME                             VARCHAR2(30)
 SUPPLEMENTAL_LOG_DATA_PL                           VARCHAR2(3)
 MIN_REQUIRED_CAPTURE_CHANGE#                       NUMBER

SQL> select  LOG_MODE , FLASHBACK_ON  from v$database;

LOG_MODE     FLASHBACK_ON
------------ ------------------
ARCHIVELOG   YES

SQL> alter database open
  2  ;

Database altered.

五、startup node2
[oracle@node2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 9 15:52:06 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup


六、test and verify

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 9 15:55:23 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DATA/arc1
Oldest online log sequence     15
Next log sequence to archive   16
Current log sequence           16
SQL> select status from gv$instance;

STATUS
------------
OPEN
OPEN

SQL> desc v$asm_diskgroup
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP_NUMBER                                       NUMBER
 NAME                                               VARCHAR2(30)
 SECTOR_SIZE                                        NUMBER
 BLOCK_SIZE                                         NUMBER
 ALLOCATION_UNIT_SIZE                               NUMBER
 STATE                                              VARCHAR2(11)
 TYPE                                               VARCHAR2(6)
 TOTAL_MB                                           NUMBER
 FREE_MB                                            NUMBER
 HOT_USED_MB                                        NUMBER
 COLD_USED_MB                                       NUMBER
 REQUIRED_MIRROR_FREE_MB                            NUMBER
 USABLE_FILE_MB                                     NUMBER
 OFFLINE_DISKS                                      NUMBER
 COMPATIBILITY                                      VARCHAR2(60)
 DATABASE_COMPATIBILITY                             VARCHAR2(60)
 VOTING_FILES                                       VARCHAR2(1)

SQL> select GROUP_NUMBER ,NAME  from v$asm_diskgroup;

GROUP_NUMBER NAME
------------ ------------------------------
           1 DATA
           2 SHFLASH

SQL> select name from v$datafile
  2  union all
  3  select name from v$controlfile
  4  union all
  5  select member from v$logfile;

NAME
--------------------------------------------------------------------------------
+DATA/orcl/datafile/system.256.811903481
+DATA/orcl/datafile/sysaux.257.811903483
+DATA/orcl/datafile/undotbs1.258.811903483
+DATA/orcl/datafile/users.259.811903483
+DATA/orcl/datafile/undotbs2.267.811903583
+DATA/orcl/controlfile/current.261.811903555
+DATA/orcl/controlfile/current.260.811903555
+DATA/orcl/onlinelog/group_2.264.811903559
+DATA/orcl/onlinelog/group_2.265.811903559
+DATA/orcl/onlinelog/group_1.262.811903559
+DATA/orcl/onlinelog/group_1.263.811903559

NAME
--------------------------------------------------------------------------------
+DATA/orcl/onlinelog/group_3.268.811903615
+DATA/orcl/onlinelog/group_3.269.811903617
+DATA/orcl/onlinelog/group_4.270.811903617
+DATA/orcl/onlinelog/group_4.271.811903617

15 rows selected.

[oracle@node2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 9 15:55:23 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DATA/arc2
Oldest online log sequence     15
Next log sequence to archive   16
Current log sequence           16

SQL> desc v$archived_log
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 RECID                                              NUMBER
 STAMP                                              NUMBER
 NAME                                               VARCHAR2(513)
 DEST_ID                                            NUMBER
 THREAD#                                            NUMBER
 SEQUENCE#                                          NUMBER
 RESETLOGS_CHANGE#                                  NUMBER
 RESETLOGS_TIME                                     DATE
 RESETLOGS_ID                                       NUMBER
 FIRST_CHANGE#                                      NUMBER
 FIRST_TIME                                         DATE
 NEXT_CHANGE#                                       NUMBER
 NEXT_TIME                                          DATE
 BLOCKS                                             NUMBER
 BLOCK_SIZE                                         NUMBER
 CREATOR                                            VARCHAR2(7)
 REGISTRAR                                          VARCHAR2(7)
 STANDBY_DEST                                       VARCHAR2(3)
 ARCHIVED                                           VARCHAR2(3)
 APPLIED                                            VARCHAR2(9)
 DELETED                                            VARCHAR2(3)
 STATUS                                             VARCHAR2(1)
 COMPLETION_TIME                                    DATE
 DICTIONARY_BEGIN                                   VARCHAR2(3)
 DICTIONARY_END                                     VARCHAR2(3)
 END_OF_REDO                                        VARCHAR2(3)
 BACKUP_COUNT                                       NUMBER
 ARCHIVAL_THREAD#                                   NUMBER
 ACTIVATION#                                        NUMBER
 IS_RECOVERY_DEST_FILE                              VARCHAR2(3)
 COMPRESSED                                         VARCHAR2(3)
 FAL                                                VARCHAR2(3)
 END_OF_REDO_TYPE                                   VARCHAR2(10)
 BACKED_BY_VSS                                      VARCHAR2(3)

SQL> alter system switch logfile;

System altered.

SQL> select THREAD# SEQUENCE# , ARCHIVED from v$archived_log;

 SEQUENCE# ARC
---------- ---
         2 YES
         1 YES
         1 YES
         1 YES
         1 YES
         2 YES
         1 YES
         1 YES
         2 YES
         2 YES
         2 YES

 SEQUENCE# ARC
---------- ---
         2 YES
         1 YES
         2 YES
         1 YES
         2 YES
         2 YES
         1 YES
         2 YES
         2 YES
         1 YES
         1 YES

 SEQUENCE# ARC
---------- ---
         1 YES
         1 YES
         1 YES

25 rows selected.

SQL> alter system switch logfile;

System altered.

SQL> select THREAD# SEQUENCE# , ARCHIVED from v$archived_log;

 SEQUENCE# ARC
---------- ---
         2 YES
         1 YES
         1 YES
         1 YES
         1 YES
         2 YES
         1 YES
         1 YES
         2 YES
         2 YES
         2 YES

 SEQUENCE# ARC
---------- ---
         2 YES
         1 YES
         2 YES
         1 YES
         2 YES
         2 YES
         1 YES
         2 YES
         2 YES
         1 YES
         1 YES

 SEQUENCE# ARC
---------- ---
         1 YES
         1 YES
         1 YES
         1 YES
         2 YES

27 rows selected.

SQL> select  LOG_MODE , FLASHBACK_ON  from v$database;

LOG_MODE     FLASHBACK_ON
------------ ------------------
ARCHIVELOG   YES

开启归档和flashback，现在对于11g来说开启RAC和单实例没有什么差别，测试了这么的一个例子，
需求：把归档日志存放到ASM上，orcl1的归档存放在+DATA/ARC1下，orcl2的归档放到+DATA/ARC2下。
Flashbask area是需要单独的一个diskgroup，所以特地给他创建了个新的DG -- SHFLASH
Joycesjr
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
11g R2 RAC 环境下开启归档模式的方法
db commando
08-30 1万+
方法一 首先来看一下官方的文档： How To Enable Archive Logging In RAC Environment [ID 1186764.1] 转到底部 修改时间:2011-6-2类型:HOWTO状态:PUBLISHED优先级:3 注释 (0) In this Document   Goal   Solution   References Applie
Oracle 11g RAC 开启、修改归档方法
onlyshenmin的博客
09-04 9444
目的：把归档模式打开并且将日志放在共享存储（ASM）上 环境信息：RHEL6U8，Oracle11gR2 主机名：rac1.onlymiss.cn,rac2.onlymiss.cn 实例名：racdb1,racdb2操作步骤：
单机RMAN删除归档日志出现RMAN-0813错误的原因
最新发布
XIANHUAFANG的博客
03-23 313
单机RMAN删除归档日志出现RMAN-0813错误的原因
DG环境RMAN删除归档报错RMAN-08137: archived log not deleted
yangjunfeng0604的博客
06-26 901
Oracle 12C DG环境，备库归档目录告警，查看crontab脚本，发现有删除操作，保持两天的，后手动执行，查看具体报错原因； RMAN> delete noprompt expired archivelog all; released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=540...
oracle flashback 功能,Oracle RAC环境下开启FLASHBACK闪回功能
weixin_39656174的博客
04-04 222
OracleRAC环境下开启FLASHBACK闪回功能环境配置参数如下：操作系统版本：Linux AS4.7操作系统内核版本：2.6.9-55.ElsmpOracle clusterware版本：10.2.0.4Oracle database版本：10.2.0.4存储介质：ASM+OCFS节点数：2个节点数据库名：gisdb实例名:gisdb1/gisdb2服务名：racgis[@more@]首先...
oracle-11Gr2-concepts
12-14
Oracle 11g R2 Concepts 是一套详细的官方文档，涵盖了Oracle数据库11g Release 2的核心概念和技术。这个文档集合是IT专业人士理解Oracle数据库体系结构、功能和操作的关键资源。以下是一些主要的知识点和重要概念：...
Oracle 11g 中文API Oracle Database Concepts 11gR2 中英文对照版
12-26
Oracle Database Concepts 11gR2 是Oracle公司发布的数据库管理系统的核心概念指南，它为理解Oracle 11g数据库的工作原理提供了全面的介绍。这个中英文对照版尤其适合中国用户，帮助他们在学习和使用Oracle数据库时...
oracle_11gR23
03-22
在高可用性方面，Oracle 11g R2引入了快速恢复区（Fast Recovery Area, FRA），可以集中管理数据库的备份、归档日志和还原文件，提高灾难恢复速度。此外，数据库镜像（Database Mirroring）和闪回技术（Flashback）...
11gR2官方中文文档-中英文对照
02-15
《11gR2官方中文文档-中英文对照》是一个重要的资源，对于深入理解Oracle数据库11g Release 2（11gR2）的技术细节和功能提供了宝贵的参考资料。这个文档集是双语的，既包含中文解释，也提供英文原文，方便不同语言...
oracle10gr2_data_guard.rar_data guard_oracle_oracle data guard
09-24
在Oracle 10g Release 2（10gR2）中，Data Guard的功能进一步增强，为管理员提供了更精细的控制和更高的数据安全性。 一、Data Guard基础概念 1. 主数据库（Primary Database）：正常运行并处理事务的数据库。 2. ...
Oracle RAC环境下开启FLASHBACK闪回功能.pdf
07-19
Oracle RAC环境下开启FLASHBACK闪回功能.pdf
oracle 11gR2 rac 改为归档模式
12-06
将oracle从非归档模式改为归档模式，支持在线备份。
ORACLE 11g RAC开启、修改归档方法
09-26
ORACLE 11g RAC数据库归档的启用、修改、配置的方法！
Oracle RAC环境下开启FLASHBACK闪回功能
cujielv6602的博客
07-19 350
Oracle RAC环境下开启FLASHBACK闪回功能本文PDF版下载 http://xunzhaoxz.itpub.net/resource/40016/29761作者：xunzhao【转载时请以超链接形式标明文章出处和作者...
ORA-00257: archiver error --11GR2 RAC 设置归档路径和开启flashback
weixin_33949359的博客
03-02 87
ORA-00257: archiver error --11GR2 RAC 设置归档路径和开启flashback [sql]view plaincopyprint? <wbr>开启归档和flashback，现在对于11g来说开启RAC和单实例没有什么差别，测试了这么的一个例子， 需求：把归档日志存放...
oracle数据库归档闪回,oracle 数据库archive归档及flashback 闪回
weixin_39850599的博客
04-08 362
数据库开归档理解几个参数:log_archive_dest_n和log_archive_dest不能共存1、log_archive_dest_n 需要加上location/service参数的，能实现归档到standby 数据库，实现 dataguard。2、log_archive_dest 与 log_archive_dest_n 及 USE_DB_RECOVERY_FILE_DEST 互斥，不...
Oracle数据库常用的查询和问题的解决方法
weixin_34273479的博客
08-14 835
2019独角兽企业重金招聘Python工程师标准>>> ...
ORACLE 11G flashback 相关讨论
十个传奇
03-21 545
一 flashback的相关类型 1.FLASHBACK QUERY  闪回查询：用到数据库的UNDO表空间，其特性有UNDO表空间的特性 2.FLASHBACK TABLE 闪回表：也是用到了UNDO表空间，其特性有UNDO表空间的特性 3.FLASHBACK DROP 闪回删除的表 4.FLASHBACK ARCHIVE 闪回归档 二
Windows_2008_r2_+_Oracle11gR2_RAC
12-21
Oracle 11gR2 RAC在Windows 2008 R2平台上引入了许多新特性，其中包括自动存储管理（ASM）和Oracle Clusterware的集成，以及单一客户端访问名称（SCAN）的引入。通过这些新特性，Oracle 11gR2 RAC在Windows 2008 R2...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值