12c-ADG-搭建.pdf
免费下载
Complete Data Guard Setup on Oracle 12
Forced Logging
On the Primary Database Side:
sqlplus "/ as sysdba"
SQL*Plus: Release 12.1.0.2.0 Production on Sun Jan 3 14:51:42 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> ALTER DATABASE FORCE LOGGING;
Database altered.
Check the password file
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SYSDG FALSE FALSE FALSE FALSE TRUE FALSE 0
SYSBACKUP FALSE FALSE FALSE TRUE FALSE FALSE 0
SYSKM FALSE FALSE FALSE FALSE FALSE TRUE 0
If the password doesn't exist, use the following command to create one:
$Orapwd file=orapwPOSITIVE password=<syspassword> force=y
SCP the password file to the standby server.
scp /u01/app/oracle/product/12.1.0.2/dbs/orapwPOSITIVE
standby:/u01/app/oracle/product/12.1.0.2/dbs/orapwSPOSITIVE
oracle@standby's password:
orapwPOSITIVE 100% 7680 7.5KB/s 00:00
Check
SPOSITIVE >ls -al /u01/app/oracle/product/12.1.0.2/dbs/orapwSPOSITIVE
-rw-r-----. 1 oracle oinstall 7680 Jan 3 14:58 /u01/app/oracle/product/12.1.0.2/dbs/orapwSPOSITIVE
Configure Standby Redo logs.
SQL> select bytes from v$log;
BYTES
----------
Page 1
Complete Data Guard Setup on Oracle 12
52428800
52428800
52428800
( so now we know what size to make the logs )
SQL> select group#, member from v$logfile;
GROUP# MEMBER
---------- ------------------------------------------------------------
3 /u01/app/oracle/oradata/POSITIVE/redo03.log
2 /u01/app/oracle/oradata/POSITIVE/redo02.log
1 /u01/app/oracle/oradata/POSITIVE/redo01.log
Oops my test groups only have one member each, that needs to be fixed! But we now know the SRL
should Group# 4, 5, 6 and 7.
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 '/u01/app/oracle/oradata/POSITIVE/redo04.log' SIZE 50M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 '/u01/app/oracle/oradata/POSITIVE/redo05.log' SIZE 50M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 '/u01/app/oracle/oradata/POSITIVE/redo06.log' SIZE 50M;
SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 '/u01/app/oracle/oradata/POSITIVE/redo07.log' SIZE 50M;
To verify the results of the standby redo log groups creation, run the following query:
SQL>select * from v$standby_log;
Primary Listener
# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0.2)
(PROGRAM = extproc)
)
(SID_DESC =
(global_dbname = POSITIVE_DGMGRL.primary)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0.2)
(sid_name = POSITIVE)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
INBOUND_CONNECT_TIMEOUT_LISTENER=120
Page 2
Complete Data Guard Setup on Oracle 12
Standby Listener
# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0.2)
(PROGRAM = extproc)
)
(SID_DESC =
(global_dbname = SPOSITIVE_DGMGRL.standby)
(ORACLE_HOME = /u01/app/oracle/product/12.1.0.2)
(sid_name = SPOSITIVE)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
INBOUND_CONNECT_TIMEOUT_LISTENER=120
Primary Tnsnames.ora
# tnsnames.ora Network Configuration File:
/u01/app/oracle/product/12.1.0.2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
POSITIVE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521))
(CONNECT_DATA =
(UR=A)
(SERVER = DEDICATED)
(SERVICE_NAME = POSITIVE)
)
)
RCATALOG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = RCATALOG)
)
)
SPOSITIVE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))
)
(CONNECT_DATA =
Page 3
Complete Data Guard Setup on Oracle 12
of 12
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
相关文档
评论