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 1040 SYSTEM YES +DATA/orcl/datafile/system.260.854191187
2 2100 SYSAUX NO +DATA/orcl/datafile/sysaux.268.854191187
3 775 UNDOTBS1 YES +DATA/orcl/datafile/undotbs1.263.854191187
4 911 USERS NO +DATA/orcl/datafile/users.267.854191187
5 345 EXAMPLE NO +DATA/orcl/datafile/example.259.854191305
6 575 UNDOTBS2 YES +DATA/orcl/datafile/undotbs2.258.854191485
7 100 EPORT_TAB_S NO +DATA/orcl/datafile/eport_tab_s.271.854271185
8 13300 EPORT_TAB_L NO +DATA/orcl/datafile/eport_tab_l.272.854271187
9 2400 EPORT_FEE_IDX NO +DATA/orcl/datafile/eport_fee_idx.273.854271189
10 9800 EPORT_TAB_XL NO +DATA/orcl/datafile/eport_tab_xl.274.854271191
11 7000 EPORT_FEE_TAB NO +DATA/orcl/datafile/eport_fee_tab.275.854271195
12 800 EPORT_IDX_S NO +DATA/orcl/datafile/eport_idx_s.276.854271197
13 4300 EPORT_IDX_L NO +DATA/orcl/datafile/eport_idx_l.277.854271199
14 1200 JABLOG NO +DATA/orcl/datafile/jablog.278.854271201
15 400 JABLOG_BLOB NO +DATA/orcl/datafile/jablog_blob.279.854271203
16 10300 DPE NO +DATA/orcl/datafile/dpe.280.854271207
17 12400 EPORT_TAB_L NO +DATA/orcl/datafile/eport_tab_l.281.854272341
18 9200 EPORT_TAB_XL NO +DATA/orcl/datafile/eport_tab_xl.282.854272371
19 50 TESTT NO +DATA/orcl/datafile/tes150820t
20 100 TST_150820 NO +DATA/orcl/datafile/tst_150820.284.888246997
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 2379 TEMP 32767 +DATA/orcl/tempfile/temp.264.854191301
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/product/12.1.0/dbhome_1/dbs/snapcf_orcl2.f'; # default
RMAN> list backupset;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 64.40G DISK 00:10:11 27-AUG-15
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20150827T134936
Piece Name: /opt/oracle/admin/orcl/backup/df_backup_02qfle7h_1_1
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/system.260.854191187
2 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/sysaux.268.854191187
3 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/undotbs1.263.854191187
4 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/users.267.854191187
5 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/example.259.854191305
6 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/undotbs2.258.854191485
7 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/eport_tab_s.271.854271185
8 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/eport_tab_l.272.854271187
9 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/eport_fee_idx.273.854271189
10 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/eport_tab_xl.274.854271191
11 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/eport_fee_tab.275.854271195
12 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/eport_idx_s.276.854271197
13 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/eport_idx_l.277.854271199
14 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/jablog.278.854271201
15 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/jablog_blob.279.854271203
16 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/dpe.280.854271207
17 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/eport_tab_l.281.854272341
18 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/eport_tab_xl.282.854272371
19 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/tes150820t
20 Full 9676942697525 27-AUG-15 +DATA/orcl/datafile/tst_150820.284.888246997
RMAN>