support/notes
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
notes/tiddlywiki/Dataguard CDB 12.1 exemple.txt
Valeriu PLESNILA 26296b6d6a 2026-03-12 21:01:38
2026-03-12 22:01:38 +01:00

244 lines
8.8 KiB
Plaintext
Executable File
Raw Permalink Blame History

~~ creation of CDB database
$ORACLE_HOME/bin/dbca \
-silent \
-createDatabase \
-templateName General_Purpose.dbc \
-gdbName EWOK \
-sid EWOKPRD \
-initParams db_unique_name=EWOKPRD \
-characterSet AL32UTF8 \
-sysPassword secret \
-systemPassword secret \
-emConfiguration NONE \
-createAsContainerDatabase TRUE \
-storageType ASM \
-diskGroupName DATA \
-redoLogFileSize 100 \
-sampleSchema FALSE \
-totalMemory 2048 \
-databaseConfType RAC \
-nodelist vortex-db01,vortex-db02
~~ identify the spfile and passwordfile ASM location and more readable aliases
srvctl config database -d EWOKPRD
ASMCMD [+] > cd +DATA/EWOKPRD/
ASMCMD [+DATA/EWOKPRD] > mkalias +DATA/EWOKPRD/PARAMETERFILE/spfile.333.957718565 spfileewokprd.ora
ASMCMD [+DATA/EWOKPRD] > mkalias +DATA/EWOKPRD/PASSWORD/pwdewokprd.308.957717627 orapwewokprd
~~ update spfile location in the CRS
srvctl modify database -db EWOKPRD -spfile +DATA/EWOKPRD/spfileewokprd.ora
srvctl modify database -db EWOKPRD -pwfile +DATA/EWOKPRD/orapwewokprd
srvctl stop database -d EWOKPRD
srvctl start database -d EWOKPRD
srvctl status database -d EWOKPRD -v
~~ enable ARCHIVELG mode and FORCE LOGGING on the PRIMARY database
alter system set db_recovery_file_dest_size = 4G scope=both sid='*';
alter system set db_recovery_file_dest = '+RECO' scope=both sid='*';
alter system set log_archive_dest_1 = 'location=USE_DB_RECOVERY_FILE_DEST' scope=both sid='*';
srvctl stop database -d EWOKPRD
startup mount exclusive
alter database archivelog;
alter database open;
alter database force logging;
srvctl stop database -d EWOKPRD
srvctl start database -d EWOKPRD
alter system archive log current;
~~ copy pfile and passwordfile from primary cluster to first node of the stabdby cluster
SQL> create pfile='/tmp/pfile_EWOK.ora' from spfile;
asmcmd cp +DATA/EWOKPRD/orapwewokprd /tmp
cd /tmp
scp orapwewokprd pfile_EWOK.ora kessel-db01/tmp
~~ make adjustements in pfile and put all in $ORACLE_HOME/dbs
SQL> create spfile from pfile='/tmp/standby.ora';
cp orapwewokprd $ORACLE_HOME/dbs/orapwEWOKDRP1
SQL> startup nomount
~~ NETWORK configuration - listeners
~~ in my confoguration I have a dedicated listener for DATAGUARD; following definitions has been added on primary cluster:
# For DATAGUARD...
SID_LIST_LISTENER_DG =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = EWOKPRD_DGMGRL)
(SID_NAME = EWOKPRD1)
(ORACLE_HOME = /app/oracle/product/12.1/db_1)
)
)
# ...For DATAGUARD
~~ and on standby cluster:
# For DATAGUARD...
SID_LIST_LISTENER_DG =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = EWOKDRP_DGMGRL)
(SID_NAME = EWOKDRP1)
(ORACLE_HOME = /app/oracle/product/12.1/db_1)
)
)
# ...For DATAGUARD
~~ cross connection tests; we should be able to connect to iddle instances too
sqlplus /nolog
connect sys/secret@vortex-db01-dba-vip:1541/EWOKPRD_DGMGRL as sysdba
connect sys/secret@vortex-db02-dba-vip:1541/EWOKPRD_DGMGRL as sysdba
connect sys/secret@kessel-db01-dba-vip:1541/EWOKDRP_DGMGRL as sysdba
(for the moment the standby pfile/passwordfile are not deployed on second node of the standby cluster)
~~ aliases to add on tnsnames.ora on all primary/standby database nodes
# For DATAGUARD...
EWOKPRD_DG =
(DESCRIPTION =
(FAILOVER = YES)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vortex-db01-dba-vip)(PORT = 1541))
(ADDRESS = (PROTOCOL = TCP)(HOST = vortex-db02-dba-vip)(PORT = 1541))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EWOKPRD_DGMGRL)
)
)
EWOKDRP_DG =
(DESCRIPTION =
(FAILOVER = YES)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kessel-db01-dba-vip)(PORT = 1541))
(ADDRESS = (PROTOCOL = TCP)(HOST = kessel-db02-dba-vip)(PORT = 1541))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EWOKDRP_DGMGRL)
)
)
# ...For DATAGUARD
~~ cross connexion test using TNS aliases; we should be able to connect to iddle instances
sqlplus /nolog
connect sys/secret@EWOKPRD_DG as sysdba
connect sys/secret@EWOKDRP_DG as sysdba
~~ from the spfile of primary DB we create an spfile for the secondary DB and we start thesecondary DB in nomount
rman target sys/secret@EWOKPRD_DG auxiliary sys/secret@EWOKDRP_DG
run {
allocate channel pri1 device type DISK;
allocate channel pri2 device type DISK;
allocate auxiliary channel aux1 device type DISK;
allocate auxiliary channel aux2 device type DISK;
duplicate target database
for standby
from active database
nofilenamecheck
using compressed backupset section size 1G;
}
~~ Dataguard Broker configuration
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~ on primary database
alter system set dg_broker_start=FALSE scope=both sid='*';
alter system set dg_broker_config_file1='+DATA/EWOKPRD/dr1EWOKPRD.dat' scope=both sid='*';
alter system set dg_broker_config_file2='+DATA/EWOKPRD/dr2EWOKPRD.dat' scope=both sid='*';
alter system set dg_broker_start=TRUE scope=both sid='*';
~~ on secondary database
alter system set dg_broker_start=FALSE scope=both sid='*';
alter system set dg_broker_config_file1='+DATA/EWOKDRP/dr1EWOKDRP.dat' scope=both sid='*';
alter system set dg_broker_config_file2='+DATA/EWOKDRP/dr2EWOKFRP.dat' scope=both sid='*';
alter system set dg_broker_start=TRUE scope=both sid='*';
~~ creation of STANDBY REDELOG on both databases
ALTER DATABASE ADD STANDBY LOGFILE thread 1 size 100M;
ALTER DATABASE ADD STANDBY LOGFILE thread 1 size 100M;
ALTER DATABASE ADD STANDBY LOGFILE thread 1 size 100M;
ALTER DATABASE ADD STANDBY LOGFILE thread 2 size 100M;
ALTER DATABASE ADD STANDBY LOGFILE thread 2 size 100M;
ALTER DATABASE ADD STANDBY LOGFILE thread 2 size 100M;
select GROUP#,THREAD#,STATUS, BYTES from v$standby_log;
col MEMBER for a60
select * from v$logfile;
~~ create DGMGRL configuration
dgmgrl
DGMGRL> connect sys/secret@EWOKPRD_DG
DGMGRL> create configuration EWOK as
primary database is EWOKPRD
connect identifier is EWOKPRD_DG;
DGMGRL> add database EWOKDRP
as connect identifier is EWOKDRP_DG
maintained as physical;
DGMGRL> edit database 'ewokdrp' set property ArchiveLagTarget=0;
DGMGRL> edit database 'ewokdrp' set property LogArchiveMaxProcesses=2;
DGMGRL> edit database 'ewokdrp' set property LogArchiveMinSucceedDest=1;
DGMGRL> edit database 'ewokdrp' set property StandbyFileManagement='AUTO';
DGMGRL> edit database 'ewokdrp' set property set property TransportDisconnectedThreshold='0';
DGMGRL> edit database 'ewokprd' set property ArchiveLagTarget=0;
DGMGRL> edit database 'ewokprd' set property LogArchiveMaxProcesses=2;
DGMGRL> edit database 'ewokprd' set property LogArchiveMinSucceedDest=1;
DGMGRL> edit database 'ewokprd' set property StandbyFileManagement='AUTO';
DGMGRL> edit database 'ewokprd' set property set property TransportDisconnectedThreshold='0';
DGMGRL> enable configuration;
DGMGRL> show configuration;
~~ VERY IMPORANT
~~ set StaticConnectIdentifier for all PRIMARY/DATAGUARD database instances
~~ use complete DESCRIPTION syntax to uniquely identifiing the instances of each node
EDIT INSTANCE 'EWOKPRD1' SET PROPERTY 'StaticConnectIdentifier'='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vortex-db01-dba-vip)(PORT=1541))(CONNECT_DATA=(SERVICE_NAME=EWOKPRD_DGMGRL)(INSTANCE_NAME=EWOKPRD1)(SERVER=DEDICATED)))';
EDIT INSTANCE 'EWOKPRD2' SET PROPERTY 'StaticConnectIdentifier'='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vortex-db02-dba-vip)(PORT=1541))(CONNECT_DATA=(SERVICE_NAME=EWOKPRD_DGMGRL)(INSTANCE_NAME=EWOKPRD2)(SERVER=DEDICATED)))';
EDIT INSTANCE 'EWOKDRP1' SET PROPERTY 'StaticConnectIdentifier'='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kessel-db01-dba-vip)(PORT=1541))(CONNECT_DATA=(SERVICE_NAME=EWOKDRP_DGMGRL)(INSTANCE_NAME=EWOKDRP1)(SERVER=DEDICATED)))';
EDIT INSTANCE 'EWOKDRP2' SET PROPERTY 'StaticConnectIdentifier'='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kessel-db02-dba-vip)(PORT=1541))(CONNECT_DATA=(SERVICE_NAME=EWOKDRP_DGMGRL)(INSTANCE_NAME=EWOKDRP2)(SERVER=DEDICATED)))';
~~ move spfile from file system to ASM
create pfile='/tmp/pfile_EWOKDRP.ora' from spfile;
create spfile ='+DATA/ewokdrp/spfileEWOKDRP.ora' from pfile='/tmp/pfile_EWOKDRP.ora';
~~ register standby database in the CRS
srvctl add database -d EWOKDRP -o /app/oracle/product/12.1/db_1 -c RAC -p '+DATA/EWOKDRP/spfileEWOKDRP.ora' -r physical_standby -n EWOK
~~ pay attention to -s <start_options>; the default value is OPEN, that means that your DATAGUARD will be OPENED (active DATAGUARD)
srvctl add instance -d EWOKDRP -i EWOKDRP1 -n kessel-db01
srvctl add instance -d EWOKDRP -i EWOKDRP2 -n kessel-db02
srvctl start database -d EWOKDRP -o mount
srvctl status database -d EWOKDRP -v
~~ finally, move passwordfile to ASM using pwcopy under asmcmd
asmcmd pwcopy +DATA/EWOKPRD/orapwewokprd /tmp/orapwewokprd
scp /tmp/orapwewokprd kessel-db01:/tmp/orapwewokprd
asmcmd pwcopy /tmp/orapwewokprd +DATA/EWOKDRP/orapwewokdrp
Reference in New Issue View Git Blame Copy Permalink