关于oracle的物理dg,oracle 之物理DG 创造

最新推荐文章于 2023-05-04 16:38:14 发布
最新推荐文章于 2023-05-04 16:38:14 发布
阅读量92 收藏
点赞数
文章标签： 关于oracle的物理dg

[oracle@dg-one ~]$ rman target sys/root@dg1 auxiliary sys/root@dg2

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Apr 16 04:25:10 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DG (DBID=1756848898)

connected to auxiliary database: DG (not mounted)

RMAN> run{

2>  allocate channel ch1 type disk;

3>  allocate channel ch2 type disk;

4>  allocate channel ch3 type disk;

5>  allocate channel ch4 type disk;

6>  allocate channel ch5 type disk;

7>  allocate channel ch6 type disk;

8>  allocate channel ch7 type disk;

9>  allocate auxiliary channel ch8 type disk;

10>  duplicate target database for standby from active database nofilenamecheck

11>  spfile

12>    parameter_value_convert 'dg1','dg2'

13>    set db_unique_name='dg2'

14>    set db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

15>    set DB_RECOVERY_FILE_DEST_SIZE='4G'

16>    set control_files='/u01/app/oracle/oradata/dg/control01.ctl'

17>    set db_create_file_dest='/u01/app/oracle/oradata/dg'

18>    set db_create_online_log_dest_1='/u01/app/oracle/oradata/dg'

19>    set log_archive_max_processes='5'

20>    set fal_client='dg2'

21>    set fal_server='dg1'

22>    set standby_file_management='AUTO'

23>    set log_archive_config='dg_config=(dg1,dg2)'

24>    set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles)'

25>    set log_archive_dest_2='service=dg1 lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=dg1';

26>     sql channel ch6 "alter system set log_archive_max_processes=5";

27>     sql channel ch7 "alter system set fal_client=dg1";

28>     sql channel ch7 "alter system set fal_server=dg2";

29>     sql channel ch5 "alter system set standby_file_management=AUTO";

30>     sql channel ch6 "alter system set log_archive_config=''dg_config=(dg1,dg2)''";

31>     sql channel ch7 "alter system set log_archive_dest_2=''service=dg2 lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=dg2''";

32>     sql channel ch6 "alter system set log_archive_dest_1=''location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles)''";

33>     sql channel ch1 "alter system archive log current";

34>     sql channel ch8 "alter database recover managed standby database using current logfile disconnect from session";

35>  release channel ch1;

36>  release channel ch2;

37>  release channel ch3;

38>  release channel ch4;

39>  release channel ch5;

40>  release channel ch6;

41>  release channel ch7;

42>  release channel ch8;

43> }

using target database control file instead of recovery catalog

allocated channel: ch1

channel ch1: SID=48 device type=DISK

allocated channel: ch2

channel ch2: SID=44 device type=DISK

allocated channel: ch3

channel ch3: SID=47 device type=DISK

allocated channel: ch4

channel ch4: SID=46 device type=DISK

allocated channel: ch5

channel ch5: SID=45 device type=DISK

allocated channel: ch6

channel ch6: SID=39 device type=DISK

allocated channel: ch7

channel ch7: SID=35 device type=DISK

allocated channel: ch8

channel ch8: SID=20 device type=DISK

Starting Duplicate Db at 16-APR-14

contents of Memory Script:

{

backup as copy reuse

targetfile  '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwdg1' auxiliary format

'/u01/app/oracle/product/11.2.0/db_1/dbs/orapwdg2'   targetfile

'/u01/app/oracle/product/11.2.0/db_1/dbs/spfiledg1.ora' auxiliary format

'/u01/app/oracle/product/11.2.0/db_1/dbs/spfiledg2.ora'   ;

sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/db_1/dbs/spfiledg2.ora''";

}

executing Memory Script

Starting backup at 16-APR-14

Finished backup at 16-APR-14

sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/db_1/dbs/spfiledg2.ora''

contents of Memory Script:

{

sql clone "alter system set  core_dump_dest =

''/u01/app/oracle/diag/rdbms/dg/dg2/cdump'' comment=

'''' scope=spfile";

sql clone "alter system set  db_unique_name =

''dg2'' comment=

'''' scope=spfile";

sql clone "alter system set  db_recovery_file_dest =

''/u01/app/oracle/fast_recovery_area'' comment=

'''' scope=spfile";

sql clone "alter system set  DB_RECOVERY_FILE_DEST_SIZE =

4G comment=

'''' scope=spfile";

sql clone "alter system set  control_files =

''/u01/app/oracle/oradata/dg/control01.ctl'' comment=

'''' scope=spfile";

sql clone "alter system set  db_create_file_dest =

''/u01/app/oracle/oradata/dg'' comment=

'''' scope=spfile";

sql clone "alter system set  db_create_online_log_dest_1 =

''/u01/app/oracle/oradata/dg'' comment=

'''' scope=spfile";

sql clone "alter system set  log_archive_max_processes =

5 comment=

'''' scope=spfile";

sql clone "alter system set  fal_client =

''dg2'' comment=

'''' scope=spfile";

sql clone "alter system set  fal_server =

''dg1'' comment=

'''' scope=spfile";

sql clone "alter system set  standby_file_management =

''AUTO'' comment=

'''' scope=spfile";

sql clone "alter system set  log_archive_config =

''dg_config=(dg1,dg2)'' comment=

'''' scope=spfile";

sql clone "alter system set  log_archive_dest_1 =

''location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles)'' comment=

'''' scope=spfile";

sql clone "alter system set  log_archive_dest_2 =

''service=dg1 lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=dg1'' comment=

'''' scope=spfile";

shutdown clone immediate;

startup clone nomount;

}

executing Memory Script

sql statement: alter system set  core_dump_dest =  ''/u01/app/oracle/diag/rdbms/dg/dg2/cdump'' comment= '''' scope=spfile

sql statement: alter system set  db_unique_name =  ''dg2'' comment= '''' scope=spfile

sql statement: alter system set  db_recovery_file_dest =  ''/u01/app/oracle/fast_recovery_area'' comment= '''' scope=spfile

sql statement: alter system set  DB_RECOVERY_FILE_DEST_SIZE =  4G comment= '''' scope=spfile

sql statement: alter system set  control_files =  ''/u01/app/oracle/oradata/dg/control01.ctl'' comment= '''' scope=spfile

sql statement: alter system set  db_create_file_dest =  ''/u01/app/oracle/oradata/dg'' comment= '''' scope=spfile

sql statement: alter system set  db_create_online_log_dest_1 =  ''/u01/app/oracle/oradata/dg'' comment= '''' scope=spfile

sql statement: alter system set  log_archive_max_processes =  5 comment= '''' scope=spfile

sql statement: alter system set  fal_client =  ''dg2'' comment= '''' scope=spfile

sql statement: alter system set  fal_server =  ''dg1'' comment= '''' scope=spfile

sql statement: alter system set  standby_file_management =  ''AUTO'' comment= '''' scope=spfile

sql statement: alter system set  log_archive_config =  ''dg_config=(dg1,dg2)'' comment= '''' scope=spfile

sql statement: alter system set  log_archive_dest_1 =  ''location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles)'' comment= '''' scope=spfile

sql statement: alter system set  log_archive_dest_2 =  ''service=dg1 lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=dg1'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area     313159680 bytes

Fixed Size                     2252824 bytes

Variable Size                171970536 bytes

Database Buffers             134217728 bytes

Redo Buffers                   4718592 bytes

allocated channel: ch8

channel ch8: SID=19 device type=DISK

contents of Memory Script:

{

backup as copy current controlfile for standby auxiliary format  '/u01/app/oracle/oradata/dg/control01.ctl';

}

executing Memory Script

Starting backup at 16-APR-14

channel ch1: starting datafile copy

copying standby control file

output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_dg1.f tag=TAG20140416T042545 RECID=19 STAMP=845007946

channel ch1: datafile copy complete, elapsed time: 00:00:03

Finished backup at 16-APR-14

contents of Memory Script:

{

sql clone 'alter database mount standby database';

}

executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:

{

set newname for clone tempfile  1 to new;

switch clone tempfile all;

set newname for clone datafile  1 to new;

set newname for clone datafile  2 to new;

set newname for clone datafile  3 to new;

set newname for clone datafile  4 to new;

backup as copy reuse

datafile  1 auxiliary format new

datafile  2 auxiliary format new

datafile  3 auxiliary format new

datafile  4 auxiliary format new

;

sql 'alter system archive log current';

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_temp_%u_.tmp in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 16-APR-14

channel ch1: starting datafile copy

input datafile file number=00001 name=/u01/app/oracle/oradata/dg/system01.dbf

channel ch2: starting datafile copy

input datafile file number=00002 name=/u01/app/oracle/oradata/dg/sysaux01.dbf

channel ch3: starting datafile copy

input datafile file number=00003 name=/u01/app/oracle/oradata/dg/undotbs01.dbf

channel ch4: starting datafile copy

input datafile file number=00004 name=/u01/app/oracle/oradata/dg/users01.dbf

output file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_users_2ap5rj2m_.dbf tag=TAG20140416T042557

channel ch4: datafile copy complete, elapsed time: 00:00:07

output file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_undotbs1_29p5rj2m_.dbf tag=TAG20140416T042557

channel ch3: datafile copy complete, elapsed time: 00:00:45

output file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_sysaux_28p5rj2m_.dbf tag=TAG20140416T042557

channel ch2: datafile copy complete, elapsed time: 00:02:36

output file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_system_27p5rj2m_.dbf tag=TAG20140416T042557

channel ch1: datafile copy complete, elapsed time: 00:03:16

Finished backup at 16-APR-14

sql statement: alter system archive log current

contents of Memory Script:

{

switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=19 STAMP=845008154 file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_system_27p5rj2m_.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=20 STAMP=845008154 file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_sysaux_28p5rj2m_.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=21 STAMP=845008154 file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_undotbs1_29p5rj2m_.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=22 STAMP=845008154 file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_users_2ap5rj2m_.dbf

Finished Duplicate Db at 16-APR-14

sql statement: alter system set log_archive_max_processes=5

sql statement: alter system set fal_client=dg1

sql statement: alter system set fal_server=dg2

sql statement: alter system set standby_file_management=AUTO

sql statement: alter system set log_archive_config=''dg_config=(dg1,dg2)''

sql statement: alter system set log_archive_dest_2=''service=dg2 lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=dg2''

sql statement: alter system set log_archive_dest_1=''location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles)''

sql statement: alter system archive log current

sql statement: alter database recover managed standby database using current logfile disconnect from session

released channel: ch1

released channel: ch2

released channel: ch3

released channel: ch4

released channel: ch5

released channel: ch6

released channel: ch7

released channel: ch8

RMAN>

weixin_39955825
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle 11g DG 物理搭建 DG切换模式
qq_40195937的博客
11-10 1434
oracle 11g DG 物理搭建 DG切换模式
oracle dg物理和逻辑,Oracle DG介绍(物理无实例)
weixin_36215736的博客
04-15 1403
DG是dataguard，也叫standby，是oracle提供的一种容灾解决方案，只有企业版可用，标准版是不能用的，DG最多可以有一个主节点，9个DG是dataguard，也叫standby，是Oracle提供的一种容灾解决方案，只有企业版可用，标准版是不能用的，DG最多可以有一个主节点，9个从节点。可分为逻辑和物理两类，这里注意区分一下，逻辑的是通过redo转换成SQL语句，然后再standb...
Oracle DG物理备库转换为逻辑备库和快照备库
最新发布
loveLAxin的博客
05-04 775
将物理备用数据库转换为逻辑备用数据库或快照备用数据库，文章详细描述了两种DG类型数据库的概念、支持的数据类型、转换的操作步骤等，妥妥的保姆级教程！！！
关于oracle的物理dg,Oracle11g 创建物理DG/创建逻辑DG
weixin_39732491的博客
04-02 151
1.配置DG为物理standby主备配置LISTENER.ORA[oracle@primary admin]$ catlistener.ora# listener.ora Network Configuration File:/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora# Generated by Oracle con...
oracle 物理dg 逻辑dg,物理DG与逻辑DG的区别与逻辑DG同步异常处理方法
weixin_39559079的博客
04-11 507
一、物理DG与逻辑DG的区别官方文档是这样说明的The main difference between physical and logical standby databases is the mannerin which log apply services apply the archived redo logs:For physical standby databases, Data Gu...
完整的Oracle12C物理DG搭建.pdf
10-14
Oracle 12C 物理 DG 搭建 本文档旨在指导读者如何搭建一个完整的 Oracle 12C 物理 DG（Data Guard），从安装备库 Oracle 软件到配置 Oracle 用户的环境变量。下面是详细的知识点： 1. 安装备库 Oracle 软件 在...
Oracle11g搭建物理DG.docx|Oracle11g搭建物理DG.docx
11-11
在Oracle 11g中，物理DG是一种复制方法，通过实时地传输和应用生产数据库的日志到一个或多个备用数据库，使得备用数据库与主库保持几乎同步的状态。这样，当生产数据库遇到故障时，可以通过快速切换到备用数据库来...
oracle 19c DG
12-20
1、环境说明 ...hostname dg1 dg2 SID orcl orcl DB_UNQUE_NAME orcl_p orcl_s 数据库文件路劲 /u01/app/oracle/oradata /u01/app/oracle/oradata 归档文件路劲 /u01/archivelog /u01/archivelog_s
DAVE Oracle 使用ADG搭建物理DG
02-27
DAVE Oracle 使用ADG搭建物理DG
物理DG部署.pdf
10-24
Oracle DG搭建文档。
oracle 之物理DG 创建
Rhys learn oracle！
04-16 2036
今天是2014-04-16，继续完成DG的整理内容。该篇日志，将记录创建DG的所需参数简要介绍，和创建物理DG的过程。 第一：参数介绍： db_unique_name(db_name)：该参数指定数据库唯一名字，注意该参数将和log_archive_config存在关联，对于物理dg必须存有相同的db_name，对于逻辑DG必须 存有不同的db_name log_archive_config
Oracle在主库查备库的实例名,DataGuard中主备库db_unique_name不能一致
weixin_39979948的博客
04-14 1294
搭建dataguard主要是为了防止主库宕机后，备库能够切换为主库，但是当备库切换为主库后，那么客户端tns也需要面临着修改，如果客户端特别多，或者说有的应用已经嵌入了连接方式，这样去改特别繁琐。因此，能不能在DG备库切换为主库后，所有的客户端都不用更改任何配置而实现正常访问呢？ 答案是可以的。只需要修改备库的ip为主库ip。只是，这个要注意一些参数的设置：db_unique_name 一定不能一...
oracle standby特点,Oracle学习之DATAGUARD(三) 使用11gRMAN新特性搭建standby
weixin_30959723的博客
04-08 250
环境描述：有两台机器，11gdg1、11gdg2 。11gdg1上安装了数据库dgtst 。 11gdg2上只安装了Oracle软件，并没有安装数据库。以下描述如何在11gdg2上建立一个standby 数据库。一、 standby 数据库准备1.1 创建从库的静态监听。11gdg2->cat/u01/app/oracle/product/11.2.0/db_1/network/admi...
oracle 物理dg 逻辑dg,从物理DG到逻辑DG
weixin_29406875的博客
04-11 392
配置物理DataGuard到逻辑DataGuard环境：需要物理DataGuard作为基础，物理DataGuard的配置过程前面已经演练过1、执行DBMS_LOGSTDBY.BUILD过程，生成数据字典在执行该过程之前，要确保standby数据库停止了REDO应用STANDBY>alterdatabaserecovermanagedstandbydatabasecance...
ORACLE DG专题3--手把手部署DG 物理备库
本博客纯属个人学习记载，不对外负责，若有错误，请批评指正
09-17 2557
前言 笔者前文已介绍了ORACLE DG的成员身份与数据保护模式等相关理论知识，从本文开始，将进入ORACLE DG理论与实践相结合模式，深入理解ORACLE DG的内在原理与基本运维技能。本文讲述如何使用rman恢复方式搭建ORACLE DG物理备库—physical standby。 部署前规划 oracle DG要求主备数据库的DB_NAME相同，d...
oracle dg物理和逻辑,Oracle DG 物理Standby环境搭建
weixin_35531779的博客
04-15 171
Oracle Data Guard, 分逻辑Standby和物理Standby。 下面讲的是物理Standby环境的搭建步骤。一、启用Force Logging将Primary数据库置为Force Logging模式。通过下列语句：查看状态：SQL> SELECT DATABASE_ROLE,FORCE_LOGGING FROM V$DATABASE;DATABASE_ROLE FOR...
Oracle10g物理DG详细配置方法及步骤
数据库生态圈（RDB & NoSQL & Bigdata）——专注于关系库优化（Oracle&Mysql&PG&SQL Server ）
04-16 1642
好久不做具体安装、配置的事情，但最近因项目需要，整理了Oracle 10g物理DG配置实施的详细步骤，并在测试环境进行了测试，在此记录，以备自己和朋友今后参考使用。
oracle dg物理和逻辑,物理DG与逻辑DG的区别与逻辑DG同步异常处理方法-Oracle
weixin_33461476的博客
04-15 809
一、物理DG与逻辑DG的区别官方文档是这样说明的The main difference between physical and logical standby databases is the mannerin which log apply services apply the archived redo logs:For physical standby databases, Data Gu...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值