Re: 오늘의 마지막 문제1번과 2번. (이수자 평가 제출물 7번과 8번)

[21기_이풍혁]

1번

DGMGRL> switchover to SBDB;
Performing switchover NOW, please wait...
Operation requires a connection to database "sbdb"
Connecting ...
Connected to "SBDB"
Connected as SYSDBA.
New primary database "sbdb" is opening...
Operation requires start up of instance "PROD" on database "prod"
Starting instance "PROD"...
Connected to an idle instance.
ORACLE instance started.
Connected to "PROD"
Database mounted.
Connected to "PROD"
Switchover succeeded, new primary is "sbdb"
DGMGRL> shwo configruation;
Unrecognized command "shwo", try "help"
DGMGRL> show configuration;

Configuration - dg_config

  Protection Mode: MaxPerformance
  Members:
  sbdb - Primary database
    prod - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 64 seconds ago)

DGMGRL> exit;
oracle@PROD admin$ tnsping PROD

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 16-OCT-2025 16:45:34 

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PROD)))
OK (0 msec)
oracle@PROD admin$ tnsping sbdb

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 16-OCT-2025 16:45:39 

Copyright (c) 1997, 2019, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.14.244)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SBDB)))      
OK (0 msec)

---

2번

standby open read only 로 전환

SYS@SBDB> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@SBDB> startup mount;
ORACLE instance started.

Total System Global Area 1073737800 bytes
Fixed Size                  8904776 bytes
Variable Size             629145600 bytes
Database Buffers          427819008 bytes
Redo Buffers                7868416 bytes
Database mounted.
SYS@SBDB> alter database open read only;

Database altered.

SYS@SBDB> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
USING CURRENT L  2  OGFILE DISCONNECT;

Database altered.

SYS@SBDB> @p

PROCESS   STATUS
--------- ------------
ARCH      CLOSING
DGRD      ALLOCATED
DGRD      ALLOCATED
ARCH      CONNECTED
ARCH      CLOSING
ARCH      CLOSING
RFS       IDLE
RFS       IDLE
RFS       IDLE
RFS       IDLE
MRP0      APPLYING_LOG

11 rows selected.

PROD에서 SCOTT 계정에서 EMP 테이블 SAL UPDATE, COMMIT

SYS@PROD> connect scott/tiger;
Connected.
SCOTT@PROD> update emp set sal = 9999;

14 rows updated.

SCOTT@PROD> commit;

Commit complete.

SCOTT@PROD>

SBDB에서 SCOTT 접속후 ENAME, SAL 확인

SYS@SBDB> connect scott/tiger;
Connected.
SCOTT@SBDB> select ename,sal from emp;

ENAME             SAL
---------- ----------
KING             9999
BLAKE            9999
CLARK            9999
JONES            9999
MARTIN           9999
ALLEN            9999
TURNER           9999
JAMES            9999
WARD             9999
FORD             9999
SMITH            9999

ENAME             SAL
---------- ----------
SCOTT            9999
ADAMS            9999
MILLER           9999

14 rows selected.

SCOTT@SBDB>