Oracle basedb dbcli 스케줄 및 백업 확인 및 장애 확인

해당 명령어

 

dbcli list-schedules
[root@bongtestdb ~]# dbcli list-schedules

ID                                       Name                      Description                                        CronExpression                 Disabled
---------------------------------------- ------------------------- -------------------------------------------------- ------------------------------ --------
08af7dd1-de57-4108-9ccc-f5c5c8626d25     metastore maintenance     internal metastore maintenance                     0 0 0 1/1 * ? *                true
0185febf-fa01-462e-9522-a02e4e325e5d     AgentState metastore cleanup internal agentstateentry metastore maintenance     0 0 0 1/1 * ? *                false
d863ba5f-d5e8-4219-a341-228efc2de3e8     backupreport maintenance  backup reports deletion                            0 0 0 1/3 * ? *                false
1e1614e8-38bf-4d52-8c84-eaa67d6f9ea0     bom maintenance           bom reports generation                             0 0 1 ? * SUN *                false
2cf2d1d9-5fa9-441b-b97a-39fdd895e04d     Big File Upload Cleanup   clean up expired big file uploads.                 0 0 1 ? * SUN *                false
cdbe6d00-0378-4fdd-bda8-dff06edac982     feature_tracking_job      Feature tracking job                               0 0 20 ? * WED *               false

• DB 시스템 내 정기 작업(cron 기반) 스케줄 목록 확인
• 주요 필드:
  • Name: 작업 이름
  • CronExpression: 실행 주기 (CRON 표현식)
  • Disabled: 비활성화 여부

dbcli list-jobs

• 데이터베이스에서 수행된 작업(job)의 이력 조회
• Create Backup, Delete Backup, SSH Key 설정 등 포함
  • Regular-L0 : 풀백업
  • Regular-L1 : 증분 백업

    [root@bongtestdb ~]# dbcli  list-jobs
    

ID Description Created Status

---

88210403-6818-4e24-b61c-f72eab520101 Provisioning service creation February 17, 2020 2:50:28 PM KST Success
ffce03c6-918c-4231-aff9-029d5704b977 SSH keys update February 17, 2020 3:25:38 PM KST Success
f4093dc6-0795-4614-8285-e15515e47cfa SSH key delete February 17, 2020 3:27:31 PM KST Success
5fec544c-3ad1-45c3-9faa-fc6eecf51f85 Authentication key update for DCS_ADMIN February 17, 2020 3:30:04 PM KST Success
86f9b368-7ced-4a3a-9443-a6d77327c167 create object store:b492i9fZam9u5ipELLLM February 19, 2020 9:45:52 AM KST Success
4096c3e1-636f-4c7f-8942-ab44e756ee4a create backup config:b492i9fZam9u5ipELLLM_BC February 19, 2020 9:46:15 AM KST Success
33bd0a28-61a8-490d-87cb-a53d5c09f996 update database : testdb February 19, 2020 9:46:55 AM KST Success
533c1090-f7c6-4eb3-90e6-4c76f2e2f682 Create Regular-L0 Backup with TAG-DBTRegular-L01582072495663X7w for Db:testdb in OSS:b492i9fZam9u5ipELLLM February 19, 2020 9:49:46 AM KST Success
925c155a-b464-404a-ae41-e345ece4ac99 Delete Backup for Database name: testdb_icn1mj February 19, 2020 9:52:24 AM KST Success
f4dc4e84-2236-4e09-b3cb-400da11fcdc8 Create Regular-L1 Backup with TAG-DBTRegular-L115822148985366tr for Db:testdb in OSS:b492i9fZam9u5ipELLLM February 21, 2020 1:09:19 AM KST Success
98753aa2-e13f-41e9-b04d-8c2ef2509bed Delete Backup for Database name: testdb_icn1mj February 21, 2020 1:11:32 AM KST Success
6b5c900f-09b5-4ce0-8e92-0fa03fc84d09 Create Regular-L1 Backup with TAG-DBTRegular-L11582301338722RqS for Db:testdb in OSS:b492i9fZam9u5ipELLLM February 22, 2020 1:09:35 AM KST Success
630980bb-ffdd-4fa1-8464-8a86e2832dab Delete Backup for Database name: testdb_icn1mj February 22, 2020 1:11:34 AM KST Success
0eab65e0-3682-4f92-9c73-0baccbed4f9a Update objectstoreSwift:b492i9fZam9u5ipELLLM February 23, 2020 1:18:57 AM KST Success
770096b6-05d2-4ea2-9a70-02e8bcd94eb7 Create Regular-L1 Backup with TAG-DBTRegular-L11582387756974Fkz for Db:testdb in OSS:b492i9fZam9u5ipELLLM February 23, 2020 1:20:53 AM KST Success
34775707-ed52-4b43-8b3d-4a6f43954896 Delete Backup for Database name: testdb_icn1mj February 23, 2020 1:22:58 AM KST Success
d6c7e5b2-8ba0-4296-8ed3-06c8ae9feeed Create Regular-L0 Backup with TAG-DBTRegular-L01582474144398D4A for Db:testdb in OSS:b492i9fZam9u5ipELLLM February 24, 2020 1:10:14 AM KST Success
6b559786-bf12-466f-96b0-aa9b0bbf1e51 Delete Backup for Database name: testdb_icn1mj February 24, 2020 1:12:35 AM KST Success

## DB 작업 상세보기  dbcli describe-job
 - 특정 작업(Job)의 상세 내용 조회
 - 작업 실패 원인, 하위 작업(Task), 시작/종료 시각, 오류 메시지 포함

```bash
[root@iodb ~]# dbcli describe-job  -i 0522e1a2-d285-45af-939d-19ca766e73ca

Job details
----------------------------------------------------------------
                     ID:  0522e1a2-d285-45af-939d-19ca766e73ca
            Description:  Create Regular-L0 Backup with TAG-DBTRegular-L01584096652603pNh for Db:FNF in OSS:bbUHbVbtd6tlCjt6g9DK
                 Status:  Failure
                Created:  March 13, 2020 7:51:31 PM KST
                Message:  DCS-10096:RMAN configuration 'Retention policy' must be configured as 'configure retention policy to recovery window of 7 days'

Task Name                                                                Start Time                          End Time                            Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
task:TaskZLockWrapper_2526                                               March 13, 2020 7:51:34 PM KST       March 13, 2020 7:51:49 PM KST       Failure
task:TaskSequential_2527                                                 March 13, 2020 7:51:34 PM KST       March 13, 2020 7:51:49 PM KST       Failure
Validate backup config                                                   March 13, 2020 7:51:34 PM KST       March 13, 2020 7:51:34 PM KST       Success
Validate opc_pfile configuration                                         March 13, 2020 7:51:34 PM KST       March 13, 2020 7:51:34 PM KST       Success
Database container validation                                            March 13, 2020 7:51:34 PM KST       March 13, 2020 7:51:34 PM KST       Success
libopc existence check                                                   March 13, 2020 7:51:34 PM KST       March 13, 2020 7:51:34 PM KST       Success
Backup Validations                                                       March 13, 2020 7:51:34 PM KST       March 13, 2020 7:51:47 PM KST       Success
Recovery Window validation                                               March 13, 2020 7:51:47 PM KST       March 13, 2020 7:51:49 PM KST       Failure

업무 적용 가이드

1. dbcli list-schedules로 자동 작업 확인
2. dbcli list-jobs로 백업 작업 주기 파악
3. 실패 Job은 describe-job으로 원인 확인

참고 자료

• Oracle dbcli 문서: https://docs.oracle.com/en/cloud/paas/exadata-cloud/index.html
• RMAN Retention Policy 설정: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-the-backup-environment.html
• CRON 표현식 해석: https://crontab.guru