MERCADOS FINANCIEROS

jueves, 20 de febrero de 2020

RMAN COPIES REDUNDANCY

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

RMAN> BACKUP AS BACKUPSET DEVICE TYPE SBT COPIES 2 INCREMENTAL LEVEL 0 DATABASE;



REDUNDANCIA EN DISCO FILE SYSTEM
RMAN

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
RMAN> run
{
allocate channel c1 device type disk    
format "/u01/backup/%U";
sql 'alter system archive log current';
backup datafile 6;
}2> 3> 4> 5> 6> 7> 

released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=78 device type=DISK

sql statement: alter system archive log current

Starting backup at 09-JUL-20
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_hhqvv3ws_.dbf
channel c1: starting piece 1 at 09-JUL-20
channel c1: finished piece 1 at 09-JUL-20 with 2 copies and tag TAG20200709T190102
piece handle=/u01/backup/26v4t3je_1_1 comment=NONE
piece handle=/u01/backup/26v4t3je_1_2 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-JUL-20

Starting Control File and SPFILE Autobackup at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2020_07_09/o1_mf_s_1045335665_hjhcy1ql_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUL-20
released channel: c1


RMAN> list backup summary; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 49 B 0 A DISK 30-JUN-20 1 1 NO TAG20200630T190839 50 B 1 A DISK 30-JUN-20 1 1 NO TAG20200630T190839 52 B 1 A DISK 30-JUN-20 1 1 NO TAG20200630T203911 53 B F A DISK 30-JUN-20 1 1 NO TAG20200630T203947 54 B F A DISK 02-JUL-20 1 1 NO TAG20200702T204640 55 B A A DISK 04-JUL-20 1 1 NO BEFORE UPGRADE 56 B F A DISK 04-JUL-20 1 1 NO TAG20200704T112235 57 B A A DISK 04-JUL-20 1 1 NO BEFORE UPGRADE 58 B F A DISK 04-JUL-20 1 1 NO TAG20200704T112847 59 B F A DISK 04-JUL-20 1 1 NO CONTROLFILE 60 B F A DISK 04-JUL-20 1 1 NO TAG20200704T113807 61 B F A DISK 09-JUL-20 1 1 NO TAG20200709T184559 62 B A A DISK 09-JUL-20 1 1 NO TAG20200709T184635 63 B F A DISK 09-JUL-20 1 1 NO TAG20200709T184721 64 B A A DISK 09-JUL-20 1 1 NO TAG20200709T185130 65 B F A DISK 09-JUL-20 1 1 NO TAG20200709T185236 66 B F A DISK 09-JUL-20 1 2 NO TAG20200709T190102 67 B F A DISK 09-JUL-20 1 1 NO TAG20200709T190105
RMAN> list backupset 66;


List of Backup Sets
===================


BS Key  Type LV Size
------- ---- -- ----------
66      Full    2.21M
  List of Datafiles in backup set 66
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 4690737    09-JUL-20 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_hhqvv3ws_.dbf

  Backup Set Copy #2 of backup set 66
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     09-JUL-20       NO         TAG20200709T190102

    List of Backup Pieces for backup set 66 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    67      1   AVAILABLE   /u01/backup/26v4t3je_1_2

  Backup Set Copy #1 of backup set 66
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     09-JUL-20       NO         TAG20200709T190102

    List of Backup Pieces for backup set 66 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    66      1   AVAILABLE   /u01/backup/26v4t3je_1_1


RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK clear;
OTRO EJEMPLO
RMAN> run
2> {
3> allocate channel c1 device type disk    
4> format "/u01/backup/%U";
5> sql 'alter system archive log current';
6> backup datafile 4;
7> }

released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=32 device type=DISK

sql statement: alter system archive log current

Starting backup at 30-NOV-20
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_9qwmf6kp_.dbf
channel c1: starting piece 1 at 30-NOV-20
channel c1: finished piece 1 at 30-NOV-20 with 2 copies and tag TAG20201130T184408
piece handle=/u01/backup/33vgrcvp_1_1 comment=NONE
piece handle=/u01/backup/33vgrcvp_1_2 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-NOV-20

Starting Control File and SPFILE Autobackup at 30-NOV-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2020_11_30/o1_mf_s_1057862650_hwc0ybfs_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 30-NOV-20
released channel: c1

RMAN> 

BACKUP COPIES 2 +ASM

RMAN> run 2> { 3> allocate channel c1 device type disk format "/u01/backup/%U"; 4> backup datafile 1; 5> } allocated channel: c1 channel c1: SID=46 device type=DISK Starting backup at 12-MAY-21 channel c1: starting full datafile backup set channel c1: specifying datafile(s) in backup set input datafile file number=00001 name=+DATA/ACME/DATAFILE/system.257.1071956095 channel c1: starting piece 1 at 12-MAY-21 channel c1: finished piece 1 at 12-MAY-21 with 2 copies and tag TAG20210512T211850 piece handle=/u01/backup/2fvuml1q_1_1 comment=NONE piece handle=/u01/backup/2fvuml1q_1_2 comment=NONE channel c1: backup set complete, elapsed time: 00:00:25 Finished backup at 12-MAY-21 Starting Control File and SPFILE Autobackup at 12-MAY-21 piece handle=+FRA/ACME/AUTOBACKUP/2021_05_12/s_1072387155.348.1072387157 comment=NONE Finished Control File and SPFILE Autobackup at 12-MAY-21 released channel: c1


List of Backup Sets =================== BS Key Type LV Size ------- ---- -- ---------- 66 Full 668.77M List of Datafiles in backup set 66 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 5661425 12-MAY-21 +DATA/ACME/DATAFILE/system.257.1071956095 Backup Set Copy #1 of backup set 66 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:16 12-MAY-21 NO TAG20210512T211850 List of Backup Pieces for backup set 66 Copy #1 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 77 1 AVAILABLE /u01/backup/2fvuml1q_1_1 Backup Set Copy #2 of backup set 66 Device Type Elapsed Time Completion Time Compressed Tag ----------- ------------ --------------- ---------- --- DISK 00:00:16 12-MAY-21 NO TAG20210512T211850 List of Backup Pieces for backup set 66 Copy #2 BP Key Pc# Status Piece Name ------- --- ----------- ---------- 78 1 AVAILABLE /u01/backup/2fvuml1q_1_2 RMAN>




No hay comentarios: