Query Character Set
Sql> select * from Nls_database_parameters;
Nls_characterset
Al32utf8
Character set is important when backing up, otherwise it will be garbled
One, Level 0 backup (full) Red is to be modified, depending on the location of the personal storage.
[email protected] script]$ cat Db_bak0.rman
Run
{
Configure retention policy to recovery windows of 8 days;
Configure Controlfile autobackup on;
Configure Controlfile autobackup format for device type disk to '/home/oracle/rmanbak/%f ';
Allocate channel CH1 device type disk format '/home/oracle/rmanbak/inc0_%d_%s_%p_%u_%t ';
Backup incremental Level 0 tag= ' Level 0 ' database skip inaccessible filesperset plus archivelog filesperset 20;
Release channel CH1;
}
Allocate channel for maintenance device type disk;
Crosscheck backup;
Delete noprompt expired backup;
Delete NoPrompt obsolete;
Delete noprompt Archivelog until time ' sysdate-30 ';
0-level Run script
[[email protected] script]$ cat exec_0_level.sh
oracle_hostname= oracle122; Export Oracle_hostname
orcl; Export Oracle_sid
Oracle_term=xterm; Export Oracle_term
Path=/usr/sbin: $PATH; export path
path= $ORACLE _home/bin: $PATH; export path
Export date=$ (Date +%y_%m_%d)
Export nls_lang= "simplified Chinese_china". al32utf8
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target sys/sys_admin cmdfile /home/oracle/ Rmanbak/script/db_bak0.rman log /home/oracle/rmanbak/script/log/rman_$date.log append
Second, Level 1 backup (incremental)
[email protected] script]$ cat Db_bak1.rman
Run
{
Configure retention policy to recovery windows of 8 days;
Configure Controlfile autobackup on;
Configure Controlfile autobackup format for device type disk to '/home/oracle/rmanbak/%F ';
Allocate channel CH1 device type disk format '/home/oracle/rmanbak/inc1_%d_%s_%p_%u_%t ';
Backup incremental Level 1 tag= ' Level 1 ' database skip inaccessible filesperset plus archivelog filesperset 20;
Release channel CH1;
}
Allocate channel for maintenance device type disk;
Crosscheck backup;
Delete noprompt expired backup;
Delete NoPrompt obsolete;
Delete noprompt Archivelog until time ' sysdate-30 ';
1-level Run script
[[email protected] script]$ cat exec_1_level.sh
Oracle_hostname= export oracle_hostname
Oracle_base=/u01/app ; export Oracle_ BASE
Oracle_homeORCL ; export Oracle_sid
Oracle_term=xterm; Export Oracle_term
Path=/usr/sbin: $PATH; export path
path= $ORACLE _home/bin: $PATH; export path
Export date=$ (Date +%y_%m_%d)
Export nls_lang= "simplified Chinese_china". al32utf8
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target sys/sys_admin cmdfile /home/oracle/ rmanbak/script/db_bak1.rman log /home/oracle/rmanbak/script/log/rman_$date.log Append
Level 2 backup (append to current backup from level 0)
[email protected] script]$ cat Db_bak2.rman
Run
{
Configure retention policy to recovery windows of 8 days;
Configure Controlfile autobackup on;
Configure Controlfile autobackup format for device type disk to '/home/oracle/rmanbak/%f ';
Allocate channel CH1 device type disk format '/home/oracle/rmanbak/inc2_%d_%s_%p_%u_%t ';
Backup incremental Level 2 tag= ' Level 2 ' database skip inaccessible filesperset plus archivelog filesperset Delete a ll input;
Release channel CH1;
}
Allocate channel for maintenance device type disk;
Crosscheck backup;
Delete noprompt expired backup;
Delete NoPrompt obsolete;
2-level Run script
[[email protected] script]$ cat exec_2_level.sh
Oracle_hostname=; Export Oracle_hostname
Oracle_base=/u01/app/oracle/product/11.2.0/dbhome_1 ; Export Oracle_home
Oracle_sid=ORCL ; export Oracle_sid
oracle_term= Xterm Export Oracle_term
Path=/usr/sbin: $PATH; export path
path= $ORACLE _home/bin: $PATH; export path
Export date=$ (Date +%y_%m_%d)
Export nls_lang= "simplified Chinese_china". al32utf8
/u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target sys/sys_admin cmdfile /home/oracle/ rmanbak/script/db_bak2.rman log /home/oracle/rmanbak/script/log/rman_$date.log Append
Scheduled backup Sunday for level 0 full, Wednesday for Level 2 backup, Monday, Tuesday, Thursday, Friday, Saturday 1 Incremental backup 11 o'clock start backup at night
[Email protected] script]$ crontab-l
* * * 0/home/oracle/rmanbak/script/exec_0_level.sh
* * * 1/home/oracle/rmanbak/script/exec_1_level.sh
* * * 2/home/oracle/rmanbak/script/exec_1_level.sh
* * * 3/home/oracle/rmanbak/script/exec_2_level.sh
* * * 4/home/oracle/rmanbak/script/exec_1_level.sh
* * * 5/home/oracle/rmanbak/script/exec_1_level.sh
* * * 6/home/oracle/rmanbak/script/exec_1_level.sh
This article from "Fly Hung 膤" blog, reproduced please contact the author!
Rman Backup scripts in Oracle database are very useful