반응형
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
반응형