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 ~]$
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.
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 !