from-sh

2022-01-27 22:06:12.620 [EVMD(194602)]CRS-8500: Oracle Clusterware EVMD process is starting with operating system process ID 194602
2022-01-27 22:06:13.674 [GPNPD(194631)]CRS-8500: Oracle Clusterware GPNPD process is starting with operating system process ID 194631
2022-01-27 22:06:14.454 [GPNPD(194631)]CRS-2328: GPNPD started on node rac1. 
2022-01-27 22:06:14.747 [GIPCD(194701)]CRS-8500: Oracle Clusterware GIPCD process is starting with operating system process ID 194701
2022-01-27 22:06:18.650 [OSYSMOND(194733)]CRS-8500: Oracle Clusterware OSYSMOND process is starting with operating system process ID 194733
2022-01-27 22:06:18.631 [CSSDMONITOR(194731)]CRS-8500: Oracle Clusterware CSSDMONITOR process is starting with operating system process ID 194731
2022-01-27 22:06:19.246 [CSSDAGENT(194764)]CRS-8500: Oracle Clusterware CSSDAGENT process is starting with operating system process ID 194764
2022-01-27 22:06:19.863 [OCSSD(194781)]CRS-8500: Oracle Clusterware OCSSD process is starting with operating system process ID 194781
2022-01-27 22:06:20.976 [OCSSD(194781)]CRS-1713: CSSD daemon is started in hub mode
2022-01-27 22:06:26.984 [OCSSD(194781)]CRS-1707: Lease acquisition for node rac1 number 1 completed
2022-01-27 22:06:28.150 [OCSSD(194781)]CRS-1621: The IPMI configuration data for this node stored in the Oracle registry is incomplete; details at (:CSSNK00002:) in /oragrid/base/diag/crs/rac1/crs/trace/ocssd.trc
2022-01-27 22:06:28.150 [OCSSD(194781)]CRS-1617: The information required to do node kill for node rac1 is incomplete; details at (:CSSNM00004:) in /oragrid/base/diag/crs/rac1/crs/trace/ocssd.trc
2022-01-27 22:06:28.157 [OCSSD(194781)]CRS-1605: CSSD voting file is online: /dev/ASM/OCR; details in /oragrid/base/diag/crs/rac1/crs/trace/ocssd.trc.




2022-01-27 22:21:41.345 [EVMD(201322)]CRS-8500: Oracle Clusterware EVMD process is starting with operating system process ID 201322
2022-01-27 22:21:42.388 [GPNPD(201363)]CRS-8500: Oracle Clusterware GPNPD process is starting with operating system process ID 201363
2022-01-27 22:21:43.212 [GPNPD(201363)]CRS-2328: GPNPD started on node rac1. 
2022-01-27 22:21:43.488 [GIPCD(201443)]CRS-8500: Oracle Clusterware GIPCD process is starting with operating system process ID 201443
2022-01-27 22:21:47.762 [OSYSMOND(201485)]CRS-8500: Oracle Clusterware OSYSMOND process is starting with operating system process ID 201485
2022-01-27 22:21:47.730 [CSSDMONITOR(201483)]CRS-8500: Oracle Clusterware CSSDMONITOR process is starting with operating system process ID 201483
2022-01-27 22:21:48.309 [CSSDAGENT(201516)]CRS-8500: Oracle Clusterware CSSDAGENT process is starting with operating system process ID 201516
2022-01-27 22:21:48.947 [OCSSD(201533)]CRS-8500: Oracle Clusterware OCSSD process is starting with operating system process ID 201533
2022-01-27 22:21:50.088 [OCSSD(201533)]CRS-1713: CSSD daemon is started in hub mode
2022-01-27 22:21:56.129 [OCSSD(201533)]CRS-1707: Lease acquisition for node rac1 number 1 completed
2022-01-27 22:21:57.302 [OCSSD(201533)]CRS-1621: The IPMI configuration data for this node stored in the Oracle registry is incomplete; details at (:CSSNK00002:) in /oragrid/base/diag/crs/rac1/crs/trace/ocssd.trc
2022-01-27 22:21:57.303 [OCSSD(201533)]CRS-1617: The information required to do node kill for node rac1 is incomplete; details at (:CSSNM00004:) in /oragrid/base/diag/crs/rac1/crs/trace/ocssd.trc
2022-01-27 22:21:57.308 [OCSSD(201533)]CRS-1605: CSSD voting file is online: /dev/ASM/OCR; details in /oragrid/base/diag/crs/rac1/crs/trace/ocssd.trc.
2022-01-27 22:22:03.055 [OCSSD(201533)]CRS-1601: CSSD Reconfiguration complete. Active nodes are rac1 rac2 .
2022-01-27 22:22:04.606 [OCSSD(201533)]CRS-1720: Cluster Synchronization Services daemon (CSSD) is ready for operation.
2022-01-27 22:22:04.978 [OCTSSD(201744)]CRS-8500: Oracle Clusterware OCTSSD process is starting with operating system process ID 201744

-- 사전환경

--- IP

---/etc/hosts

--- 방화벽

--- group, user 생성

--- kernel setting

--- Disk Partition

-- Profile

-- GRID Install

12c OCR 39G 이상이어야함

SQL> select * from "BIN$1TRHJo4HnongU9MyEKxDHw==$0";

CUST NAME     CITY  ST
---- ------------------------------ -------------------- --
WILL BG SOFTWARE CO.     SEATTLE  WA
JANE ROCKY FLYER INC.     DENVER  CO

-- recyclebin 복구

SQL> flashback table tcustmer to before drop;
SQL> flashback table tcustmer to before drop rename to t1;
Flashback complete.

SQL> select * from tcustmer;

CUST NAME     CITY  ST
---- ------------------------------ -------------------- --
WILL BG SOFTWARE CO.     SEATTLE  WA
JANE ROCKY FLYER INC.     DENVER  CO

-- recyclebin 삭제

SQL> purge table "BIN$1TRHJo4KnongU9MyEKxDHw==$0";
Table purged.

SQL> select * from recyclebin;
no rows selected

./runInstaller -silent -force -showProgress -waitforcompletion -ignoreSysPrereqs -ignorePrereqFailure \
FROM_LOCATION=/stage/12.2.0.1.0/database/stage/products.xml \
oracle.install.option=INSTALL_DB_SWONLY \
UNIX_GROUP_NAME=dba \
ORACLE_HOME=/oracle/app/product/12.2.0.1 \
ORACLE_HOME_NAME="OraDb122_Home1" \
ORACLE_BASE=/oracle/app \
INVENTORY_LOCATION=/oracle/app/oraInventory
oracle.install.db.InstallEdition=EE \
oracle.install.db.isCustomInstall=false \
oracle.install.db.DBA_GROUP=dba \
oracle.install.db.OPER_GROUP=dba \
oracle.install.db.OSBACKUPDBA_GROUP=dba \
oracle.install.db.OSDGDBA_GROUP=dba \
oracle.install.db.OSKMDBA_GROUP=dba \
oracle.install.db.OSRACDBA_GROUP=dba \
DECLINE_SECURITY_UPDATES=true

* extract, replicat process DDL parameter 주석처리 or 삭제

$sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jan 13 02:42:06 2022
Version 19.13.0.0.0
Copyright (c) 1982, 2021, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.13.0.0.0

SQL> @ddl_disable
Trigger altered.

SQL> @ddl_remove
DDL replication removal script.
WARNING: this script removes all DDL replication objects and data.
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
Enter Oracle GoldenGate schema name:oggs
Working, please wait ...
Spooling to file ddl_remove_spool.txt
Script complete.

SQL> select object_name from all_objects where object_type='TABLE' and owner='OGGS';

OBJECT_NAME
--------------------------------------------------------------------------------
GGS_DDL_RULES
GGS_DDL_RULES_LOG
GGS_MARKER
GGS_STICK
GGS_TEMP_COLS
TCUSTMER
TCUSTORD
7 rows selected.

SQL> @marker_remove

SQL> @ddl_status
Please enter the name of a schema for the GoldenGate database objects:
oggs

GGSCI (single) 1> edit param ./GLOBALS
GGSCHEMA OGGS

SQL> select username, default_tablespace from dba_users where username='OGGS';
USERNAME
--------------------------------------------------------------------------------
DEFAULT_TABLESPACE
------------------------------
OGGS
OGG

SQL> select username from dba_users where default_tablespace='OGG'; -> tablespace를 다른 유저와 공유X
USERNAME
--------------------------------------------------------------------------------
OGGT
OGGS

- tablespace 변경

$sqlplus / as sysdba

SQL> @marker_setup
Marker setup script
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:oggs

Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGGS
MARKER TABLE
-------------------------------
OK
MARKER SEQUENCE
-------------------------------
OK
Script complete.

SQL> @ddl_setup
Oracle GoldenGate DDL Replication setup script
Verifying that current user has privileges to install DDL Replication...
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:oggs
Working, please wait ...
Spooling to file ddl_setup_spool.txt
Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...
Check complete.

Using OGGS as a Oracle GoldenGate schema name.
Working, please wait ...
DDL replication setup script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGGS

CLEAR_TRACE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
CREATE_TRACE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
TRACE_PUT_LINE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
INITIAL_SETUP STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDLVERSIONSPECIFIC PACKAGE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDLREPLICATION PACKAGE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDLREPLICATION PACKAGE BODY STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDL IGNORE TABLE
-----------------------------------
OK
DDL IGNORE LOG TABLE
-----------------------------------
OK
DDLAUX PACKAGE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDLAUX PACKAGE BODY STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
SYS.DDLCTXINFO PACKAGE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
SYS.DDLCTXINFO PACKAGE BODY STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDL HISTORY TABLE
-----------------------------------
OK
DDL HISTORY TABLE(1)
-----------------------------------
OK
DDL DUMP TABLES
-----------------------------------
OK
DDL DUMP COLUMNS
-----------------------------------
OK
DDL DUMP LOG GROUPS
-----------------------------------
OK
DDL DUMP PARTITIONS
-----------------------------------
OK
DDL DUMP PRIMARY KEYS
-----------------------------------
OK
DDL SEQUENCE
-----------------------------------
OK
GGS_TEMP_COLS
-----------------------------------
OK
GGS_TEMP_UK
-----------------------------------
OK
DDL TRIGGER CODE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDL TRIGGER INSTALL STATUS
-----------------------------------
OK
DDL TRIGGER RUNNING STATUS
------------------------------------------------------------------------------------------------------------------------
ENABLED
STAYMETADATA IN TRIGGER
------------------------------------------------------------------------------------------------------------------------
OFF
DDL TRIGGER SQL TRACING
------------------------------------------------------------------------------------------------------------------------
0
DDL TRIGGER TRACE LEVEL
------------------------------------------------------------------------------------------------------------------------
NONE
LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/oracle/base/product/19.3/rdbms/log/ggs_ddl_trace.log
Analyzing installation status...

VERSION OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054

STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components

Script complete.

SQL> @role_setup
GGS Role setup script
This script will drop and recreate the role GGS_GGSUSER_ROLE
To use a different role name, quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:oggs
Wrote file role_setup_set.txt
PL/SQL procedure successfully completed.
Role setup script complete
Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:
GRANT GGS_GGSUSER_ROLE TO <loggedUser>
where <loggedUser> is the user assigned to the GoldenGate processes.

SQL> GRANT GGS_GGSUSER_ROLE TO oggs;
Grant succeeded.

SQL> @ddl_enable
Trigger altered.

SQL> @ddl_status
Please enter the name of a schema for the GoldenGate database objects:
oggs
Setting schema name to OGGS

CLEAR_TRACE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
CREATE_TRACE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
TRACE_PUT_LINE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
INITIAL_SETUP STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDLVERSIONSPECIFIC PACKAGE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDLREPLICATION PACKAGE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDLREPLICATION PACKAGE BODY STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors

DDL IGNORE TABLE
-----------------------------------
OK
DDL IGNORE LOG TABLE
-----------------------------------
OK
DDLAUX PACKAGE STATUS:

Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDLAUX PACKAGE BODY STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
SYS.DDLCTXINFO PACKAGE STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
SYS.DDLCTXINFO PACKAGE BODY STATUS:
Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDL HISTORY TABLE
-----------------------------------
OK
DDL HISTORY TABLE(1)
-----------------------------------
OK
DDL DUMP TABLES
-----------------------------------
OK
DDL DUMP COLUMNS
-----------------------------------
OK
DDL DUMP LOG GROUPS
-----------------------------------
OK
DDL DUMP PARTITIONS
-----------------------------------
OK
DDL DUMP PRIMARY KEYS
-----------------------------------
OK
DDL SEQUENCE
-----------------------------------
OK
GGS_TEMP_COLS
-----------------------------------
OK
GGS_TEMP_UK
-----------------------------------
OK
DDL TRIGGER CODE STATUS:

Line/pos  Error
---------------------------------------- -----------------------------------------------------------------
No errors  No errors
DDL TRIGGER INSTALL STATUS
-----------------------------------
OK
DDL TRIGGER RUNNING STATUS
------------------------------------------------------------------------------------------------------------------------
ENABLED
STAYMETADATA IN TRIGGER
------------------------------------------------------------------------------------------------------------------------
OFF
DDL TRIGGER SQL TRACING
------------------------------------------------------------------------------------------------------------------------
0
DDL TRIGGER TRACE LEVEL
------------------------------------------------------------------------------------------------------------------------
NONE
LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/oracle/base/product/19.3/rdbms/log/ggs_ddl_trace.log
Analyzing installation status...
VERSION OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054
STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components

SQL>select object_name from all_objects where object_type='TABLE' and owner='OGGS' ->GGS_* table이 생성

OBJECT_NAME
------------------------------------------------------------------------------------------------------------------------
GGS_DDL_COLUMNS
GGS_DDL_HIST
GGS_DDL_HIST_ALT
GGS_DDL_LOG_GROUPS
GGS_DDL_OBJECTS
GGS_DDL_PARTITIONS
GGS_DDL_PRIMARY_KEYS
GGS_DDL_RULES
GGS_DDL_RULES_LOG
GGS_MARKER
GGS_SETUP
GGS_STICK
GGS_TEMP_COLS
GGS_TEMP_UK
TCUSTMER
TCUSTORD
16 rows selected.

GGSCI (single) 1> edit param ext01

--# DDL
DDL INCLUDE ALL
DDLOPTIONS REPORT

GGSCI (single) 2> add extract ext01, tranlog begin now
EXTRACT added.

GGSCI (single) 3> add exttrail ./dirdat/ea, extract ext01, megabytes 1024
EXTTRAIL added.

GGSCI (single) 4> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     STOPPED     EXT01       00:00:00      00:00:50    
EXTRACT     RUNNING     PMP01       00:00:00      00:00:00    
REPLICAT    ABENDED     REP01       00:00:00      29:05:35    

GGSCI (single) 5> start ext01
Sending START request to MANAGER ...
EXTRACT EXT01 starting

GGSCI (single) 6> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT01       00:00:55      00:00:01    
EXTRACT     RUNNING     PMP01       00:00:00      00:00:05    
REPLICAT    ABENDED     REP01       00:00:00      29:05:40    

GGSCI (single) 7> edit param rep01
--# DDL
DDL INCLUDE ALL
DDLOPTIONS REPORT

GGSCI (single) 8> start rep01
Sending START request to MANAGER ...
REPLICAT REP01 starting

GGSCI (single) 9> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT01       00:00:00      00:00:08    
EXTRACT     RUNNING     PMP01       00:00:00      00:00:01    
REPLICAT    RUNNING     REP01       00:00:00      00:00:02    

-- replicat process report 조회

2022-01-13 01:24:28  INFO    OGG-00487  DDL operation included [INCLUDE ALL], optype [CREATE], objtype [TABLE], objowner "OGGT", objname "TCUSTORD".
2022-01-13 01:24:28  INFO    OGG-00484  Executing DDL operation.
2022-01-13 01:24:28  INFO    OGG-00483  DDL operation successful.

-- Data insert