oracle 10g rman备份与恢复之三(二)
420 inc0_1co7jn4l_20130421
[oracle@redhat rmanback]$ ll
total 1095796
-rw-r--r-- 1 oracle oinstall 1555 Apr 21 02:45 backl0.log
-rw-r----- 1 oracle oinstall 559783936 Apr 20 11:36 full_20130420
-rw-r----- 1 oracle oinstall 561201152 Apr 21 02:44 inc0_1co7jn4l_20130421
[oracle@redhat rmanback]$ cat backl0.log
Recovery Manager: Release 10.2.0.1.0 - Production on 星期日 4月 21 02:38:11 2013
Copyright (c) 1982, 2005,
Oracle. All rights reserved.
connected to target database: WOLF (DBID=3778783462)
connected to recovery catalog database
RMAN> run{
2> allocate channel cha1 type disk;
3> backup
4> incremental level 0
5> format "/oracle/ora10g/rmanback/inc0_%u_%T"
6> tag monday_inc0
7> database;
8> release channel cha1;
9> }
10>
11>
allocated channel: cha1
channel cha1: sid=135 devtype=DISK
Starting backup at 21-4月 -13
channel cha1: starting incremental level 0 datafile backupset
channel cha1: specifying datafile(s) in backupset
input datafile fno=00001 name=/oracle/ora10g/oradata/wolf/system01.dbf
input datafile fno=00003 name=/oracle/ora10g/oradata/wolf/sysaux01.dbf
input datafile fno=00002 name=/oracle/ora10g/oradata/wolf/undotbs01.dbf
input datafile fno=00005 name=/oracle/ora10g/oradata/wolf/rmanwolf.dbf
input datafile fno=00004 name=/oracle/ora10g/oradata/wolf/users01.dbf
channel cha1: starting piece 1 at 21-4月 -13
channel cha1: finished piece 1 at 21-4月 -13
piece handle=/oracle/ora10g/rmanback/inc0_1co7jn4l_20130421 tag=MONDAY_INC0 comment=NONE
channel cha1: backup set complete, elapsed time: 00:06:45
Finished backup at 21-4月 -13
Starting Control File and SPFILE Autobackup at 21-4月 -13
piece handle=/oracle/ora10g/flash_recovery_area/WOLF/autobackup/2013_04_21/o1_mf_s_813293099_8q72qj4l_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 21-4月 -13
released channel: cha1
Recovery Manager complete.
[oracle@redhat rmanback]$
上面的命令最好指定全路径，包括rman
[oracle@redhat rmanback]$ which rman
/oracle/ora10g/product/10.2.0/db_1/bin/rman
全路径
/oracle/ora10g/product/10.2.0/db_1/bin/rman target / catalog rman/rman msglog=/oracle/ora10g/rmanback/backl0.log cmdfile=/oracle/ora10g/script/bakl0
1及和2及备份命令如下
/oracle/ora10g/product/10.2.0/db_1/bin/rman target / catalog rman/rman msglog=/oracle/ora10g/rmanback/backl1.log cmdfile=/oracle/ora10g/script/bakl1
/oracle/ora10g/product/10.2.0/db_1/bin/rman target / catalog rman/rman msglog=/oracle/ora10g/rmanback/backl2.log cmdfile=/oracle/ora10g/script/bakl2
----------------------------------------------------------------------------------------------
计划任务crontab
root执行
cron文件语法:
分 小时 日 月 星期 命令
0-59 0-23 1-31 1-12 0-6 command (取值范围,0表示周日一般一行对应一个任务)
使用root用户编辑
crontab -e -u oracle 指定为oracle用户编辑计划任务
编辑完以后
重新启动crontab
service crond restart