Pular para o conteúdo

RMAN – Backups eternos

RMAN – Backups eternos

No RMAN, é possível executar um Backup que irá ser mantido independente da política de retenção configurada (RECOVERY WINDOW ou REDUNDANCY).

Esta retenção extra pode ser eterna, ou especificada, o que é muito útil para backups históricos exigidos por legislação, por exemplo, que exigem backup de 1 ano.

Executando um backup que será armazenado para sempre, independente do RETENTION.

[oracle@labdb ~]$ rman CATALOG=RMAN_USER/RMAN_USER@ORCL TARGET /

Recovery Manager: Release 11.1.0.7.0 - Production on Thu Jul 23 14:19:20 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1217465568)

connected to recovery catalog database

RMAN> BACKUP DATABASE KEEP FOREVER;

Starting backup at 23-JUL-09

current log archived

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=185 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=186 device type=DISK

backup will never be obsolete

archived logs required to recover from this backup will be backed up

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00002 name=/u01/app/oradata/ORCL/sysaux01.dbf

input datafile file number=00001 name=/u01/app/oradata/ORCL/system01.dbf

input datafile file number=00012 name=/u01/app/oradata/ORCL/tbs_rman01.dbf

input datafile file number=00009 name=/u01/app/oradata/ORCL/OCMS_orasdpls.dbf

input datafile file number=00007 name=/u01/app/oradata/ORCL/users02.dbf

input datafile file number=00010 name=/u01/app/oradata/ORCL/OCMS_orasdpsds.dbf

channel ORA_DISK_1: starting piece 1 at 23-JUL-09

channel ORA_DISK_2: starting compressed full datafile backup set

channel ORA_DISK_2: specifying datafile(s) in backup set

input datafile file number=00003 name=/u01/app/oradata/ORCL/undotbs01.dbf

input datafile file number=00004 name=/u01/app/oradata/ORCL/users01.dbf

input datafile file number=00005 name=/u01/app/oradata/ORCL/example01.dbf

input datafile file number=00011 name=/u01/app/oradata/ORCL/rman01.dbf

input datafile file number=00006 name=/u01/app/oradata/ORCL/m_estudo.dbf

input datafile file number=00008 name=/u01/app/oradata/ORCL/OCMS_orasdpxdms.dbf

channel ORA_DISK_2: starting piece 1 at 23-JUL-09

channel ORA_DISK_2: finished piece 1 at 23-JUL-09

piece handle=/u02/backup/ORCL_20090723_28_1 tag=TAG20090723T141936 comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 00:02:17

channel ORA_DISK_1: finished piece 1 at 23-JUL-09

piece handle=/u01/backup/ORCL_20090723_27_1 tag=TAG20090723T141936 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:04:19

using channel ORA_DISK_1

using channel ORA_DISK_2

backup will never be obsolete

archived logs required to recover from this backup will be backed up

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 23-JUL-09

channel ORA_DISK_1: finished piece 1 at 23-JUL-09

piece handle=/u01/backup/ORCL_20090723_29_1 tag=TAG20090723T141936 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

current log archived

using channel ORA_DISK_1

using channel ORA_DISK_2

backup will never be obsolete

archived logs required to recover from this backup will be backed up

channel ORA_DISK_1: starting compressed archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=169 RECID=118 STAMP=692979857

channel ORA_DISK_1: starting piece 1 at 23-JUL-09

channel ORA_DISK_1: finished piece 1 at 23-JUL-09

piece handle=/u01/backup/ORCL_20090723_30_1 tag=TAG20090723T141936 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

using channel ORA_DISK_1

using channel ORA_DISK_2

backup will never be obsolete

archived logs required to recover from this backup will be backed up

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_1: starting piece 1 at 23-JUL-09

channel ORA_DISK_1: finished piece 1 at 23-JUL-09

piece handle=/u01/backup/ORCL_20090723_31_1 tag=TAG20090723T141936 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08

Finished backup at 23-JUL-09

RMAN> EXIT;

Recovery Manager complete.

[oracle@labdb ~]$

Executando um backup que será armazenado por 1 ano, independente do RETENTION.

[oracle@labdb ~]$ rman CATALOG=RMAN_USER/RMAN_USER@ORCL TARGET /

Recovery Manager: Release 11.1.0.7.0 - Production on Thu Jul 23 14:25:20 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1217465568)

connected to recovery catalog database

RMAN> BACKUP DATABASE KEEP UNTIL TIME='SYSDATE+366';

Starting backup at 23-JUL-09

current log archived

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=184 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=188 device type=DISK

backup will be obsolete on date 24-JUL-10

archived logs required to recover from this backup will be backed up

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00002 name=/u01/app/oradata/ORCL/sysaux01.dbf

input datafile file number=00001 name=/u01/app/oradata/ORCL/system01.dbf

input datafile file number=00012 name=/u01/app/oradata/ORCL/tbs_rman01.dbf

input datafile file number=00009 name=/u01/app/oradata/ORCL/OCMS_orasdpls.dbf

input datafile file number=00007 name=/u01/app/oradata/ORCL/users02.dbf

input datafile file number=00010 name=/u01/app/oradata/ORCL/OCMS_orasdpsds.dbf

channel ORA_DISK_1: starting piece 1 at 23-JUL-09

channel ORA_DISK_2: starting compressed full datafile backup set

channel ORA_DISK_2: specifying datafile(s) in backup set

input datafile file number=00003 name=/u01/app/oradata/ORCL/undotbs01.dbf

input datafile file number=00004 name=/u01/app/oradata/ORCL/users01.dbf

input datafile file number=00005 name=/u01/app/oradata/ORCL/example01.dbf

input datafile file number=00011 name=/u01/app/oradata/ORCL/rman01.dbf

input datafile file number=00006 name=/u01/app/oradata/ORCL/m_estudo.dbf

input datafile file number=00008 name=/u01/app/oradata/ORCL/OCMS_orasdpxdms.dbf

channel ORA_DISK_2: starting piece 1 at 23-JUL-09

channel ORA_DISK_2: finished piece 1 at 23-JUL-09

piece handle=/u02/backup/ORCL_20090723_33_1 tag=TAG20090723T142643 comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 00:02:27

channel ORA_DISK_1: finished piece 1 at 23-JUL-09

piece handle=/u01/backup/ORCL_20090723_32_1 tag=TAG20090723T142643 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:04:18

using channel ORA_DISK_1

using channel ORA_DISK_2

backup will be obsolete on date 24-JUL-10

archived logs required to recover from this backup will be backed up

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 23-JUL-09

channel ORA_DISK_1: finished piece 1 at 23-JUL-09

piece handle=/u01/backup/ORCL_20090723_34_1 tag=TAG20090723T142643 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

current log archived

using channel ORA_DISK_1

using channel ORA_DISK_2

backup will be obsolete on date 24-JUL-10

archived logs required to recover from this backup will be backed up

channel ORA_DISK_1: starting compressed archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=171 RECID=120 STAMP=692980268

channel ORA_DISK_1: starting piece 1 at 23-JUL-09

channel ORA_DISK_1: finished piece 1 at 23-JUL-09

piece handle=/u01/backup/ORCL_20090723_35_1 tag=TAG20090723T142643 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

using channel ORA_DISK_1

using channel ORA_DISK_2

backup will be obsolete on date 24-JUL-10

archived logs required to recover from this backup will be backed up

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_1: starting piece 1 at 23-JUL-09

channel ORA_DISK_1: finished piece 1 at 23-JUL-09

piece handle=/u01/backup/ORCL_20090723_36_1 tag=TAG20090723T142643 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

Finished backup at 23-JUL-09

RMAN> EXIT;

Recovery Manager complete.

[oracle@labdb ~]$

 

Ricardo Portilho Proni

Ricardo Portilho Proni

Com 20 anos de experiência profissional, Oracle ACE Member – eleito pela Oracle Corporation um dos maiores especialistas do mundo em Oracle Database- Trabalhou em grande parte dos maiores bancos de dados Oracle do Brasil. Certificado em Oracle, SQL Server, DB2, MySQL, Sybase e Websphere. Conselheiro do GPO e do GUOB, palestrante do ENPO, GUOB Tech Day e Oracle Open World, escritor da Revista SQL Magazine e Instrutor na Nerv.

Comentário(s) da Comunidade

  1. Cleiton
    Comentar

    Olá…

    Lembrando que se não for passada a opção NOLOGS todos os archives serão mantidos para sempre também… 🙂

    Para utilizar esta opção, o backup terá q ser feito com o banco em estado mount.

  2. Ricardo Portilho Proni
    Comentar

    Oi Cleiton, blz?

    Bem lembrado sobre o NOLOGS. E eu tive uma siatuação que em 9.2.0.8 o NOLOGS era aceito com o banco aberto, mas simplesmente continuou a guardar os Archives. No 10g já passou a funcionar bem, no mesmo banco.

    Obrigado pelo comentário !
    Abraço !

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Marcações:
plugins premium WordPress