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:
Publicar un comentario