Neste artigo, vamos utilizar o OCI Console (com o recurso autobackup) para realizar o backup de nosso DB System.
Acessando a página do nosso database pelo Menu Principal -> Oracle Database -> Bare Metal, VM, and Exadata:
Acessando nosso DB System:
Databases:
Na tela principal do nosso Database, clicamos em “Configure Automatic Backups”:
Podemos selecionar a opção “Enable automatic backup” e escolher a opção de backup retention:
Diferente do DBCLI ou RMAN, onde conseguimos definir precisamente em qual horário podemos rodar nosso backup, no OCI Console temos uma faixa que escolhemos para que o backup seja realizado:
Após salvar a configuração, vemos que a página do database já reflete o que foi feito:
Pouco tempo depois que defini a janela de backup, meu banco de dados já começou a ser “backupeado”, exibindo o seguinte status na Console:
Os detalhes da evolução do processo podem ser vistos na parte de Backups da sessão Resources:
Após bons minutos, o backup (level 0) é concluído:
E o status do banco volta a ser exibido como Disponível:
O interessante para observarmos é que nossa configuração via Console modificou o parâmetro persistente no RMAN, conforme abaixo:
[opc@luxor ~]$ sudo su - oracle
Last login: Thu Jul 15 22:03:11 UTC 2021
[oracle@luxor ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jul 15 22:12:05 2021
Version 19.11.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CORTEX (DBID=581933924)
RMAN> SHOW RETENTION POLICY;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name CORTEX_PHX1HB are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
Através do OCI Console, conseguimos agendar os backups, mas também conseguimos fazer o disparo manualmente. Clicando no banco Create Backup:
Gerando um nome e clicando em Create Backup:
Backup em execução:
Backup concluído com sucesso:
No RMAN, podemos ver as informações dos backups:
RMAN> LIST BACKUP OF DATABASE;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
34 Incr 0 517.75M SBT_TAPE 00:00:33 15-JUL-21
BP Key: 38 Status: AVAILABLE Compressed: YES Tag: DBTREGULAR-L01626384618783OGJ
Handle: DBTRegular-L01626384618783oGj_df_CORTEX_581933924_16042419_38_1_1_20210715_1078005801_set38 Media: swiftobjectstorage.u..ud.com/v1/dbbackupphx/bavjfvGGcVWO7V1HGWEW
List of Datafiles in backup set 34
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 0 Incr 6412879 15-JUL-21 NO +DATA/CORTEX_PHX1HB/DATAFILE/system.261.1071999329
3 0 Incr 6412879 15-JUL-21 NO +DATA/CORTEX_PHX1HB/DATAFILE/sysaux.262.1071999373
4 0 Incr 6412879 15-JUL-21 NO +DATA/CORTEX_PHX1HB/DATAFILE/undotbs1.263.1071999399
11 0 Incr 6412879 15-JUL-21 NO +DATA/CORTEX_PHX1HB/DATAFILE/users.274.1072000383
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
40 Incr 0 253.00M SBT_TAPE 00:00:14 15-JUL-21
BP Key: 44 Status: AVAILABLE Compressed: YES Tag: DBTREGULAR-L01626384618783OGJ
Handle: DBTRegular-L01626384618783oGj_df_CORTEX_581933924_1904242n_41_1_1_20210715_1078005847_set41 Media: swiftobjectstorage.u..ud.com/v1/dbbackupphx/bavjfvGGcVWO7V1HGWEW
List of Datafiles in backup set 40
Container ID: 3, PDB Name: HIPOFISE1
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
8 0 Incr 6414034 15-JUL-21 NO +DATA/CORTEX_PHX1HB/C1CF6DCEA12F134DE0539501000A20C1/DATAFILE/system.271.1072000035
9 0 Incr 6414034 15-JUL-21 NO +DATA/CORTEX_PHX1HB/C1CF6DCEA12F134DE0539501000A20C1/DATAFILE/sysaux.272.1072000035
10 0 Incr 6414034 15-JUL-21 NO +DATA/CORTEX_PHX1HB/C1CF6DCEA12F134DE0539501000A20C1/DATAFILE/undotbs1.270.1072000035
12 0 Incr 6414034 15-JUL-21 NO +DATA/CORTEX_PHX1HB/C1CF6DCEA12F134DE0539501000A20C1/DATAFILE/users.275.1072000383
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
41 Incr 0 313.00M SBT_TAPE 00:00:18 15-JUL-21
BP Key: 45 Status: AVAILABLE Compressed: YES Tag: DBTREGULAR-L01626384618783OGJ
Handle: DBTRegular-L01626384618783oGj_df_CORTEX_581933924_1d04243g_45_1_1_20210715_1078005872_set45 Media: swiftobjectstorage.u..ud.com/v1/dbbackupphx/bavjfvGGcVWO7V1HGWEW
List of Datafiles in backup set 41
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 0 Incr 5899769 05-JUN-21 NO +DATA/CORTEX_PHX1HB/B2084748142A4638E053C003F40A65C0/DATAFILE/system.266.1071999505
6 0 Incr 5899769 05-JUN-21 NO +DATA/CORTEX_PHX1HB/B2084748142A4638E053C003F40A65C0/DATAFILE/sysaux.265.1071999505
7 0 Incr 5899769 05-JUN-21 NO +DATA/CORTEX_PHX1HB/B2084748142A4638E053C003F40A65C0/DATAFILE/undotbs1.267.1071999505
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
47 Full 515.00M SBT_TAPE 00:00:29 15-JUL-21
BP Key: 51 Status: AVAILABLE Compressed: YES Tag: DBTLONGTERM1626387318752YR3
Handle: DBTLongterm1626387318752yR3__CORTEX_581933924_1j042559_51_1_1_20210715_1078006953_set51 Media: swiftobjectstorage.u..ud.com/v1/dbbackupphx/bavjfvGGcVWO7V1HGWEW
Keep: BACKUP_LOGS Until: 08-DEC-00
List of Datafiles in backup set 47
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 6415182 15-JUL-21 NO +DATA/CORTEX_PHX1HB/DATAFILE/system.261.1071999329
3 Full 6415182 15-JUL-21 NO +DATA/CORTEX_PHX1HB/DATAFILE/sysaux.262.1071999373
4 Full 6415182 15-JUL-21 NO +DATA/CORTEX_PHX1HB/DATAFILE/undotbs1.263.1071999399
11 Full 6415182 15-JUL-21 NO +DATA/CORTEX_PHX1HB/DATAFILE/users.274.1072000383
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
48 Full 251.25M SBT_TAPE 00:00:12 15-JUL-21
BP Key: 52 Status: AVAILABLE Compressed: YES Tag: DBTLONGTERM1626387318752YR3
Handle: DBTLongterm1626387318752yR3__CORTEX_581933924_1k04256d_52_1_1_20210715_1078006989_set52 Media: swiftobjectstorage.u..ud.com/v1/dbbackupphx/bavjfvGGcVWO7V1HGWEW
Keep: BACKUP_LOGS Until: 08-DEC-00
List of Datafiles in backup set 48
Container ID: 3, PDB Name: HIPOFISE1
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
8 Full 6415196 15-JUL-21 NO +DATA/CORTEX_PHX1HB/C1CF6DCEA12F134DE0539501000A20C1/DATAFILE/system.271.1072000035
9 Full 6415196 15-JUL-21 NO +DATA/CORTEX_PHX1HB/C1CF6DCEA12F134DE0539501000A20C1/DATAFILE/sysaux.272.1072000035
10 Full 6415196 15-JUL-21 NO +DATA/CORTEX_PHX1HB/C1CF6DCEA12F134DE0539501000A20C1/DATAFILE/undotbs1.270.1072000035
12 Full 6415196 15-JUL-21 NO +DATA/CORTEX_PHX1HB/C1CF6DCEA12F134DE0539501000A20C1/DATAFILE/users.275.1072000383
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
49 Full 313.00M SBT_TAPE 00:00:11 15-JUL-21
BP Key: 53 Status: AVAILABLE Compressed: YES Tag: DBTLONGTERM1626387318752YR3
Handle: DBTLongterm1626387318752yR3__CORTEX_581933924_1l04256t_53_1_1_20210715_1078007005_set53 Media: swiftobjectstorage.u..ud.com/v1/dbbackupphx/bavjfvGGcVWO7V1HGWEW
Keep: BACKUP_LOGS Until: 08-DEC-00
List of Datafiles in backup set 49
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 Full 5899769 05-JUN-21 NO +DATA/CORTEX_PHX1HB/B2084748142A4638E053C003F40A65C0/DATAFILE/system.266.1071999505
6 Full 5899769 05-JUN-21 NO +DATA/CORTEX_PHX1HB/B2084748142A4638E053C003F40A65C0/DATAFILE/sysaux.265.1071999505
7 Full 5899769 05-JUN-21 NO +DATA/CORTEX_PHX1HB/B2084748142A4638E053C003F40A65C0/DATAFILE/undotbs1.267.1071999505
Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laboratório pessoal para fins de aprendizado.
Portuguese
English
Spanish