在不开启rman自动备份控制文件和参数文件下备份system表空间和user表空间的不同之处...

---查看有几个表空间

1. SQL> select TABLESPACE_NAME from Dba_Tablespaces;
   
2. 
   
3. TABLESPACE_NAME
   
4. ------------------------------
   
5. SYSTEM
   
6. SYSAUX
   
7. UNDOTBS1
   
8. TEMP
   
9. USERS
   
10. EXAMPLE
    
11. 
    
12. 6 rows selected.
    
13. 
    
14. SQL>

---备份system表空间

1. RMAN> BACKUP AS BACKUPSET FORMAT '/home/oracle/ts_system_%U' TABLESPACE
   
2. 2> system;
   
3. 
   
4. Starting backup at 16-DEC-16
   
5. using target database control file instead of recovery catalog
   
6. allocated channel: ORA_DISK_1
   
7. channel ORA_DISK_1: SID=146 device type=DISK
   
8. channel ORA_DISK_1: starting full datafile backup set
   
9. channel ORA_DISK_1: specifying datafile(s) in backup set
   
10. input datafile file number=00001 name=/u01/app/oracle/oradata/ORA/system01.dbf
    
11. channel ORA_DISK_1: starting piece 1 at 16-DEC-16
    
12. channel ORA_DISK_1: finished piece 1 at 16-DEC-16
    
13. piece handle=/home/oracle/ts_system_03rnkkb3_1_1 tag=TAG20161216T171827 comment=NONE
    
14. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
    
15. channel ORA_DISK_1: starting full datafile backup set
    
16. channel ORA_DISK_1: specifying datafile(s) in backup set
    
17. including current control file in backup set
    
18. including current SPFILE in backup set
    
19. channel ORA_DISK_1: starting piece 1 at 16-DEC-16
    
20. channel ORA_DISK_1: finished piece 1 at 16-DEC-16
    
21. piece handle=/home/oracle/ts_system_04rnkkbs_1_1 tag=TAG20161216T171827 comment=NONE
    
22. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    
23. Finished backup at 16-DEC-16
    
24. 
    
25. RMAN>

----查看system备份的地址

1. RMAN> list backup of tablespace system;
   
2. 
   
3. 
   
4. List of Backup Sets
   
5. ===================
   
6. 
   
7. 
   
8. BS Key Type LV Size Device Type Elapsed Time Completion Time
   
9. ------- ---- -- ---------- ----------- ------------ ---------------
   
10. 2 Full 638.57M DISK 00:00:18 16-DEC-16
    
11.         BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20161216T171827
    
12.         Piece Name: /home/oracle/ts_system_03rnkkb3_1_1
    
13.   List of Datafiles in backup set 2
    
14.   File LV Type Ckp SCN Ckp Time Name
    
15.   ---- -- ---- ---------- --------- ----
    
16.   1 Full 1021865 16-DEC-16 /u01/app/oracle/oradata/ORA/system01.dbf
    
17. 
    
18. RMAN>

---备份users表空间

1. RMAN> BACKUP AS BACKUPSET FORMAT '/home/oracle/ks/ts_user_%U' TABLESPACE
   
2. 2> users;
   
3. 
   
4. Starting backup at 16-DEC-16
   
5. using channel ORA_DISK_1
   
6. channel ORA_DISK_1: starting full datafile backup set
   
7. channel ORA_DISK_1: specifying datafile(s) in backup set
   
8. input datafile file number=00004 name=/u01/app/oracle/oradata/ORA/users01.dbf
   
9. channel ORA_DISK_1: starting piece 1 at 16-DEC-16
   
10. channel ORA_DISK_1: finished piece 1 at 16-DEC-16
    
11. piece handle=/home/oracle/ks/ts_user_05rnkkj7_1_1 tag=TAG20161216T172247 comment=NONE
    
12. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    
13. Finished backup at 16-DEC-16
    
14. 
    
15. RMAN>
    
    

---查看users表空间地址

1. RMAN> list backup of tablespace users;
   
2. 
   
3. 
   
4. List of Backup Sets
   
5. ===================
   
6. 
   
7. 
   
8. BS Key Type LV Size Device Type Elapsed Time Completion Time
   
9. ------- ---- -- ---------- ----------- ------------ ---------------
   
10. 4 Full 3.29M DISK 00:00:01 16-DEC-16
    
11.         BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20161216T172247
    
12.         Piece Name: /home/oracle/ks/ts_user_05rnkkj7_1_1
    
13.   List of Datafiles in backup set 4
    
14.   File LV Type Ckp SCN Ckp Time Name
    
15.   ---- -- ---- ---------- --------- ----
    
16.   4 Full 1022162 16-DEC-16 /u01/app/oracle/oradata/ORA/users01.dbf
    
17. 
    
18. RMAN>

----两者进行对比

system表空间

1. [oracle@zh ~]$ ls -lh
   
2. total 649M
   
3. drwxr-xr-x 2 oracle oinstall 4.0K Dec 16 17:22 ks
   
4. -rw-r----- 1 oracle oinstall 639M Dec 16 17:18 ts_system_03rnkkb3_1_1
   
5. -rw-r----- 1 oracle oinstall 9.4M Dec 16 17:18 ts_system_04rnkkbs_1_1
   
6. [oracle@zh ~]$

users表空间

1. [oracle@zh ~]$ ls -lh
   
2. total 649M
   
3. drwxr-xr-x 2 oracle oinstall 4.0K Dec 16 17:22 ks
   
4. -rw-r----- 1 oracle oinstall 639M Dec 16 17:18 ts_system_03rnkkb3_1_1
   
5. -rw-r----- 1 oracle oinstall 9.4M Dec 16 17:18 ts_system_04rnkkbs_1_1
   
6. [oracle@zh ~]$

----通过对比就会发现RMAN在备份重要的表空间的时候、会自动备份控制文件和参数文件

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31399171/viewspace-2130823/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31399171/viewspace-2130823/