RMAN的完全备份

---#不包括归档日志
----完全备份（指定目录）

1. RMAN> backup as backupset format '/home/oracle/data_base%U' database;
   
2. 
   
3. Starting backup at 19-DEC-16
   
4. using channel ORA_DISK_1
   
5. channel ORA_DISK_1: starting full datafile backup set
   
6. channel ORA_DISK_1: specifying datafile(s) in backup set
   
7. input datafile file number=00001 name=/u01/app/oracle/oradata/ORA11GR2/system01.dbf
   
8. input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
   
9. input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11GR2/example01.dbf
   
10. input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
    
11. input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11GR2/users01.dbf
    
12. channel ORA_DISK_1: starting piece 1 at 19-DEC-16
    
13. channel ORA_DISK_1: finished piece 1 at 19-DEC-16
    
14. piece handle=/home/oracle/data_base06rnrut6_1_1 tag=TAG20161219T120142 comment=NONE
    
15. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
    
16. channel ORA_DISK_1: starting full datafile backup set
    
17. channel ORA_DISK_1: specifying datafile(s) in backup set
    
18. including current control file in backup set
    
19. including current SPFILE in backup set
    
20. channel ORA_DISK_1: starting piece 1 at 19-DEC-16
    
21. channel ORA_DISK_1: finished piece 1 at 19-DEC-16
    
22. piece handle=/home/oracle/data_base07rnruu9_1_1 tag=TAG20161219T120142 comment=NONE
    
23. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    
24. Finished backup at 19-DEC-16
    
25. 
    
26. RMAN>

---完全备份

1. RMAN> backup as backupset database;
   
2. 
   
3. Starting backup at 19-DEC-16
   
4. using target database control file instead of recovery catalog
   
5. allocated channel: ORA_DISK_1
   
6. channel ORA_DISK_1: SID=142 device type=DISK
   
7. channel ORA_DISK_1: starting full datafile backup set
   
8. channel ORA_DISK_1: specifying datafile(s) in backup set
   
9. input datafile file number=00001 name=/u01/app/oracle/oradata/ORA11GR2/system01.dbf
   
10. input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
    
11. input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11GR2/example01.dbf
    
12. input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
    
13. input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11GR2/users01.dbf
    
14. channel ORA_DISK_1: starting piece 1 at 19-DEC-16
    
15. channel ORA_DISK_1: finished piece 1 at 19-DEC-16
    
16. piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/03rnrso3_1_1 tag=TAG20161219T112451 comment=NONE
    
17. channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
    
18. channel ORA_DISK_1: starting full datafile backup set
    
19. channel ORA_DISK_1: specifying datafile(s) in backup set
    
20. including current control file in backup set
    
21. including current SPFILE in backup set
    
22. channel ORA_DISK_1: starting piece 1 at 19-DEC-16
    
23. channel ORA_DISK_1: finished piece 1 at 19-DEC-16
    
24. piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/04rnrsqe_1_1 tag=TAG20161219T112451 comment=NONE
    
25. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    
26. Finished backup at 19-DEC-16
    
27. 
    
28. RMAN>

---查看目录

1. RMAN> list backup of database
   
2. 2> ;
   
3. 
   
4. 
   
5. List of Backup Sets
   
6. ===================
   
7. 
   
8. 
   
9. BS Key Type LV Size Device Type Elapsed Time Completion Time
   
10. ------- ---- -- ---------- ----------- ------------ ---------------
    
11. 2 Full 1.17G DISK 00:01:15 19-DEC-16
    
12.         BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20161219T112451
    
13.         Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/03rnrso3_1_1
    
14.   List of Datafiles in backup set 2
    
15.   File LV Type Ckp SCN Ckp Time Name
    
16.   ---- -- ---- ---------- --------- ----
    
17.   1 Full 1294980 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/system01.dbf
    
18.   2 Full 1294980 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
    
19.   3 Full 1294980 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
    
20.   4 Full 1294980 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/users01.dbf
    
21.   5 Full 1294980 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/example01.dbf
    
22. 
    
23. BS Key Type LV Size Device Type Elapsed Time Completion Time
    
24. ------- ---- -- ---------- ----------- ------------ ---------------
    
25. 4 Full 1.17G DISK 00:00:33 19-DEC-16
    
26.         BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20161219T120142
    
27.         Piece Name: /home/oracle/data_base06rnrut6_1_1
    
28.   List of Datafiles in backup set 4
    
29.   File LV Type Ckp SCN Ckp Time Name
    
30.   ---- -- ---- ---------- --------- ----
    
31.   1 Full 1296744 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/system01.dbf
    
32.   2 Full 1296744 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
    
33.   3 Full 1296744 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
    
34.   4 Full 1296744 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/users01.dbf
    
35.   5 Full 1296744 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/example01.dbf
    
36. 
    
37. RMAN>

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

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