DG主备库归档文件名受各自log_archive_format参数影响
来源:互联网 发布:矩阵音箱的连接方法 编辑:程序博客网 时间:2024/06/05 02:53
证明DG主备库归档文件名受各自log_archive_format参数影响
DG1 主库,DG2备库。
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string arc_%t_%s_%r.arctest
BYS@dg2>show parameter log_archive_format
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string arc_%t_%s_%r.arc
[oracle@dg1 archivelog]$ ls
arc_1_45_821829622.arc arc_1_47_821829622.arctest
arc_1_46_821829622.arc arc_1_48_821829622.arctest
2.在备库上查看,47 48号归档是备库的
日志
Thu Aug 08 15:15:48 2013
Archived Log entry 33 added for thread 1 sequence 47 ID 0x676c9833 dest 1:
Thu Aug 08 15:15:50 2013
Media Recovery Log /u01/archivelog/arc_1_47_821829622.arc
Media Recovery Waiting for thread 1 sequence 48 (in transit)
Changing standby controlfile to MAXIMUM AVAILABILITY level
Thu Aug 08 15:15:51 2013
Archived Log entry 34 added for thread 1 sequence 48 ID 0x676c9833 dest 1:
RFS[5]: Selected log 4 for thread 1 sequence 49 dbid 1735160627 branch 821829622
Media Recovery Log /u01/archivelog/arc_1_48_821829622.arc
Media Recovery Waiting for thread 1 sequence 49 (in transit)
[oracle@dg2 archivelog]$ ls
arc_1_45_821829622.arc arc_1_47_821829622.arc
arc_1_46_821829622.arc arc_1_48_821829622.arc
BYS@dg1>select protection_mode,database_role,protection_level from v$database;
PROTECTION_MODE DATABASE_ROLE PROTECTION_LEVEL
-------------------- ---------------- --------------------
MAXIMUM PERFORMANCE PRIMARY MAXIMUM PERFORMANCE
BYS@dg1>alter system switch logfile;
SYS@dg2>select protection_mode,database_role,protection_level from v$database;
PROTECTION_MODE DATABASE_ROLE PROTECTION_LEVEL
-------------------- ---------------- --------------------
查看归档文件,主、备库格式不同
[oracle@dg1 archivelog]$ ls
arc_1_45_821829622.arc arc_1_50_821829622.arctest
arc_1_46_821829622.arc arc_1_51_821829622.arctest
arc_1_47_821829622.arctest arc_1_52_821829622.arctest
arc_1_48_821829622.arctest arc_1_53_821829622.arctest
arc_1_49_821829622.arctest
[oracle@dg2 ~]$ ls /u01/archivelog/
arc_1_45_821829622.arc arc_1_50_821829622.arc
arc_1_46_821829622.arc arc_1_51_821829622.arc
arc_1_47_821829622.arc arc_1_52_821829622.arc
arc_1_48_821829622.arc arc_1_53_821829622.arc
arc_1_49_821829622.arc
Thu Aug 08 15:51:47 2013
RFS[2]: Assigned to RFS process 3732
RFS[2]: Identified database type as 'physical standby': Client is ARCH pid 3915
RFS[2]: Selected log 4 for thread 1 sequence 53 dbid 1735160627 branch 821829622
Thu Aug 08 15:51:47 2013
Archived Log entry 39 added for thread 1 sequence 53 ID 0x676c9833 dest 1:
Thu Aug 08 15:51:55 2013
Thu Aug 08 15:51:55 2013
Media Recovery Log /u01/archivelog/arc_1_53_821829622.arc
Media Recovery Waiting for thread 1 sequence 54
DG1 主库,DG2备库。
一、DG正常运行在最大可用模式。
使用的是alter database recover managed standby database disconnect from session;进行恢复
BYS@dg1>show parameter log_archive_formatNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string arc_%t_%s_%r.arctest
BYS@dg2>show parameter log_archive_format
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string arc_%t_%s_%r.arc
1.在主库上进行归档,产生的归档文件如下:
45、46号归档是未改变 主库 log_archive_format之前生成的归档。[oracle@dg1 archivelog]$ ls
arc_1_45_821829622.arc arc_1_47_821829622.arctest
arc_1_46_821829622.arc arc_1_48_821829622.arctest
2.在备库上查看,47 48号归档是备库的
日志Thu Aug 08 15:15:48 2013
Archived Log entry 33 added for thread 1 sequence 47 ID 0x676c9833 dest 1:
Thu Aug 08 15:15:50 2013
Media Recovery Log /u01/archivelog/arc_1_47_821829622.arc
Media Recovery Waiting for thread 1 sequence 48 (in transit)
Changing standby controlfile to MAXIMUM AVAILABILITY level
Thu Aug 08 15:15:51 2013
Archived Log entry 34 added for thread 1 sequence 48 ID 0x676c9833 dest 1:
RFS[5]: Selected log 4 for thread 1 sequence 49 dbid 1735160627 branch 821829622
Media Recovery Log /u01/archivelog/arc_1_48_821829622.arc
Media Recovery Waiting for thread 1 sequence 49 (in transit)
[oracle@dg2 archivelog]$ ls
arc_1_45_821829622.arc arc_1_47_821829622.arc
arc_1_46_821829622.arc arc_1_48_821829622.arc
二、在最大性能模式下也是这样DG:主备库归档文件名受各自log_archive_format参数影响:
使用的是alter database recover managed standby database disconnect from session;进行恢复BYS@dg1>select protection_mode,database_role,protection_level from v$database;
PROTECTION_MODE DATABASE_ROLE PROTECTION_LEVEL
-------------------- ---------------- --------------------
MAXIMUM PERFORMANCE PRIMARY MAXIMUM PERFORMANCE
BYS@dg1>alter system switch logfile;
SYS@dg2>select protection_mode,database_role,protection_level from v$database;
PROTECTION_MODE DATABASE_ROLE PROTECTION_LEVEL
-------------------- ---------------- --------------------
MAXIMUM PERFORMANCE PHYSICAL STANDBY MAXIMUM PERFORMANCE
查看归档文件,主、备库格式不同
[oracle@dg1 archivelog]$ lsarc_1_45_821829622.arc arc_1_50_821829622.arctest
arc_1_46_821829622.arc arc_1_51_821829622.arctest
arc_1_47_821829622.arctest arc_1_52_821829622.arctest
arc_1_48_821829622.arctest arc_1_53_821829622.arctest
arc_1_49_821829622.arctest
[oracle@dg2 ~]$ ls /u01/archivelog/
arc_1_45_821829622.arc arc_1_50_821829622.arc
arc_1_46_821829622.arc arc_1_51_821829622.arc
arc_1_47_821829622.arc arc_1_52_821829622.arc
arc_1_48_821829622.arc arc_1_53_821829622.arc
arc_1_49_821829622.arc
日志:
[oracle@dg2 ~]$ cat alert_dg.logThu Aug 08 15:51:47 2013
RFS[2]: Assigned to RFS process 3732
RFS[2]: Identified database type as 'physical standby': Client is ARCH pid 3915
RFS[2]: Selected log 4 for thread 1 sequence 53 dbid 1735160627 branch 821829622
Thu Aug 08 15:51:47 2013
Archived Log entry 39 added for thread 1 sequence 53 ID 0x676c9833 dest 1:
Thu Aug 08 15:51:55 2013
Thu Aug 08 15:51:55 2013
Media Recovery Log /u01/archivelog/arc_1_53_821829622.arc
Media Recovery Waiting for thread 1 sequence 54
- DG主备库归档文件名受各自log_archive_format参数影响
- 测试log_archive_dest_1与log_archive_format对生成的归档文件名的影响
- Oracle log_archive_format 参数
- dg(dg相关数据库参数)
- 实验DG 跳归档恢复
- dg log_archive_file_dest参数
- oracle dg相关参数
- DG检测归档是否传输到备库
- dg 备库归档位置不一致
- Oracle DG 相关参数解释
- oracle11R2 log_archive_format
- oracle11R2 log_archive_format
- DG丢失归档,使用增量备份恢复一例
- oracle DG 归档设置验证出现的问题
- DG有归档无备份时的数据文件恢复
- Oracle Data Guard (RAC+DG) 归档删除策略及脚本
- Oracle Data Guard(RAC+DG)归档删除策略
- DG备库磁盘空间满导致无法创建归档
- linux网关掉电后/var 的文件系统错误处理
- 如何让ActiveXObject( "Microsoft.XmlDom ")对象在非IE浏览器下显示数据?firefox(火狐)
- cocos2d-x 中实现蒙板效果(新手引导常用)
- 测试
- ajax动态加载的图标
- DG主备库归档文件名受各自log_archive_format参数影响
- 关于怎么修改供应商状态的函数说明
- 迅雷笔试题的josephus问题实现
- C#3.0新特性(二)- 初始值设定项
- hdu 1031 水题
- Android system 分区讲解
- Python常用函数
- ※数据结构※→☆线性表结构(queue)☆============优先队列 顺序存储结构(queue priority sequence)(十一)
- MySql连接数据库简单示例