开发者社区> snowofsummer> 正文

dbca 创建standby 数据库

简介: dbca -silent -createDuplicateDB
+关注继续查看

1,参考文档和手册

参考手册:

《Data Guard Concepts and Administration》
3.4 Using DBCA to Create a Data Guard Standby

《Database Administrator’s Guide》
2.3 Creating a Database with DBCA

The Database Configuration Assistant (DBCA) can also be used as a simple command-line method to create an Oracle Data Guard physical standby database.

非多租户的数据库环境,单实例环境。

The DBCA command qualifier used to create the physical standby database is createDuplicateDB .

DBCA can only be used to create standby databases for non-multitenant primary databases. In addition, this capability creates only single instance standby databases, not Oracle Real Application Clusters (Oracle RAC) databases. If required, the standby can then be converted to an Oracle RAC standby database, either manually or using Oracle Enterprise Manager Cloud Control

dbca -createDuplicateDB 
    -gdbName global_database_name 
    -primaryDBConnectionString easy_connect_string_to_primary
    -sid database_system_identifier
    [-createAsStandby 
        [-dbUniqueName db_unique_name_for_standby]]
    [-customScripts scripts_list]

创建备用数据库:

dbca –silent -createDuplicateDB -primaryDBConnectionString  myprimary.domain:1523/chicago.domain 
-gdbName chicago.domain -sid boston -initParams instance_name=boston –createAsStandby

Enter SYS user password:
Listener config step
33% complete
Auxiliary instance creation
66% complete
RMAN duplicate
100% complete
Look at the log file " /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/dbca/chicago/chicago.log" for further details.

2,实战操错练习

数据库版本

Release 12.2.0.1.0

主机环境设置

192.168.0.196 prod04 #primary db
192.168.0.197 prod05#standby db

主库sid:

[oracle@prod04 ~]$ ps -ef|grep pmon
oracle     6047      1  0 09:05 ?        00:00:02 ora_pmon_orcl
oracle    10361  10343  0 13:29 pts/0    00:00:00 grep --color=auto pmon

备库sid:

[oracle@prod05 ~]$ 
[oracle@prod05 ~]$ ps -ef|grep pmon
oracle     9800      1  0 11:07 ?        00:00:01 ora_pmon_sborcl
oracle    10492  10471  0 13:25 pts/2    00:00:00 grep --color=auto pmon

主备机需要配置tnsname.ora

[oracle@prod04 admin]$ cat tnsnames.ora 
orcl =
(DESCRIPTION =
    (ADDRESS_LIST =(ADDRESS=(PROTOCOL= TCP)(HOST=prod04)(PORT=1521)))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl))
)

sborcl =
(DESCRIPTION =
    (ADDRESS_LIST =(ADDRESS=(PROTOCOL = TCP)(HOST=prod05) (PORT=1521)))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = sborcl))
)

>主数据库要求:
打开数据库归档
非cdb模式数据库
打开监听
配置tnsname.ora.

>备机要求
配置tnsname.ora
执行dbca.(自动创建静态监听和启动监听程序)

[oracle@prod05 ~]$ dbca -silent -createDuplicateDB -primaryDBConnectionString 192.168.0.196:1521/orcl -gdbName orcl -sid sborcl -initParams instance_name=sborcl -createAsStandby
Enter SYS user password: 

Listener config step
33% complete
Auxiliary instance creation
66% complete
RMAN duplicate
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.

如果未配置tnsname.ora报错信息:

[oracle@prod05 ~]$ dbca -silent -createDuplicateDB -primaryDBConnectionString 192.168.0.196:1521/orcl -gdbName orcl -sid sborcl -initParams instance_name=sborcl -createAsStandby
Enter SYS user password: 

Listener config step
33% complete
Auxiliary instance creation
66% complete
RMAN duplicate
DBCA Operation failed.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.

删除数据库:
dbca -silent -deleteDatabase -sourceDB sborcl

3,光放参考文档:

Creating a Physical Standby database using DBCA duplicate (文档 ID 2283697.1)

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
数据库(Database
数据库(Database
13 0
Oracle如何修改数据库的DBID和DBNAME?
Oracle如何修改数据库的DBID和DBNAME?
51 0
利用nid修改数据库的DBID
oracle在恢复中常用到dbid,dbid的作用是什么,它和db_name是不是一一对应关系?
692 0
cdb 数据库搭建dataguard
cdb dataguard,cdb搭建dataguard,12c,18c
1468 0
RAC 数据库数据库恢复数据文件显示为0
RAC数据库异机恢复数据文件显示为0
1391 0
+关注
snowofsummer
文章
问答
视频
文章排行榜
最热
最新
相关电子书
更多
Oracle 数据库笔记
立即下载
PostgresChina2018_刘成伟_oracle到Postgres数据库迁移工具
立即下载
ORACLE 10g 数据库体系结构图
立即下载