MERCADOS FINANCIEROS

miércoles, 15 de abril de 2020

BACKUP RMAN KEEP FOREVER

ESTOS COMANDOS SOLO FUNCIONAN CUANDO SE UTILIZA UNTIL TIME


RMAN> backup database format '/u01/backup/%U' tag 'BACKUP FULL' keep until time 'sysdate + 30'
2> ;

Starting backup at 30-NOV-20
current log archived

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=32 device type=DISK
backup will be obsolete on date 30-DEC-20
archived logs required to recover from this backup will be backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_9qwm8fym_.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_9qwmbsr6_.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_9qwmf6kp_.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_9qwmmkbr_.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_htct3xg4_.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_9qwmf54t_.dbf
channel ORA_DISK_1: starting piece 1 at 30-NOV-20


ESTOS COMANDOS SOLO FUNCIONAN CUANDO SE TIENE UN CATALOGO DE RMAN 

RMAN> backup datafile 1 keep forever;

Starting backup at 30-NOV-20
current log archived

using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/30/2020 19:03:40
RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog

RMAN> 


RMAN> change backupset 77,78,79 keep until time 'sysdate + 40';

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=74 device type=DISK
keep attributes for the backup are changed
backup will be obsolete on date 09-JAN-21
backup set key=77 RECID=77 STAMP=1057863668
keep attributes for the backup are changed
backup will be obsolete on date 09-JAN-21
backup set key=78 RECID=78 STAMP=1057863673
keep attributes for the backup are changed
backup will be obsolete on date 09-JAN-21
backup set key=79 RECID=79 STAMP=1057863674

RMAN> 

No hay comentarios: