Database Sync

Controlfile Reuse 및 DB resetlogs Open

ORACLE_BASE from environment = /rdsdbbin
Spfile /rdsdbbin/oracle/dbs/spfileRDSTSTEE.ora is in old pre-11 format and compatible >= 11.0.0; converting to new H.A.R.D. compliant format.
2022-XX-XXT04:02:13.257388+00:00
CREATE CONTROLFILE  REUSE SET DATABASE "RDSTSTEE" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 30
    MAXINSTANCES 1
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/rdsdbdata/db/RDSTSTEE_A/onlinelog/o1_mf_1_k01sjh94_.log'  SIZE 128M BLOCKSIZE 512,
  GROUP 2 '/rdsdbdata/db/RDSTSTEE_A/onlinelog/o1_mf_2_k01sjgqb_.log'  SIZE 128M BLOCKSIZE 512,
  GROUP 3 '/rdsdbdata/db/RDSTSTEE_A/onlinelog/o1_mf_3_k01sjg6o_.log'  SIZE 128M BLOCKSIZE 512,
  GROUP 4 '/rdsdbdata/db/RDSTSTEE_A/onlinelog/o1_mf_4_k01sjj8b_.log'  SIZE 128M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/rdsdbdata/db/RDSTSTEE_A/datafile/o1_mf_system_k01sj5pg_.dbf',
  '/rdsdbdata/db/RDSTSTEE_A/datafile/o1_mf_sysaux_k01sj821_.dbf',
  '/rdsdbdata/db/RDSTSTEE_A/datafile/o1_mf_undo_t1_k01sj8k4_.dbf',
  '/rdsdbdata/db/RDSTSTEE_A/datafile/o1_mf_users_k01sj8pj_.dbf',
  '/rdsdbdata/db/RDSTSTEE_A/datafile/o1_mf_rdsadmin_k01toxo8_.dbf'
CHARACTER SET AL32UTF8
2022-XX-XXT04:02:13.257588+00:00
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
.... (PID:5591): RT: Role transition work is not done
Expanded controlfile section 32 from 31 to 128 records
Requested to grow by 97 records; added 3 blocks of records
.... (PID:5591): Redo network throttle feature is disabled at mount time
2022-XX-XXT04:02:13.361552+00:00
Successful mount of redo thread 1, with mount id 4185116805
Completed: CREATE CONTROLFILE  REUSE SET DATABASE "RDSTSTEE" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 30
    MAXINSTANCES 1
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/rdsdbdata/db/RDSTSTEE_A/onlinelog/o1_mf_1_k01sjh94_.log'  SIZE 128M BLOCKSIZE 512,
  GROUP 2 '/rdsdbdata/db/RDSTSTEE_A/onlinelog/o1_mf_2_k01sjgqb_.log'  SIZE 128M BLOCKSIZE 512,
  GROUP 3 '/rdsdbdata/db/RDSTSTEE_A/onlinelog/o1_mf_3_k01sjg6o_.log'  SIZE 128M BLOCKSIZE 512,
  GROUP 4 '/rdsdbdata/db/RDSTSTEE_A/onlinelog/o1_mf_4_k01sjj8b_.log'  SIZE 128M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/rdsdbdata/db/RDSTSTEE_A/datafile/o1_mf_system_k01sj5pg_.dbf',
  '/rdsdbdata/db/RDSTSTEE_A/datafile/o1_mf_sysaux_k01sj821_.dbf',
  '/rdsdbdata/db/RDSTSTEE_A/datafile/o1_mf_undo_t1_k01sj8k4_.dbf',
  '/rdsdbdata/db/RDSTSTEE_A/datafile/o1_mf_users_k01sj8pj_.dbf',
  '/rdsdbdata/db/RDSTSTEE_A/datafile/o1_mf_rdsadmin_k01toxo8_.dbf'
CHARACTER SET AL32UTF8
2022-XX-XXT04:02:13.570187+00:00
ALTER DATABASE OPEN RESETLOGS
2022-XX-XXT04:02:13.594227+00:00
RESETLOGS after incomplete recovery UNTIL CHANGE 754595 time XX/XX/2022 04:01:22
.... (PID:5596): Clearing online redo logfile 1 /rdsdbdata/db/RDSTSTEE_A/onlinelog/o1_mf_1_k01sjh94_.log
.... (PID:5596): Clearing online redo logfile 3 /rdsdbdata/db/RDSTSTEE_A/onlinelog/o1_mf_3_k01sjg6o_.log
Clearing online log 1 of thread 1 sequence number 0
Clearing online log 3 of thread 1 sequence number 0

Temp tablespace tempfile add

2022-XX-XXT04:07:21.305338+00:00
ALTER TABLESPACE TEMP ADD TEMPFILE
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE
ALTER TABLESPACE TEMP AUTOEXTEND ON MAXSIZE 100G
Completed: ALTER TABLESPACE TEMP AUTOEXTEND ON MAXSIZE 100G

Patch Id: 29585399 
Patch Description: OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
Patch Apply Time: 2019-04-18T07:21:33Z

Patch Id: 33515361
Patch Description: Database Release Update : 19.14.0.0.220118 (33515361)
Patch Apply Time: 2022-02-07T08:44:16Z

Patch Id: 33561310
Patch Description: OJVM RELEASE UPDATE: 19.14.0.0.220118 (33561310)
Patch Apply Time: 2022-02-07T08:48:36Z

Patch Id: 28730253
Patch Description: SUPPORT NEW ERA REIWA FOR JAPANESE IMPERIAL CALENDAR
Patch Apply Time: 2022-02-07T08:49:29Z

Patch Id: 29213893
Patch Description: DBMS_STATS FAILING WITH ERROR ORA-01422 WHEN GATHERING STATS FOR USER$ TABLE
Patch Apply Time: 2022-02-07T08:50:17Z

Patch Id: 28852325
Patch Description: RDBMS - DSTV33 UPDATE - TZDATA2018G
Patch Apply Time: 2022-02-07T08:50:50Z

Patch Id: 29997937
Patch Description: RDBMS - DSTV34 UPDATE - TZDATA2019B
Patch Apply Time: 2022-02-07T08:51:23Z

Patch Id: 31335037
Patch Description: RDBMS - DSTV35 UPDATE - TZDATA2020A
Patch Apply Time: 2022-02-07T08:51:56Z

Patch Id: 32327201
Patch Description: RDBMS - DSTV36 UPDATE - TZDATA2020E
Patch Apply Time: 2022-02-07T08:52:29Z

Patch Id: 33613829
Patch Description: RDBMS - DSTV37 UPDATE - TZDATA2021E
Patch Apply Time: 2022-02-07T08:53:02Z

Patch Id: 33613833
Patch Description: DSTV37 UPDATE - TZDATA2021E - NEED OJVM FIX
Patch Apply Time: 2022-02-07T08:53:35Z

[Timezone 변경 방법]

[ec2-user@ip-XXX-XX-XX-XX ~]$
[ec2-user@ip-XXX-XX-XX-XX ~]$ more /etc/sysconfig/clock
ZONE="UTC"
UTC=true
[ec2-user@ip-XXX-XX-XX-XX ~]$
[ec2-user@ip-XXX-XX-XX-XX ~]$ date
Tue May 10 07:04:55 UTC 2022
[ec2-user@ip-XXX-XX-XX-XX ~]$
[ec2-user@ip-XXX-XX-XX-XX ~]$ sudo su - root
[root@ip-XXX-XX-XX-XX ~]#
[root@ip-XXX-XX-XX-XX ~]# rm /etc/localtime
rm: remove regular file ‘/etc/localtime’? y
[root@ip-XXX-XX-XX-XX ~]# ln -s /usr/share/zoneinfo/Asia/Seoul /etc/localtime
[root@ip-XXX-XX-XX-XX ~]#
[root@ip-XXX-XX-XX-XX ~]# more /etc/sysconfig/clock
ZONE="UTC"
UTC=true
[root@ip-XXX-XX-XX-XX ~]#
[root@ip-XXX-XX-XX-XX ~]# date
Tue May 10 16:06:22 KST 2022
[root@ip-XXX-XX-XX-XX ~]#