12c 传统数据库的ADG初体验

最新推荐文章于 2023-11-08 16:39:39 发布
最新推荐文章于 2023-11-08 16:39:39 发布
阅读量272 收藏
点赞数
文章标签： 数据库 网络 操作系统
实验环境
OS：oracle linux 6.6
DB：oracle 12.1.0.1
主库：chicago
备库：boston

主库操作

1. 主库数据库文件、控制文件、日志文件的规划

SYS@chicago >
select name from v$datafile
union
select name from v$controlfile
union
select member from v$logfile
union
select name from v$tempfile
union
select value from v$parameter where name='spfile';

NAME
--------------------------------------------------------------------------------
/home/oracle/dbfile/chicago/control01.ctl
/home/oracle/dbfile/chicago/control02.ctl
/home/oracle/dbfile/chicago/redo01.log
/home/oracle/dbfile/chicago/redo02.log
/home/oracle/dbfile/chicago/redo03.log
/home/oracle/dbfile/chicago/sysaux01.dbf
/home/oracle/dbfile/chicago/system01.dbf
/home/oracle/dbfile/chicago/temp01.dbf
/home/oracle/dbfile/chicago/undotbs01.dbf
/home/oracle/dbfile/chicago/users01.dbf
/u01/app/oracle/product/12.1.0.1/db_1/dbs/spfilechicago.ora

11 rows selected.


2. 主库现有3组redo，创建4组standby logfile group

[oracle@snow ~]$ sqlplus sys/oracle@chicago as sysdba

SYS@chicago > select group#,bytes/1024/1024 from v$log;

GROUP#     BYTES/1024/1024
---------- ---------------
1          50
2          50
3          50


SYS@chicago >
alter database add standby logfile group 4 ('/home/oracle/dbfile/chicago/redo04.log') size 50m;
alter database add standby logfile group 5 ('/home/oracle/dbfile/chicago/redo05.log') size 50m;
alter database add standby logfile group 6 ('/home/oracle/dbfile/chicago/redo06.log') size 50m;
alter database add standby logfile group 7 ('/home/oracle/dbfile/chicago/redo07.log') size 50m;

3. 主库设置foece logging 

SYS@chicago > alter database force logging;

SYS@chicago > shutdown immediate

4. 主库创建pfile

SYS@chicago > create pfile from spfile;
Segmentation fault (core dumped)   <== 没见过这个报错，重登录

[oracle@snow ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Tue Apr 21 13:03:43 2015

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

Connected to an idle instance.

SYS@chicago > create pfile from spfile;

File created.

SYS@chicago > exit

5. 向主库的pfile添加内容

[oracle@snow ~]$ cd $ORACLE_HOME/dbs
[oracle@snow dbs]$ vi initchicago.ora
*.audit_file_dest='/u01/app/oracle/admin/chicago/adump'
*.audit_trail='db'
*.compatible='12.1.0.0.0'
#DB_NAME=PROD1
#CONTROL_FILES='/arch1/PROD1/control1.ctl', '/arch2/PROD1/control2.ctl'
#LOG_ARCHIVE_MAX_PROCESSES=30
*.control_files='/home/oracle/dbfile/chicago/control01.ctl','/home/oracle/dbfile/chicago/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='chicago'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=chicagoXDB)'
*.log_archive_dest_1='LOCATION=/home/oracle/arch'
*.log_archive_format='%t_%s_%r.arc'
*.memory_target=1440m
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'

#for ADG
DB_UNIQUE_NAME=chicago
LOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)'
LOG_ARCHIVE_DEST_1=
'LOCATION=/home/oracle/arch
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=chicago'
LOG_ARCHIVE_DEST_2=
'SERVICE=boston ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=boston'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

FAL_SERVER=boston
FAL_CLIENT=chicago
DB_FILE_NAME_CONVERT='boston','chicago'
LOG_FILE_NAME_CONVERT='boston','chicago'
STANDBY_FILE_MANAGEMENT=AUTO

6. 复制主库的pfile文件，修改为备库的pfile

[oracle@snow dbs]$ cp initchicago.ora initboston.ora
[oracle@snow dbs]$ vi initboston.ora

*.audit_file_dest='/u01/app/oracle/admin/boston/adump'
*.audit_trail='db'
*.compatible='12.1.0.0.0'
*.control_files='/home/oracle/dbfile/boston/control01.ctl','/home/oracle/dbfile/boston/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='chicago'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=chicagoXDB)'
*.log_archive_dest_1='LOCATION=/home/oracle/arch'
*.log_archive_format='%t_%s_%r.arc'
*.memory_target=1440m
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'

#for ADG
DB_UNIQUE_NAME=boston
LOG_ARCHIVE_CONFIG='DG_CONFIG=(boston,chicago)'
LOG_ARCHIVE_DEST_1=
'LOCATION=/home/oracle/arch
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=boston'
LOG_ARCHIVE_DEST_2=
'SERVICE=boston ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=chicago'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

FAL_SERVER=chicago
FAL_CLIENT=boston
DB_FILE_NAME_CONVERT='chicago','boston'
LOG_FILE_NAME_CONVERT='chicago','boston'
STANDBY_FILE_MANAGEMENT=AUTO

7. 将备库的pfile文件scp到备库的/u01/app/oracle/product/12.1.0/db_1/dbs

[oracle@snow dbs]$ scp initboston.ora boston:/u01/app/oracle/product/12.1.0/db_1/dbs
oracle@boston's password:
initboston.ora 100% 1141 1.1KB/s 00:00

8. 复制主库的密码文件，修改为备库的密码文件并scp到备库的/u01/app/oracle/product/12.1.0/db_1/dbs

[oracle@snow dbs]$ cp orapwchicago orapwboston
[oracle@snow dbs]$ scp orapwboston boston:/u01/app/oracle/product/12.1.0/db_1/dbs
oracle@boston's password:
orapwboston 100% 7680 7.5KB/s 00:00


[oracle@snow dbs]$ cd $ORACLE_HOME/network/admin
[oracle@snow admin]$ vi tnsnames

9. 修改主库的$ORACLE_HOME/network/admin/tnsnames.ora

[oracle@snow admin]$ vi tnsnames.ora

chicago=
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.228.12)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = chicago)
 )
 )

boston=
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.228.13)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = boston)
 )
 )


备库操作
10. 创建备库所需目录

[oracle@boston ~]$ export ORACLE_SID=boston

[oracle@boston ~]$ mkdir -p $ORACLE_BASE/admin/boston/adump
[oracle@boston ~]$ mkdir -p dbfile/boston

11. 为备库创建静态监听，此步骤可以使用netmgr

[oracle@boston ~]$ vi $ORACLE_HOME/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
 (SID_LIST =
 (SID_DESC =
 (GLOBAL_DBNAME = boston)
 (ORACLE_HOME = /u01/app/oracle/product/12.1.0/db_1)
 (SID_NAME = boston)
 )
 )

LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = boston)(PORT = 1521))
 )
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
 )
 )

ADR_BASE_LISTENER = /u01/app/oracle

12. 修改备库tnsnames.ora

[oracle@boston ~]$ vi $ORACLE_HOME/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

BOSTON =
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.228.13)(PORT = 1521))
 )
 (CONNECT_DATA =
 (SERVICE_NAME = boston)
 )
 )

13. 备库reload监听器

[oracle@boston ~]$ lsnrctl
LSNRCTL> reload


主库操作

14. 主库从修改后的pfile创建spfile，启动实例。此时关于ADG的配置信息将随之实例的启动生效。

[oracle@snow ~]$ sqlplus sys/oracle@chicago as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Tue Apr 21 14:25:31 2015

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

Connected to an idle instance.

SYS@chicago > create spfile from pfile;

File created.

SYS@chicago > startup



备库操作
15. 备库从修改后的pfile创建spfile，启动实例到nomount状态。

[oracle@boston dbs]$ sqlplus sys/oracle@boston as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed May 6 13:03:06 2015

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

Connected to an idle instance.

SYS@boston > create spfile from pfile;

File created.

SYS@boston > startup nomount;
ORACLE instance started.

Total System Global Area 459304960 bytes
Fixed Size 2289544 bytes
Variable Size 381681784 bytes
Database Buffers 71303168 bytes
Redo Buffers 4030464 bytes
SYS@boston > exit

16. 使用rman duplicate来在线复制主库。rman部分输出比较多，命名语句使用高亮表标示，其它字体为屏幕输出。

[oracle@boston ~]$ rman target sys/oracle@chicago auxiliary sys/oracle@boston

Recovery Manager: Release 12.1.0.1.0 - Production on Wed May 6 13:05:12 2015

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

connected to target database: CHICAGO (DBID=1487327917)
connected to auxiliary database: CHICAGO (not mounted)

RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;

Starting Duplicate Db at 06-MAY-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=21 device type=DISK
current log archived

contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/12.1.0.1/db_1/dbs/orapwchicago' auxiliary format
'/u01/app/oracle/product/12.1.0/db_1/dbs/orapwboston' ;
}
executing Memory Script

Starting backup at 06-MAY-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
Finished backup at 06-MAY-15

contents of Memory Script:
{
restore clone from service 'chicago' standby controlfile;
}
executing Memory Script

Starting restore at 06-MAY-15
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service chicago
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/home/oracle/dbfile/boston/control01.ctl
output file name=/home/oracle/dbfile/boston/control02.ctl
Finished restore at 06-MAY-15

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 tempfile 1 to
"/home/oracle/dbfile/boston/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/home/oracle/dbfile/boston/system01.dbf";
set newname for datafile 3 to
"/home/oracle/dbfile/boston/sysaux01.dbf";
set newname for datafile 4 to
"/home/oracle/dbfile/boston/undotbs01.dbf";
set newname for datafile 6 to
"/home/oracle/dbfile/boston/users01.dbf";
restore
from service 'chicago' clone database
;
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /home/oracle/dbfile/boston/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 06-MAY-15
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service chicago
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /home/oracle/dbfile/boston/system01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service chicago
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /home/oracle/dbfile/boston/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service chicago
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /home/oracle/dbfile/boston/undotbs01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service chicago
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00006 to /home/oracle/dbfile/boston/users01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 06-MAY-15

sql statement: alter system archive log current
current log archived

contents of Memory Script:
{
restore clone force from service 'chicago'
archivelog from scn 1864000;
switch clone datafile all;
}
executing Memory Script

Starting restore at 06-MAY-15
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service chicago
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=11
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service chicago
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=12
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service chicago
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=13
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 06-MAY-15

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=878994450 file name=/home/oracle/dbfile/boston/system01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=878994450 file name=/home/oracle/dbfile/boston/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=878994450 file name=/home/oracle/dbfile/boston/undotbs01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=4 STAMP=878994450 file name=/home/oracle/dbfile/boston/users01.dbf

contents of Memory Script:
{
set until scn 1864100;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 06-MAY-15
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 11 is already on disk as file /home/oracle/arch/1_11_877609198.arc
archived log for thread 1 with sequence 12 is already on disk as file /home/oracle/arch/1_12_877609198.arc
archived log for thread 1 with sequence 13 is already on disk as file /home/oracle/arch/1_13_877609198.arc
archived log file name=/home/oracle/arch/1_11_877609198.arc thread=1 sequence=11
archived log file name=/home/oracle/arch/1_12_877609198.arc thread=1 sequence=12
archived log file name=/home/oracle/arch/1_13_877609198.arc thread=1 sequence=13
media recovery complete, elapsed time: 00:00:00
Finished recover at 06-MAY-15
Finished Duplicate Db at 06-MAY-15

17. duplicate结束后数据被启动到mount状态

[oracle@boston ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed May 6 13:08:43 2015

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SYS@boston > select open_mode,database_role from v$database;

OPEN_MODE            DATABASE_ROLE
-------------------- ----------------
MOUNTED              PHYSICAL STANDBY


18. 将数据库启动到read only

SYS@boston > ALTER DATABASE OPEN;

Database altered.

SYS@boston > select open_mode,database_role from v$database;

OPEN_MODE            DATABASE_ROLE
-------------------- ----------------
READ ONLY            PHYSICAL STANDBY


19. 开启redo apply，达到ADG的状态

SYS@boston > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING ARCHIVED LOGFILE DISCONNECT;

Database altered.

SYS@boston > select open_mode,database_role from v$database;

OPEN_MODE            DATABASE_ROLE
-------------------- ----------------
READ ONLY WITH APPLY PHYSICAL STANDBY


20. 查看备库复制后的文件规划
SYS@boston >
select name from v$datafile
union
select name from v$controlfile
union
select member from v$logfile
union
select name from v$tempfile
union
select value from v$parameter where name='spfile';

NAME
--------------------------------------------------------------------------------
/home/oracle/dbfile/boston/control01.ctl
/home/oracle/dbfile/boston/control02.ctl
/home/oracle/dbfile/boston/redo01.log
/home/oracle/dbfile/boston/redo02.log
/home/oracle/dbfile/boston/redo03.log
/home/oracle/dbfile/boston/redo04.log
/home/oracle/dbfile/boston/redo05.log
/home/oracle/dbfile/boston/redo06.log
/home/oracle/dbfile/boston/redo07.log
/home/oracle/dbfile/boston/sysaux01.dbf
/home/oracle/dbfile/boston/system01.dbf

NAME
--------------------------------------------------------------------------------
/home/oracle/dbfile/boston/temp01.dbf
/home/oracle/dbfile/boston/undotbs01.dbf
/home/oracle/dbfile/boston/users01.dbf
/u01/app/oracle/product/12.1.0/db_1/dbs/spfileboston.ora

15 rows selected.

全文完

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29047826/viewspace-1626404/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29047826/viewspace-1626404/

cuibaodun6837
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle12c+adg搭建完美手册
09-18
Oracle12c+adg搭建完美手册
Oracle ADG相关介绍
最新发布
不会编程的猫星人
02-26 1706
ADG原理、相关参数、增量修复
数据库之Oralce ADG 搭建使用（搭建流程、个人理解、出现问题、解决方案）
热门推荐
weixin_43901067的博客
04-24 1万+
前言 最近为了实现系统的高可用性，准备搭建oracle adg 主从实现技术，从最初连 shutdown immediate 是什么意思，mount、nomount是什么都不知道的情况下，历时5天终于初步搭建并实现了oracle adg技术并掌握了一些原理。是不是太菜？ /哭笑 免费是最贵的，这句话可能是真的。 搭建过程中不断的查询搜索引擎，总是会出现一模一样的抄袭文章，文章质量参差不齐，有些命令...
Oracle ADG的基本概念
数据源的港湾
11-08 1634
备库与主库相比，可能暂时落后，但当它再次变为可用时，备用数据库将自动同步，而不会丢失数据。由于同步重做传输，这种模式可潜在地影响响应时间和吞吐量。可以通过配置一个低延迟网络，并为它分配足够应用高峰事务负载的带宽来将这种影响减到最小。最大可用模式适用于想要在生产站点上出现严重中断时确保获得零数据丢失保护，但不想让生产数据库受网络/备用服务器故障影响的企业。为防止备库发生网络故障，最好设置reopen参数，即使出现网络故障，也不会引发主库挂起，这时主库将从最大可用模式切换到最大性能模式。
数据库学习整理
qq_45372365的博客
01-26 1940
数据库学习整理 Oracle数据库 oracle常用语句整理 资料：https://www.cnblogs.com/chinafine/articles/1755405.html 一、sql语句的三种类型 DML(操纵) insert update delete select DDL(定义) create alter drop DCL(控制) grant revoke commit rollback savepoint lock 查看表结构 --命令窗口查看表结构 describe employ
Oracle搭建rac-adg。详细教程-适合小白
qq_52860141的博客
08-21 1205
主库、备库、单实例adg存放目录以上便是我虚拟机以及共享磁盘存放目录。
《Oracle 12c数据库基础教程》教学课件—03Oracle数据库管理工具.pdf
06-22
《Oracle 12c数据库基础教程》教学课件—03Oracle数据库管理工具.pdf《Oracle 12c数据库基础教程》教学课件—03Oracle数据库管理工具.pdf《Oracle 12c数据库基础教程》教学课件—03Oracle数据库管理工具.pdf《Oracle...
oracle 12c 数据库 教程
11-06
（八）12c 审计的新特性 73 十、移动数据 76 （一）移动数据的整体架构 76 （二）目录对象 76 （三）使用 SQL*Loader 77 （四）数据泵 78 （五）外部表 80 十一、性能管理基础 82 （一）性能监视 82 （二）性能监视 ...
Oracle12c数据库基础教程Oracle12c数据库对象管理.pptx
11-12
Oracle12c数据库基础教程Oracle12c数据库对象管理.pptx
Oracle12c的数据库向11g导进的方法
09-10
主要介绍了 Oracle12c的数据库向11g导进的方法的相关资料,需要的朋友可以参考下
（绝对干货）Oracle ADG数据库完整部署、切换、备份、运维手册
09-11
阿里云上部署Oracle ADG，并且带有节点故障自动切换功能。同时，也包括数据库异常故障的处理，比如死锁、数据误删除进行恢复
Oracle ADG 数据库完整部署、切换、备份、运维手册(绝对干货)
03-08
Oracle ADG 数据库完整部署、切换、备份、运维手册(绝对干货)。 阿里云上部署Oracle ADG，并且带有节点故障自动切换功能。同时，也包括数据库异常故障的处理，比如死锁、数据误删除进行恢复 Oracle ADG DG Broker Linux
ADG的三种模式
weixin_72843193的博客
10-09 622
ADG(ACTIVE DATA GUARD)
Oracle数据库 ADG主备切换
qq_55914897的博客
10-10 991
Failover一般表示Primary数据库瘫痪或至少无法启动，这种转换已不能在Primary数据库上做任何操作，只要更改Standby数据库的角色为primary。如果此时在主库插入数据，然后手动切换log，会发现archive log会传至备库，但是未被应用。此时因为原来的主库已经切换到的备库，所以这个备库可以切换到主库了，状态为：TO PRIMARY。3）一般情況下，新的primary数据库配置后，要建立新的Standby数据库。主备切换完成，在新的主库做数据变更，在新的备库做数据校验，是否同步。
Oracle数据库管理每周一例-第十七期 ADG
yhw1809的博客
10-16 1356
Oracle数据库管理每周一例（12.2,18c,19c） 2020-10-16第十七期 ADG1.概念2.环境说明3.搭建流程-主库处理1.配置静态监听2.配置本地命名3.数据库参数配置4.生成pfile和密码文件4.搭建流程-备库处理1.创建目录并上传密码文件2.配置静态监听3.添加数据库服务4.修改参数文件5.搭建流程-创建DG/ADG1.复制数据库并正确启动备库2.创建dg broker配置3.配置ADG下期预告： 第十七期 ADG 中秋+国庆假期算是停更了两周，嘿嘿。结果祖国母亲生日+中秋那天我这
数据库管理-第八十期 Exadata to RAC(x86) ADG（20230605）
yhw1809的博客
06-05 906
由于下周休假出去旅游，应该是不能发文，所以本周准备了3篇文章，还有两篇是关于EMCC和其升级的内容。老规矩，知道写了些啥。
第一章 ADG基本知识
Natura_l的博客
05-06 5820
Oracle Data Guard 配置可以包含一个主数据库和多达 30 个目标。 备用数据库是主数据库的事务一致副本。 当主数据库是 CDB 时，代理配置中的所有备用数据库也必须是 CDB。 备用数据库的类型如下： 物理备用数据库 提供物理上相同的主数据库副本，其磁盘上的数据库结构与主数据库逐块相同。包括索引在内的数据库模式是相同的。物理备用数据库通过重做应用与主数据库保持同步，重做应用恢复从主数据库接收到的重做数据并将重做应用到物理备用数据库。 逻辑备用数据库 包含与生产数据库相同的逻辑信息，尽管数据.
ADG三种模式切换详解
Ruishine的博客
09-08 5830
AGD简介 Data Guard可以以只读的方式打开数据库，但此时Media Recovery利用日志进行数据同步的过程就停止了，如果物理备用数据库处于恢复的过程中数据库就不能打开查询，也就是说日志应用和只读打开两个状态是互斥的（10g之前）。 Oracle 11g 中推出的Active Data Guard功能解决了（10g物理DG）这个矛盾，在利用日志恢复数据的同时可以用只读的方式打开数据库，用户可以在备用数据库上进行查询、报表等操作，这类似逻辑Data Guard备用数据库的功能（查询功能方面），但是
oracle 12c rac 单机 adg 搭建
09-12
Oracle 12c RAC（Real Application Clusters）和单机ADG（Active Data Guard）是两个独立的功能，可以用于提高数据库的可用性和容灾能力。 在Oracle 12c中，RAC允许将多个数据库实例运行在一个共享存储环境中，这些...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值