$ rman target /
RMAN> report schema;
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 900 SYSTEM *** /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hhqvrdhj_.dbf
2 358 EXAMPLE *** /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_hhqvv3w9_.dbf
3 1500 SYSAUX *** /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_9qwm8fym_.dbf
4 75 UNDOTBS1 *** /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_9qwmf6kp_.dbf
5 100 SYSTEM *** /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hgr0bw9h_.dbf
6 5 USERS *** /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_hhqvv3ws_.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 252 TEMP 32767 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_9qwmhgnm_.tmp
NOTA:
SE RECOMIENDA LIMITAR EL TAMAÑO DE LAS PIEZAS DE BACKUP EN POCOS GIGAS
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50M;
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50 M;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
RMAN> backup datafile 1;
Starting backup at 09-JUL-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=78 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hhqvrdhj_.dbf
channel ORA_DISK_1: starting piece 1 at 09-JUL-20
channel ORA_DISK_1: finished piece 1 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdr1s0_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 2 at 09-JUL-20
channel ORA_DISK_1: finished piece 2 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdr8rq_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 3 at 09-JUL-20
channel ORA_DISK_1: finished piece 3 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrhrx_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 4 at 09-JUL-20
channel ORA_DISK_1: finished piece 4 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrls5_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 5 at 09-JUL-20
channel ORA_DISK_1: finished piece 5 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrmt5_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 6 at 09-JUL-20
channel ORA_DISK_1: finished piece 6 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrpt3_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 7 at 09-JUL-20
channel ORA_DISK_1: finished piece 7 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrqtt_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 8 at 09-JUL-20
channel ORA_DISK_1: finished piece 8 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrtto_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 9 at 09-JUL-20
channel ORA_DISK_1: finished piece 9 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrvvd_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 10 at 09-JUL-20
channel ORA_DISK_1: finished piece 10 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdryvg_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 11 at 09-JUL-20
channel ORA_DISK_1: finished piece 11 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrzw1_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 12 at 09-JUL-20
channel ORA_DISK_1: finished piece 12 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds2x7_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 13 at 09-JUL-20
channel ORA_DISK_1: finished piece 13 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds5x9_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: starting piece 14 at 09-JUL-20
channel ORA_DISK_1: finished piece 14 at 09-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds6ws_.bkp tag=TAG20200709T191457 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:38
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_1045336536_hjhds8gl_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JUL-20
RMAN>
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
68 B F A DISK 09-JUL-20 1 1 NO TAG20200709T191033
69 B F A DISK 09-JUL-20 14 1 NO TAG20200709T191457
70 B F A DISK 09-JUL-20 1 1 NO TAG20200709T191536
RMAN> list backupset 69;
List of Backup Pieces for backup set 69 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
70 1 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdr1s0_.bkp
71 2 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdr8rq_.bkp
72 3 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrhrx_.bkp
73 4 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrls5_.bkp
74 5 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrmt5_.bkp
75 6 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrpt3_.bkp
76 7 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrqtt_.bkp
77 8 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrtto_.bkp
78 9 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrvvd_.bkp
79 10 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdryvg_.bkp
80 11 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhdrzw1_.bkp
81 12 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds2x7_.bkp
82 13 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds5x9_.bkp
83 14 AVAILABLE /u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_09/o1_mf_nnndf_TAG20200709T191457_hjhds6ws_.bkp
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK clear;
No hay comentarios:
Publicar un comentario