개요
메타데이터를 보관하는 데이터베이스인 Catalog DB에 register 수행 시 프로세스를 안내합니다.
방법
1.
tbrmgr catalog register 명령어 수행
2.
catalog db의 SITE_KEY_SEQ.NEXTVAL 확인 및 RC_SITE_KEY table에 data insert
3.
temporary Controlfile snapshot 생성하여 해당 파일에 정보 fetched 후 임시 CF 삭제
4.
contolfile의 메타데이터들을 catalog DB table들에 insert 수행
5.
ALTER DATABASE RECOVERY CATALOG REGISTER 수행 후 Recovery Catalog 플래그 등록 대상 DB의 control file에 register
6.
registration 성공 메시지 후 rmgr end
참고
tbrmgr catalog register 수행 시 로그 레벨 5로 올리면 내용을 확인하실 수 있습니다.
(아래 log 예시 참고)
--log level 5로 설정 시 정상 수행 log
[03-26T10:36:20.031099] [46116] [TRACE]
==============================================================================
RMGR - Recovery Catalog
==============================================================================
[03-26T10:36:20.041423] [46116] [DEBUG] Execute query: SELECT SITE_KEY_SEQ.NEXTVAL FROM DUAL
[03-26T10:36:20.052264] [46116] [DEBUG] Execute query: INSERT INTO RC_SITE_KEY VALUES ('tibero7_s1', 16, 1618608202, 0)
[03-26T10:36:20.064075] [46116] [DEBUG] Execute query: ALTER RMGR CATALOG TO '/home/rmgr1/tibero7_2_2/client/recovery_catalog/cf_snapshot_46116'
[03-26T10:36:20.933569] [46116] [DEBUG] temporary CF snapshot creation succeded /home/rmgr1/tibero7_2_2/client/recovery_catalog/cf_snapshot_46116
[03-26T10:36:20.954784] [46116] [DEBUG] DBETY section all fetched from CF snapshot
[03-26T10:36:20.965054] [46116] [DEBUG] REDOTHREAD section all fetched from CF snapshot
[03-26T10:36:20.975291] [46116] [DEBUG] LOGFILE section all fetched from CF snapshot
[03-26T10:36:20.985587] [46116] [DEBUG] DATAFILE section all fetched from CF snapshot
[03-26T10:36:20.995880] [46116] [DEBUG] ARCHIVELOG section all fetched from CF snapshot
[03-26T10:36:21.006233] [46116] [DEBUG] BACKUP SET section all fetched from CF snapshot
[03-26T10:36:21.016583] [46116] [DEBUG] BACKUP ARCHIVELOG section all fetched from CF snapshot
[03-26T10:36:21.026845] [46116] [DEBUG] TABLESPACE section all fetched from CF snapshot
[03-26T10:36:21.037140] [46116] [DEBUG] LOG HISTORY section all fetched from CF snapshot
[03-26T10:36:21.049561] [46116] [DEBUG] temporary CF snapshot deletion succeded: /home/rmgr1/tibero7_2_2/client/recovery_catalog/cf_snapshot_46116
[03-26T10:36:21.062492] [46116] [DEBUG] Execute query: INSERT INTO RC_LAST_RESYNC VALUES (1618608202, 272923, 16, 1, 3952, 961713, '2025/03/26 09:50:37',0, TO_CHAR(SYSDATE, 'YYYY/MM/DD
HH24:MI:SS'))
[03-26T10:36:21.074181] [46116] [DEBUG] Execute query: INSERT INTO RC_DATABASE VALUES (1618608202, 272923, 16, 7, 'tibero7', '2025/01/15 16:15:06', '2025/01/15 16:15:06', 7)
[03-26T10:36:21.085623] [46116] [DEBUG] Execute query: INSERT INTO RC_DB_INCARNATION VALUES (1618608202, 272923, 16, '2025/01/21 13:35:42', 125996, '2025/01/17 16:16:02', 0)
[03-26T10:36:21.097177] [46116] [DEBUG] Execute query: INSERT INTO RC_REDO_THREAD VALUES (1618608202, 272923, 16, 0, 15, 43, 961713, '2025/03/26 09:50:37', 1, '2025/01/15 16:18:34', 0,
'00/00/00 00:00:00', '2025/03/26 09:19:42')
[03-26T10:36:21.108743] [46116] [DEBUG] Execute query: INSERT INTO RC_LOGFILE VALUES (1618608202, 272923, 16, 0, 0, 1, 129, 102400, 204800,
'/home/rmgr1/tibero7_2_2/database/tibero7/log001.log')
[03-26T10:36:21.120477] [46116] [DEBUG] Execute query: INSERT INTO RC_LOGFILE VALUES (1618608202, 272923, 16, 0, 0, 2, 17, 102400, 204800,
'/home/rmgr1/tibero7_2_2/database/tibero7/log003.log')
[03-26T10:36:21.132014] [46116] [DEBUG] Execute query: INSERT INTO RC_LOGFILE VALUES (1618608202, 272923, 16, 0, 0, 3, 17, 102400, 204800,
'/home/rmgr1/tibero7_2_2/database/tibero7/log005.log')
[03-26T10:36:21.143558] [46116] [DEBUG] Execute query: INSERT INTO RC_TABLESPACE VALUES (1618608202, 272923, 16, 0, 3, 0, 'SYSTEM', 0, 1)
[03-26T10:36:21.155241] [46116] [DEBUG] Execute query: INSERT INTO RC_TABLESPACE VALUES (1618608202, 272923, 16, 1, 3, 1, 'UNDO', 1, 1)
[03-26T10:36:21.166646] [46116] [DEBUG] Execute query: INSERT INTO RC_TABLESPACE VALUES (1618608202, 272923, 16, 2, 3, 2, 'TEMP', 0, 1)
[03-26T10:36:21.178153] [46116] [DEBUG] Execute query: INSERT INTO RC_TABLESPACE VALUES (1618608202, 272923, 16, 3, 3, 0, 'USR', 2, 1)
[03-26T10:36:21.189637] [46116] [DEBUG] Execute query: INSERT INTO RC_TABLESPACE VALUES (1618608202, 272923, 16, 4, 3, 0, 'SYSSUB', 3, 1)
[03-26T10:36:21.201140] [46116] [DEBUG] Execute query: INSERT INTO RC_DATAFILE VALUES (1618608202, 272923, 16, 3, '/home/rmgr1/tibero7_2_2/database/tibero7/system001.dtf', 0, 0, 0, 8192,
12800, 1, '2025/01/15 16:18:34', 961713, '2025/03/26 09:50:37', 0, '2025/02/06 17:27:00', 281474976710655, '2025/01/15 16:18:34', 281474976710655, '2025/01/15 16:18:34', 281474976710655,
'2025/03/26 09:19:42')
[03-26T10:36:21.212898] [46116] [DEBUG] Execute query: INSERT INTO RC_DATAFILE VALUES (1618608202, 272923, 16, 3, '/home/rmgr1/tibero7_2_2/database/tibero7/undo001.dtf', 1, 1, 1, 8192,
25600, 5, '2025/01/15 16:18:36', 961713, '2025/03/26 09:50:37', 0, '2025/02/06 17:27:01', 281474976710655, '2025/01/15 16:18:36', 281474976710655, '2025/01/15 16:18:36', 281474976710655,
'2025/03/26 09:19:42')
[03-26T10:36:21.224449] [46116] [DEBUG] Execute query: INSERT INTO RC_DATAFILE VALUES (1618608202, 272923, 16, 3, '/home/rmgr1/tibero7_2_2/database/tibero7/usr001.dtf', 2, 3, 2, 8192,
12800, 9, '2025/01/15 16:18:36', 961713, '2025/03/26 09:50:37', 0, '2025/02/06 17:27:01', 281474976710655, '2025/01/15 16:18:36', 281474976710655, '2025/01/15 16:18:36', 281474976710655,
'2025/03/26 09:19:42')
[03-26T10:36:21.236015] [46116] [DEBUG] Execute query: INSERT INTO RC_DATAFILE VALUES (1618608202, 272923, 16, 3, '/home/rmgr1/tibero7_2_2/database/tibero7/syssub001.dtf', 3, 4, 3, 8192,
1280, 11, '2025/01/15 16:18:36', 961713, '2025/03/26 09:50:37', 0, '2025/02/06 17:27:04', 281474976710655, '2025/01/15 16:18:36', 281474976710655, '2025/01/15 16:18:36', 281474976710655,
'2025/03/26 09:19:42')
[03-26T10:36:21.247564] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 1, 272923, '2025/01/21 13:35:42', 272924, '2025/01/21 13:35:47',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s1.arc')
[03-26T10:36:21.259283] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 2, 272924, '2025/01/21 13:35:47', 273008, '2025/01/21 13:39:28',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s2.arc')
[03-26T10:36:21.270803] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 3, 273008, '2025/01/21 13:39:28', 273066, '2025/01/21 13:40:58',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s3.arc')
[03-26T10:36:21.282342] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 4, 273066, '2025/01/21 13:40:58', 311690, '2025/01/22 13:28:07',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s4.arc')
[03-26T10:36:21.293866] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 5, 311690, '2025/01/22 13:28:07', 313208, '2025/01/22 14:28:52',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s5.arc')
[03-26T10:36:21.305388] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 6, 313208, '2025/01/22 14:28:52', 313249, '2025/01/22 14:36:03',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s6.arc')
[03-26T10:36:21.316880] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 7, 313249, '2025/01/22 14:36:03', 313608, '2025/01/22 14:56:22',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s7.arc')
[03-26T10:36:21.328411] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 8, 313608, '2025/01/22 14:56:22', 313724, '2025/01/22 15:00:17',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s8.arc')
[03-26T10:36:21.339913] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 9, 313724, '2025/01/22 15:00:17', 315001, '2025/01/22 15:53:29',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s9.arc')
[03-26T10:36:21.351445] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 10, 315001, '2025/01/22 15:53:29', 315004, '2025/01/22 15:53:36',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s10.arc')
[03-26T10:36:21.362956] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 11, 315004, '2025/01/22 15:53:36', 315913, '2025/02/05 00:43:06',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s11.arc')
[03-26T10:36:21.374489] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 12, 315913, '2025/02/05 00:43:06', 349747, '2025/02/05 15:11:24',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s12.arc')
[03-26T10:36:21.386013] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 13, 349747, '2025/02/05 15:11:24', 394898, '2025/02/06 17:27:07',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s13.arc')
[03-26T10:36:21.397535] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 14, 394898, '2025/02/06 17:27:07', 422483, '2025/02/07 10:50:10',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s14.arc')
[03-26T10:36:21.409041] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 15, 422483, '2025/02/07 10:50:10', 426888, '2025/02/07 13:15:42',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s15.arc')
[03-26T10:36:21.420524] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 16, 426888, '2025/02/07 13:15:42', 426922, '2025/02/07 13:15:52',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s16.arc')
[03-26T10:36:21.432054] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 17, 426922, '2025/02/07 13:15:52', 429021, '2025/02/07 14:38:09',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s17.arc')
[03-26T10:36:21.443568] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 18, 429021, '2025/02/07 14:38:09', 504255, '2025/02/09 13:19:30',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s18.arc')
[03-26T10:36:21.455090] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 19, 504255, '2025/02/09 13:19:30', 544386, '2025/02/10 14:24:05',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s19.arc')
[03-26T10:36:21.466570] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 20, 544386, '2025/02/10 14:24:05', 549507, '2025/02/10 17:14:01',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s20.arc')
[03-26T10:36:21.478096] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 21, 549507, '2025/02/10 17:14:01', 549510, '2025/02/10 17:14:27',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s21.arc')
[03-26T10:36:21.489613] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 22, 549510, '2025/02/10 17:14:27', 549732, '2025/02/10 17:27:52',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s22.arc')
[03-26T10:36:21.501147] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 23, 549732, '2025/02/10 17:27:52', 549757, '2025/02/10 17:36:37',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s23.arc')
[03-26T10:36:21.512695] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 24, 549757, '2025/02/10 17:36:37', 550027, '2025/02/11 11:16:20',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s24.arc')
[03-26T10:36:21.524189] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 25, 550027, '2025/02/11 11:16:20', 555241, '2025/02/11 14:42:10',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s25.arc')
[03-26T10:36:21.535717] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 26, 555241, '2025/02/11 14:42:10', 556204, '2025/02/11 15:23:18',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s26.arc')
[03-26T10:36:21.547261] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 27, 556204, '2025/02/11 15:23:18', 556222, '2025/02/11 15:25:27',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s27.arc')
[03-26T10:36:21.558686] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 28, 556222, '2025/02/11 15:25:27', 560643, '2025/02/11 18:05:31',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s28.arc')
[03-26T10:36:21.570194] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 29, 560643, '2025/02/11 18:05:31', 560695, '2025/02/11 18:10:28',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s29.arc')
[03-26T10:36:21.581745] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 30, 560695, '2025/02/11 18:10:28', 585154, '2025/02/12 09:02:36',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s30.arc')
[03-26T10:36:21.593292] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 31, 585154, '2025/02/12 09:02:36', 585157, '2025/02/12 09:04:00',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s31.arc')
[03-26T10:36:21.604832] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 32, 585157, '2025/02/12 09:04:00', 585399, '2025/02/12 10:47:22',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s32.arc')
[03-26T10:36:21.616391] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 33, 585399, '2025/02/12 10:47:22', 658895, '2025/02/14 06:47:25',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s33.arc')
[03-26T10:36:21.627889] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 34, 658895, '2025/02/14 06:47:25', 704745, '2025/02/15 08:47:25',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s34.arc')
[03-26T10:36:21.639398] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 35, 704745, '2025/02/15 08:47:25', 742792, '2025/02/16 05:47:25',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s35.arc')
[03-26T10:36:21.650948] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 36, 742792, '2025/02/16 05:47:25', 780320, '2025/02/17 02:17:32',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s36.arc')
[03-26T10:36:21.662461] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 37, 780320, '2025/02/17 02:17:32', 848090, '2025/02/19 00:47:24',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s37.arc')
[03-26T10:36:21.673995] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 38, 848090, '2025/02/19 00:47:24', 916974, '2025/02/21 00:01:05',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s38.arc')
[03-26T10:36:21.685523] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 39, 916974, '2025/02/21 00:01:05', 938096, '2025/03/26 09:19:42',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s39.arc')
[03-26T10:36:21.697046] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 40, 938096, '2025/03/26 09:19:42', 946249, '2025/03/26 09:49:51',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s40.arc')
[03-26T10:36:21.708588] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 41, 946249, '2025/03/26 09:49:51', 953782, '2025/03/26 09:50:00',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s41.arc')
[03-26T10:36:21.720111] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 42, 953782, '2025/03/26 09:50:00', 961712, '2025/03/26 09:50:13',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s42.arc')
[03-26T10:36:21.731655] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 43, 961712, '2025/03/26 09:50:13', 971692, '2025/03/26 09:50:22',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s43.arc')
[03-26T10:36:21.743068] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 44, 971692, '2025/03/26 09:50:22', 979057, '2025/03/26 09:50:37',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s44.arc')
[03-26T10:36:21.754589] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 45, 979057, '2025/03/26 09:50:37', 988445, '2025/03/26 09:51:40',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s45.arc')
[03-26T10:36:21.766092] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 46, 988445, '2025/03/26 09:51:40', 1017136, '2025/03/26 09:55:00',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s46.arc')
[03-26T10:36:21.777617] [46116] [DEBUG] Execute query: INSERT INTO RC_ARCHIVED_LOG VALUES (1618608202, 272923, 16, 0, 0, 47, 1017136, '2025/03/26 09:55:00', 1049990, '2025/03/26 09:58:30',
'/home/rmgr1/tibero7_2_2/database/tibero7/archive/log-tibero-t0-r272923-s47.arc')
[03-26T10:36:21.789129] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 1, 272923, '2025/01/21 13:35:42', 272924, '2025/01/21 13:35:47', 0)
[03-26T10:36:21.800862] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 2, 272924, '2025/01/21 13:35:47', 273008, '2025/01/21 13:39:28', 40)
[03-26T10:36:21.812399] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 3, 273008, '2025/01/21 13:39:28', 273066, '2025/01/21 13:40:58', 61)
[03-26T10:36:21.823912] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 4, 273066, '2025/01/21 13:40:58', 311690, '2025/01/22 13:28:07', 49376)
[03-26T10:36:21.835352] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 5, 311690, '2025/01/22 13:28:07', 313208, '2025/01/22 14:28:52', 1660)
[03-26T10:36:21.846894] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 6, 313208, '2025/01/22 14:28:52', 313249, '2025/01/22 14:36:03', 2)
[03-26T10:36:21.858310] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 7, 313249, '2025/01/22 14:36:03', 313608, '2025/01/22 14:56:22', 94)
[03-26T10:36:21.869750] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 8, 313608, '2025/01/22 14:56:22', 313724, '2025/01/22 15:00:17', 69)
[03-26T10:36:21.881277] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 9, 313724, '2025/01/22 15:00:17', 315001, '2025/01/22 15:53:29', 701)
[03-26T10:36:21.892798] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 10, 315001, '2025/01/22 15:53:29', 315004, '2025/01/22 15:53:36', 0)
[03-26T10:36:21.904317] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 11, 315004, '2025/01/22 15:53:36', 315913, '2025/02/05 00:43:06', 718)
[03-26T10:36:21.915813] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 12, 315913, '2025/02/05 00:43:06', 349747, '2025/02/05 15:11:24', 20782)
[03-26T10:36:21.927324] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 13, 349747, '2025/02/05 15:11:24', 394898, '2025/02/06 17:27:07', 65433)
[03-26T10:36:21.938834] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 14, 394898, '2025/02/06 17:27:07', 422483, '2025/02/07 10:50:10', 47687)
[03-26T10:36:21.950368] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 15, 422483, '2025/02/07 10:50:10', 426888, '2025/02/07 13:15:42', 3309)
[03-26T10:36:21.961879] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 16, 426888, '2025/02/07 13:15:42', 426922, '2025/02/07 13:15:52', 67)
[03-26T10:36:21.973222] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 17, 426922, '2025/02/07 13:15:52', 429021, '2025/02/07 14:38:09', 1494)
[03-26T10:36:21.984744] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 18, 429021, '2025/02/07 14:38:09', 504255, '2025/02/09 13:19:30', 102400)
[03-26T10:36:21.996272] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 19, 504255, '2025/02/09 13:19:30', 544386, '2025/02/10 14:24:05', 53577)
[03-26T10:36:22.007760] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 20, 544386, '2025/02/10 14:24:05', 549507, '2025/02/10 17:14:01', 4163)
[03-26T10:36:22.019211] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 21, 549507, '2025/02/10 17:14:01', 549510, '2025/02/10 17:14:27', 0)
[03-26T10:36:22.030733] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 22, 549510, '2025/02/10 17:14:27', 549732, '2025/02/10 17:27:52', 76)
[03-26T10:36:22.042182] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 23, 549732, '2025/02/10 17:27:52', 549757, '2025/02/10 17:36:37', 37)
[03-26T10:36:22.053687] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 24, 549757, '2025/02/10 17:36:37', 550027, '2025/02/11 11:16:20', 49)
[03-26T10:36:22.065226] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 25, 550027, '2025/02/11 11:16:20', 555241, '2025/02/11 14:42:10', 4321)
[03-26T10:36:22.076668] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 26, 555241, '2025/02/11 14:42:10', 556204, '2025/02/11 15:23:18', 1461)
[03-26T10:36:22.088176] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 27, 556204, '2025/02/11 15:23:18', 556222, '2025/02/11 15:25:27', 69)
[03-26T10:36:22.099702] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 28, 556222, '2025/02/11 15:25:27', 560643, '2025/02/11 18:05:31', 4102)
[03-26T10:36:22.111221] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 29, 560643, '2025/02/11 18:05:31', 560695, '2025/02/11 18:10:28', 68)
[03-26T10:36:22.122704] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 30, 560695, '2025/02/11 18:10:28', 585154, '2025/02/12 09:02:36', 32812)
[03-26T10:36:22.134229] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 31, 585154, '2025/02/12 09:02:36', 585157, '2025/02/12 09:04:00', 0)
[03-26T10:36:22.145752] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 32, 585157, '2025/02/12 09:04:00', 585399, '2025/02/12 10:47:22', 228)
[03-26T10:36:22.157270] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 33, 585399, '2025/02/12 10:47:22', 658895, '2025/02/14 06:47:25', 102400)
[03-26T10:36:22.168762] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 34, 658895, '2025/02/14 06:47:25', 704745, '2025/02/15 08:47:25', 102395)
[03-26T10:36:22.180282] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 35, 704745, '2025/02/15 08:47:25', 742792, '2025/02/16 05:47:25', 102400)
[03-26T10:36:22.191770] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 36, 742792, '2025/02/16 05:47:25', 780320, '2025/02/17 02:17:32', 102395)
[03-26T10:36:22.203279] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 37, 780320, '2025/02/17 02:17:32', 848090, '2025/02/19 00:47:24', 102397)
[03-26T10:36:22.214785] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 38, 848090, '2025/02/19 00:47:24', 916974, '2025/02/21 00:01:05', 102400)
[03-26T10:36:22.226296] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 39, 916974, '2025/02/21 00:01:05', 938096, '2025/03/26 09:19:42', 31659)
[03-26T10:36:22.237793] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 40, 938096, '2025/03/26 09:19:42', 946249, '2025/03/26 09:49:51', 102400)
[03-26T10:36:22.249314] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 41, 946249, '2025/03/26 09:49:51', 953782, '2025/03/26 09:50:00', 102400)
[03-26T10:36:22.260801] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 42, 953782, '2025/03/26 09:50:00', 961712, '2025/03/26 09:50:13', 102398)
[03-26T10:36:22.272305] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 43, 961712, '2025/03/26 09:50:13', 971692, '2025/03/26 09:50:22', 102400)
[03-26T10:36:22.283802] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 44, 971692, '2025/03/26 09:50:22', 979057, '2025/03/26 09:50:37', 102400)
[03-26T10:36:22.295330] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 45, 979057, '2025/03/26 09:50:37', 988445, '2025/03/26 09:51:40', 102398)
[03-26T10:36:22.306837] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 46, 988445, '2025/03/26 09:51:40', 1017136, '2025/03/26 09:55:00', 102398)
[03-26T10:36:22.318373] [46116] [DEBUG] Execute query: INSERT INTO RC_LOG_HISTORY VALUES (1618608202, 272923, 16, 0, 0, 47, 1017136, '2025/03/26 09:55:00', 1049990, '2025/03/26 09:58:30', 102399)
[03-26T10:36:22.329885] [46116] [ INFO] Execute query: INSERT INTO RC_BACKUP_SET VALUES (1618608202, 272923, 16, 2, 0, 33, 1182, 0, 394880, '2025/02/06 17:27:00', 394896, '2025/02/06
17:27:04', '11011', '/home/rmgr1/backup', 1)
[03-26T10:36:22.341640] [46116] [ INFO] Execute query: INSERT INTO RC_BACKUP_ARCHIVELOG VALUES (1618608202, 272923, 16, 2, 0, 33, 13, 13, 349747, '2025/02/05 15:11:24', 394898, '2025/02/06
17:27:07')
[03-26T10:36:22.360308] [46116] [DEBUG] Execute query: ALTER DATABASE RECOVERY CATALOG REGISTER
[03-26T10:36:22.376271] [46116] [DEBUG] Recovery Catalog flag registered at the controlfile
[03-26T10:36:22.386522] [46116] [TRACE] Registration of [DB_NAME: tibero7, DB_ID: 1618608202, INCARNATION: 272923, DB_UNIQUE_NAME: tibero7_s1] succeeded
[03-26T10:36:22.396810] [46116] [TRACE] Catalog registration ends
[03-26T10:36:22.407060] [46116] [TRACE] RMGR recovery catalog ends
[03-26T10:36:22.417358] [46116] [ INFO] Recovery Manager(RMGR) ends
SQL
복사