RMAN> report schema;
Report of database schema for database with db_unique_name ACME
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 790 SYSTEM *** +DATA/ACME/DATAFILE/system.266.1044480131
2 358 EXAMPLE *** +DATA/ACME/DATAFILE/example.257.1044478425
3 1190 SYSAUX *** +DATA/ACME/DATAFILE/sysaux.258.1044478471
4 90 UNDOTBS1 *** +DATA/ACME/DATAFILE/undotbs1.260.848598093
5 100 TBS_1 *** +DATA/ACME/DATAFILE/tbs_1.268.1043868835
6 5 USERS *** +DATA/ACME/DATAFILE/users.259.848598091
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 162 TEMP 32767 +DATA/ACME/TEMPFILE/temp.265.848598163
RMAN> BACKUP DATAFILE 3 SECTION SIZE 200M TAG 'SECTION 200m';
Starting backup at 14-JUL-20
using channel ORA_DISK_1
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=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 1 through 25600
channel ORA_DISK_1: starting piece 1 at 14-JUL-20
channel ORA_DISK_1: finished piece 1 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.296.1045766907 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
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=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 25601 through 51200
channel ORA_DISK_1: starting piece 2 at 14-JUL-20
channel ORA_DISK_1: finished piece 2 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.292.1045766921 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
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=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 51201 through 76800
channel ORA_DISK_1: starting piece 3 at 14-JUL-20
channel ORA_DISK_1: finished piece 3 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.297.1045766937 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
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=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 76801 through 102400
channel ORA_DISK_1: starting piece 4 at 14-JUL-20
channel ORA_DISK_1: finished piece 4 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.281.1045766953 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
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=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 102401 through 128000
channel ORA_DISK_1: starting piece 5 at 14-JUL-20
channel ORA_DISK_1: finished piece 5 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.282.1045766967 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
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=+DATA/ACME/DATAFILE/sysaux.258.1044478471
backing up blocks 128001 through 152320
channel ORA_DISK_1: starting piece 6 at 14-JUL-20
channel ORA_DISK_1: finished piece 6 at 14-JUL-20
piece handle=+FRA/ACME/BACKUPSET/2020_07_14/nnndf0_section 200m_0.270.1045766975 tag=SECTION 200M comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 14-JUL-20
Starting Control File and SPFILE Autobackup at 14-JUL-20
piece handle=+FRA/ACME/AUTOBACKUP/2020_07_14/s_1045766982.262.1045766983 comment=NONE
Finished Control File and SPFILE Autobackup at 14-JUL-20
RMAN>
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
47 B A A DISK 14-JUL-20 1 1 NO TAG20200714T182628
48 B F A DISK 14-JUL-20 1 1 NO TAG20200714T182629
49 B A A DISK 14-JUL-20 1 1 NO TAG20200714T182907
50 B F A DISK 14-JUL-20 1 1 NO TAG20200714T182910
51 B F A DISK 14-JUL-20 6 1 NO SECTION 200M
52 B F A DISK 14-JUL-20 1 1 NO TAG20200714T184942
RMAN> list backupset 51;
RMAN> backup datafile 1 SECTION SIZE 100M TAG 'SYSTEM SECTION 100M';
No hay comentarios:
Publicar un comentario