Taking backup as Oracle Image Copies

Backup & Recovery / 14/07/2022

Realizar o backup utilizando image copy possui algumas vantagens e desvantagens, que devem ser considerados na implementação da solução de backup do ambiente. O tempo deste método é maior, se comparado com o backupset, além dos arquivos gerados possuírem maior tamanho (até pelo fato de ter uma cópia bit a bit do arquivo de origem). Porém, o tempo de restore é menor para o image copy, se comparado com o backupset. Neste artigo simples demonstro alguns exemplos do uso dele.

Realizando backup do banco inteiro:

[oracle@oel8 datafile]$ rman target /
 
Recovery Manager: Release 18.0.0.0.0 - Production on Tue Mar 16 04:23:17 2021
Version 18.3.0.0.0
 
Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: RMANDB (DBID=3825250984)
 
RMAN> BACKUP AS COPY DATABASE;
 
Starting backup at 2021-03-16:04:23:28
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=59 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
output file name=/oracle/fra/RMANDB/datafile/o1_mf_system_j50q7khq_.dbf tag=TAG20210316T042329 RECID=6 STAMP=1067315018
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/oracle/dados/RMANDB/datafile/o1_mf_sysaux_h8nyq35q_.dbf
output file name=/oracle/fra/RMANDB/datafile/o1_mf_sysaux_j50q80oc_.dbf tag=TAG20210316T042329 RECID=7 STAMP=1067315030
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/oracle/dados/RMANDB/datafile/o1_mf_undotbs1_h8nyrjdr_.dbf
output file name=/oracle/fra/RMANDB/datafile/o1_mf_undotbs1_j50q87rb_.dbf tag=TAG20210316T042329 RECID=8 STAMP=1067315034
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/oracle/dados/RMANDB/datafile/ts_cortex_catalog.dbf
output file name=/oracle/fra/RMANDB/datafile/o1_mf_ts_corte_j50q8c78_.dbf tag=TAG20210316T042329 RECID=9 STAMP=1067315041
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/oracle/dados/RMANDB/datafile/o1_mf_users_h8nyrkn7_.dbf
output file name=/oracle/fra/RMANDB/datafile/o1_mf_users_j50q8lb8_.dbf tag=TAG20210316T042329 RECID=10 STAMP=1067315042
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2021-03-16:04:24:03
 
Starting Control File and SPFILE Autobackup at 2021-03-16:04:24:03
piece handle=/oracle/fra/RMANDB/autobackup/2021_03_16/o1_mf_s_1067315043_j50q8ngz_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-03-16:04:24:06
 
RMAN>

Consultando dados sobre o backup acima com o LIST:

RMAN> LIST COPY OF DATABASE;
 
List of Datafile Copies
=======================
 
Key     File S Completion Time     Ckp SCN    Ckp Time            Sparse
------- ---- - ------------------- ---------- ------------------- ------
6       1    A 2021-03-16:04:23:38 1828269    2021-03-16:04:23:29 NO
        Name: /oracle/fra/RMANDB/datafile/o1_mf_system_j50q7khq_.dbf
        Tag: TAG20210316T042329
 
7       3    A 2021-03-16:04:23:50 1828274    2021-03-16:04:23:44 NO
        Name: /oracle/fra/RMANDB/datafile/o1_mf_sysaux_j50q80oc_.dbf
        Tag: TAG20210316T042329
 
8       4    A 2021-03-16:04:23:54 1828277    2021-03-16:04:23:51 NO
        Name: /oracle/fra/RMANDB/datafile/o1_mf_undotbs1_j50q87rb_.dbf
        Tag: TAG20210316T042329
 
9       5    A 2021-03-16:04:24:01 1828279    2021-03-16:04:23:55 NO
        Name: /oracle/fra/RMANDB/datafile/o1_mf_ts_corte_j50q8c78_.dbf
        Tag: TAG20210316T042329
 
10      7    A 2021-03-16:04:24:02 1828282    2021-03-16:04:24:02 NO
        Name: /oracle/fra/RMANDB/datafile/o1_mf_users_j50q8lb8_.dbf
        Tag: TAG20210316T042329
 
 
RMAN> host 'ls -lthr /oracle/fra/RMANDB/datafile/';
 
total 2.0G
-rw-r-----. 1 oracle oinstall 861M Mar 16 04:23 o1_mf_system_j50q7khq_.dbf
-rw-r-----. 1 oracle oinstall 601M Mar 16 04:23 o1_mf_sysaux_j50q80oc_.dbf
-rw-r-----. 1 oracle oinstall 306M Mar 16 04:23 o1_mf_undotbs1_j50q87rb_.dbf
-rw-r-----. 1 oracle oinstall 201M Mar 16 04:23 o1_mf_ts_corte_j50q8c78_.dbf
-rw-r-----. 1 oracle oinstall 5.1M Mar 16 04:24 o1_mf_users_j50q8lb8_.dbf
host command complete

Limpando arquivos de backup da FRA:

RMAN> DELETE COPY OF DATABASE;
 
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=59 device type=DISK
List of Datafile Copies
=======================
 
Key     File S Completion Time     Ckp SCN    Ckp Time            Sparse
------- ---- - ------------------- ---------- ------------------- ------
6       1    A 2021-03-16:04:23:38 1828269    2021-03-16:04:23:29 NO
        Name: /oracle/fra/RMANDB/datafile/o1_mf_system_j50q7khq_.dbf
        Tag: TAG20210316T042329
 
7       3    A 2021-03-16:04:23:50 1828274    2021-03-16:04:23:44 NO
        Name: /oracle/fra/RMANDB/datafile/o1_mf_sysaux_j50q80oc_.dbf
        Tag: TAG20210316T042329
 
8       4    A 2021-03-16:04:23:54 1828277    2021-03-16:04:23:51 NO
        Name: /oracle/fra/RMANDB/datafile/o1_mf_undotbs1_j50q87rb_.dbf
        Tag: TAG20210316T042329
 
9       5    A 2021-03-16:04:24:01 1828279    2021-03-16:04:23:55 NO
        Name: /oracle/fra/RMANDB/datafile/o1_mf_ts_corte_j50q8c78_.dbf
        Tag: TAG20210316T042329
 
10      7    A 2021-03-16:04:24:02 1828282    2021-03-16:04:24:02 NO
        Name: /oracle/fra/RMANDB/datafile/o1_mf_users_j50q8lb8_.dbf
        Tag: TAG20210316T042329
 
 
Do you really want to delete the above objects (enter YES or NO)? YES
deleted datafile copy
datafile copy file name=/oracle/fra/RMANDB/datafile/o1_mf_system_j50q7khq_.dbf RECID=6 STAMP=1067315018
deleted datafile copy
datafile copy file name=/oracle/fra/RMANDB/datafile/o1_mf_sysaux_j50q80oc_.dbf RECID=7 STAMP=1067315030
deleted datafile copy
datafile copy file name=/oracle/fra/RMANDB/datafile/o1_mf_undotbs1_j50q87rb_.dbf RECID=8 STAMP=1067315034
deleted datafile copy
datafile copy file name=/oracle/fra/RMANDB/datafile/o1_mf_ts_corte_j50q8c78_.dbf RECID=9 STAMP=1067315041
deleted datafile copy
datafile copy file name=/oracle/fra/RMANDB/datafile/o1_mf_users_j50q8lb8_.dbf RECID=10 STAMP=1067315042
Deleted 5 objects

Utilizando o parâmetro FORMAT durante o backup para apontar ao RMAN o local de destino do backup.

RMAN> BACKUP AS COPY TABLESPACE USERS FORMAT '/oracle/fra/RMANDB/datafile/users.dbf';
 
Starting backup at 2021-03-16:05:08:41
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=131 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/oracle/dados/RMANDB/datafile/o1_mf_users_h8nyrkn7_.dbf
output file name=/oracle/fra/RMANDB/datafile/users.dbf tag=TAG20210316T050842 RECID=11 STAMP=1067317722
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2021-03-16:05:08:43
 
Starting Control File and SPFILE Autobackup at 2021-03-16:05:08:43
piece handle=/oracle/fra/RMANDB/autobackup/2021_03_16/o1_mf_s_1067317723_j50swcxv_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-03-16:05:08:44

Realizando processo de um datafile em específico (tanto pelo seu número quanto nome):

RMAN> BACKUP AS COPY DATAFILE 7;
 
Starting backup at 2021-03-16:05:11:55
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/oracle/dados/RMANDB/datafile/o1_mf_users_h8nyrkn7_.dbf
output file name=/oracle/fra/RMANDB/datafile/o1_mf_users_j50t2cyv_.dbf tag=TAG20210316T051155 RECID=12 STAMP=1067317916
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2021-03-16:05:11:56
 
Starting Control File and SPFILE Autobackup at 2021-03-16:05:11:57
piece handle=/oracle/fra/RMANDB/autobackup/2021_03_16/o1_mf_s_1067317917_j50t2fjp_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-03-16:05:11:58
 
RMAN> BACKUP AS COPY DATAFILE '/oracle/dados/RMANDB/datafile/o1_mf_users_h8nyrkn7_.dbf';
 
Starting backup at 2021-03-16:05:12:08
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/oracle/dados/RMANDB/datafile/o1_mf_users_h8nyrkn7_.dbf
output file name=/oracle/fra/RMANDB/datafile/o1_mf_users_j50t2rx0_.dbf tag=TAG20210316T051208 RECID=13 STAMP=1067317928
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2021-03-16:05:12:09
 
Starting Control File and SPFILE Autobackup at 2021-03-16:05:12:10
piece handle=/oracle/fra/RMANDB/autobackup/2021_03_16/o1_mf_s_1067317930_j50t2thb_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-03-16:05:12:11

Fazendo image copy dos archived redologs:

RMAN> BACKUP AS COPY ARCHIVELOG ALL;
 
Starting backup at 2021-03-16:05:21:57
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=40 RECID=46 STAMP=1067318518
output file name=/oracle/fra/RMANDB/archivelog/2021_03_16/o1_mf_1_40_j50to6cq_.arc RECID=47 STAMP=1067318518
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 2021-03-16:05:21:59
 
Starting Control File and SPFILE Autobackup at 2021-03-16:05:21:59
piece handle=/oracle/fra/RMANDB/autobackup/2021_03_16/o1_mf_s_1067318519_j50to7rx_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-03-16:05:22:00

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.

Leave a Comment

Your email address will not be published.

pt Portuguese
en Englishpt Portuguesees Spanish