使用RMAN备份Tablespace

1、查看Tablespace信息

SQL> desc dba_tablespaces
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 BLOCK_SIZE                                NOT NULL NUMBER
 INITIAL_EXTENT                                     NUMBER
 NEXT_EXTENT                                        NUMBER
 MIN_EXTENTS                               NOT NULL NUMBER
 MAX_EXTENTS                                        NUMBER
 MAX_SIZE                                           NUMBER
 PCT_INCREASE                                       NUMBER
 MIN_EXTLEN                                         NUMBER
 STATUS                                             VARCHAR2(9)
 CONTENTS                                           VARCHAR2(9)
 LOGGING                                            VARCHAR2(9)
 FORCE_LOGGING                                      VARCHAR2(3)
 EXTENT_MANAGEMENT                                  VARCHAR2(10)
 ALLOCATION_TYPE                                    VARCHAR2(9)
 PLUGGED_IN                                         VARCHAR2(3)
 SEGMENT_SPACE_MANAGEMENT                           VARCHAR2(6)
 DEF_TAB_COMPRESSION                                VARCHAR2(8)
 RETENTION                                          VARCHAR2(11)
 BIGFILE                                            VARCHAR2(3)
 PREDICATE_EVALUATION                               VARCHAR2(7)
 ENCRYPTED                                          VARCHAR2(3)
 COMPRESS_FOR                                       VARCHAR2(12)

 

SQL> select tablespace_name,contents from dba_tablespaces;

TABLESPACE_NAME                CONTENTS
------------------------------ ---------
SYSTEM                         PERMANENT
SYSAUX                         PERMANENT
UNDOTBS1                       UNDO
TEMP                           TEMPORARY
USERS                          PERMANENT
EXAMPLE                        PERMANENT
EXPIMP                         PERMANENT

7 rows selected.

 2、执行tablespace(example,users)备份

 

RMAN> backup tablespace example,users format '/u01/arcerzhang/tb_exampleAndUsers_%U';

Starting backup at 23-MAR-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=/u01/oradata/poli/example01.dbf
input datafile file number=00004 name=/u01/oradata/poli/users01.dbf
channel ORA_DISK_1: starting piece 1 at 23-MAR-13
channel ORA_DISK_1: finished piece 1 at 23-MAR-13
piece handle=/u01/arcerzhang/tb_exampleAndUsers_0do59h7e_1_1 tag=TAG20130323T232325 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 23-MAR-13

Starting Control File Autobackup at 23-MAR-13
piece handle=/u01/flash_recovery_area/POLI/autobackup/2013_03_23/o1_mf_n_810861862_8nvl99fg_.bkp comment=NONE
Finished Control File Autobackup at 23-MAR-13

 

转载于:https://www.cnblogs.com/arcer/archive/2013/03/23/2977868.html