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

RMAN> backup as backupset format '/home/oracle/data_base%U' database;
Starting backup at 19-DEC-16
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=00001 name=/u01/app/oracle/oradata/ORA11GR2/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11GR2/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11GR2/users01.dbf
channel ORA_DISK_1: starting piece 1 at 19-DEC-16
channel ORA_DISK_1: finished piece 1 at 19-DEC-16
piece handle=/home/oracle/data_base06rnrut6_1_1 tag=TAG20161219T120142 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 19-DEC-16
channel ORA_DISK_1: finished piece 1 at 19-DEC-16
piece handle=/home/oracle/data_base07rnruu9_1_1 tag=TAG20161219T120142 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 19-DEC-16
RMAN>

---完全备份

RMAN> backup as backupset database;
Starting backup at 19-DEC-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=142 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORA11GR2/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11GR2/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11GR2/users01.dbf
channel ORA_DISK_1: starting piece 1 at 19-DEC-16
channel ORA_DISK_1: finished piece 1 at 19-DEC-16
piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/03rnrso3_1_1 tag=TAG20161219T112451 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 19-DEC-16
channel ORA_DISK_1: finished piece 1 at 19-DEC-16
piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/04rnrsqe_1_1 tag=TAG20161219T112451 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 19-DEC-16
RMAN>

---查看目录

RMAN> list backup of database
2> ;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 1.17G DISK 00:01:15 19-DEC-16
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20161219T112451
Piece Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/03rnrso3_1_1
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1294980 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/system01.dbf
2 Full 1294980 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
3 Full 1294980 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
4 Full 1294980 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/users01.dbf
5 Full 1294980 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 1.17G DISK 00:00:33 19-DEC-16
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20161219T120142
Piece Name: /home/oracle/data_base06rnrut6_1_1
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1296744 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/system01.dbf
2 Full 1296744 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
3 Full 1296744 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
4 Full 1296744 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/users01.dbf
5 Full 1296744 19-DEC-16 /u01/app/oracle/oradata/ORA11GR2/example01.dbf
RMAN>

ITPub博客

RMAN的完全备份

最新文章