rman备份表空间

RMAN> backup tablespace ICMLFQ32;


Starting backup at 10-SEP-13
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=00005 name=/oradata/portaldb_ICMLFQ32_01.dbf
channel ORA_DISK_1: starting piece 1 at 10-SEP-13
channel ORA_DISK_1: finished piece 1 at 10-SEP-13
piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_nnndf_TAG20130910T184558_92zltppr_.bkp tag=TAG20130910T184558 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-SEP-13

RMAN> list backup of database;




List of Backup Sets
===================




BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    979.52M    DISK        00:01:28     10-SEP-13      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T183137
        Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_nnndf_TAG20130910T183137_92zkzt2y_.bkp
  List of Datafiles in backup set 4
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1133009    10-SEP-13 /opt/oracle/oradata/portaldb/system01.dbf
  2       Full 1133009    10-SEP-13 /opt/oracle/oradata/portaldb/sysaux01.dbf
  3       Full 1133009    10-SEP-13 /opt/oracle/oradata/portaldb/undotbs01.dbf
  4       Full 1133009    10-SEP-13 /opt/oracle/oradata/portaldb/users01.dbf
  5       Full 1133009    10-SEP-13 /oradata/portaldb_ICMLFQ32_01.dbf
  6       Full 1133009    10-SEP-13 /oradata/portaldb_ICMLNF32_01.dbf
  7       Full 1133009    10-SEP-13 /oradata/portaldb_ICMSFQ04_01.dbf
  8       Full 1133009    10-SEP-13 /oradata/portaldb_ICMVFQ04_01.dbf
  9       Full 1133009    10-SEP-13 /oradata/portaldb_ICMLSNDX_01.dbf


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    979.57M    DISK        00:01:23     10-SEP-13      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T183832
        Piece Name: /oradata/backup/bak_0aojh5d8_1_1
  List of Datafiles in backup set 6
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1133254    10-SEP-13 /opt/oracle/oradata/portaldb/system01.dbf
  2       Full 1133254    10-SEP-13 /opt/oracle/oradata/portaldb/sysaux01.dbf
  3       Full 1133254    10-SEP-13 /opt/oracle/oradata/portaldb/undotbs01.dbf
  4       Full 1133254    10-SEP-13 /opt/oracle/oradata/portaldb/users01.dbf
  5       Full 1133254    10-SEP-13 /oradata/portaldb_ICMLFQ32_01.dbf
  6       Full 1133254    10-SEP-13 /oradata/portaldb_ICMLNF32_01.dbf
  7       Full 1133254    10-SEP-13 /oradata/portaldb_ICMSFQ04_01.dbf
  8       Full 1133254    10-SEP-13 /oradata/portaldb_ICMVFQ04_01.dbf
  9       Full 1133254    10-SEP-13 /oradata/portaldb_ICMLSNDX_01.dbf


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    1.03M      DISK        00:00:00     10-SEP-13      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T184558
        Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_nnndf_TAG20130910T184558_92zltppr_.bkp
  List of Datafiles in backup set 8
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 1133791    10-SEP-13 /oradata/portaldb_ICMLFQ32_01.dbf