RMAN进行备份恢复(九)
13_06_12/o1_mf_ncsnf_TAG20130612T125054_8vhzxlf2_.bkp tag=TAG20130612T125054 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
Finished backup at 12-JUN-13
--我们可以看到Oracle帮我们把数据文件,控制文件还有spfile都备份了,备份在了目录:/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/中
--还可以对备份进行压缩,打开多个通道,这里的通道相当于进程,并且会创建对应的Session,同时运行多条命令等操作。
--这时多个通道会同时处理多个操作。
RMAN> run{
2> allocate channel c1 device type disk;
3> allocate channel c2 device type disk;
4> backup as compressed backupset database;
5> }
RMAN> run{
2> allocate channel c1 device type disk;
3> allocate channel c2 device type disk;
4> backup as compressed backupset database;
5> }
released channel: ORA_DISK_1--有私有通道的时候会释放通道,RMAN起起来的时候默认会有一个公共通道,私有通道执行完就自动释放了。
allocated channel: c1
channel c1: sid=148 devtype=DISK
allocated channel: c2
channel c2: sid=136 devtype=DISK
Starting backup at 12-JUN-13
channel c1: starting compressed full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00004 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf
input datafile fno=00003 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf
input datafile fno=00006 name=/home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_IDX01.DBF
channel c1: starting piece 1 at 12-JUN-13
channel c2: starting compressed full datafile backupset
channel c2: specifying datafile(s) in backupset
input datafile fno=00001 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf
input datafile fno=00007 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/tbs_data.dbf
input datafile fno=00002 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf
input datafile fno=00005 name=/home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_DATA01.DBF
channel c2: starting piece 1 at 12-JUN-13
user interrupt received
Finished backup at 12-JUN-13
user interrupt received
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03099: job cancelled at user request
--备份完,我们可以查看备份集列表:如果不控制备份集大小,一个通道会产生一个备份集。
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 2.30G DISK 00:06:17 12-JUN-13
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20130612T125054
Piece Name: /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_nnndf_TAG20130612T125054_8vhzkgdt_.bkp
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf
2 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf
3 Full 13229464105956 12-JUN-13 /home/oracle/oracle/product/10.2