檢視RMAN資訊的三種命令

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>