当前位置：首页 -> 基础 -> 数据库编程

Oracle12c Data Guard搭建手册(二)

2015-02-02 20:33:57 · 作者: · 浏览: 42
标签: Oracle12c Data Guard 搭建 手册
. SQL> select name,open_mode from v$pdbs; NAME OPEN_MODE ------------------------------ ---------- PDB$SEED READ ONLY PCNDBA READ WRITE

?

4 在主库添加 standby redo logfile

?

在Oracle 12c的架构里，online redo log 和控制文件是保存在CDB中的，PDB中只有运行需要的数据文件，所以我们这里加standby redo log，也是在CDB中加。

?

查看 Primary 库的 REDO 相关信息：

?

SQL> show con_name



CON_NAME

------------------------------

CDB$ROOT

SQL> select group#, members, bytes from v$log;



GROUP# MEMBERS BYTES

---------- ---------- ----------

1 2 52428800

2 2 52428800

3 2 52428800



SQL> select member from v$logfile;



MEMBER

-----------------------------------------------------------------------------------------

/home/ora12c/app/oracle/oradata/CNDBA/onlinelog/o1_mf_3_9y3rrb3v_.log

/home/ora12c/app/oracle/fast_recovery_area/CNDBA/onlinelog/o1_mf_3_9y3rrb9n_.log

/home/ora12c/app/oracle/oradata/CNDBA/onlinelog/o1_mf_2_9y3rr54v_.log

/home/ora12c/app/oracle/fast_recovery_area/CNDBA/onlinelog/o1_mf_2_9y3rr5b2_.log

/home/ora12c/app/oracle/oradata/CNDBA/onlinelog/o1_mf_1_9y3rqznr_.log

/home/ora12c/app/oracle/fast_recovery_area/CNDBA/onlinelog/o1_mf_1_9y3rr09s_.log

?

添加 4(3+1)个standby logfile：

SQL> alter database add standby logfile '/home/ora12c/app/oracle/oradata/CNDBA/onlinelog/stdredo01.log' size 50M;

Database altered.



SQL> alter database add standby logfile '/home/ora12c/app/oracle/oradata/CNDBA/onlinelog/stdredo02.log' size 50M;

Database altered.



SQL> alter database add standby logfile '/home/ora12c/app/oracle/oradata/CNDBA/onlinelog/stdredo03.log' size 50M;

Database altered.



SQL> alter database add standby logfile '/home/ora12c/app/oracle/oradata/CNDBA/onlinelog/stdredo04.log' size 50M;

Database altered.

5 分别在主备库配置监听并启动

--这里直接使用netmgr工具生成：注意静态监听注册中配置的pdb。

[ora12c@dave admin]$ cat listener.ora

# listener.ora Network Configuration File:/home/ora12c/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 = cndba)

(ORACLE_HOME = /home/ora12c/app/oracle/product/12.1.0/db_1)

(SID_NAME = cndba)

)

)



LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = dave)(PORT = 1521))

)

)



ADR_BASE_LISTENER = /home/ora12c/app/oracle



[ora12c@dave admin]$ lsnrctl reload



LSNRCTL for Linux: Version 12.1.0.1.0 -Production on 06-AUG-2014 19:26:50



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



Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

The command completed successfully

6 分别在主备库配置tnsnames.ora


[ora12c@dave admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /home/ora12c/app/oracle/product/12.1.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.



CNDBA_S =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.4)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = cndba)