The rman backup script in the Oracle database is very practical.

The rman backup script in the Oracle database is very practical.

The rman backup script in the Oracle database is very practical.

Query character sets

SQL> select * from nls_database_parameters;

NLS_CHARACTERSET
AL32UTF8

Character Set is very important during backup, otherwise garbled characters will appear

1. Level 0 backup (full backup) Red is to be modified, based on the personal storage location.

[Oracle @ oracle122 script] $ cat db_bak0.rman
Run
{
Configure retention policy to recovery window of 8 days;
Configure controlfile autobackup on;
Configure controlfile autobackup format for device type disk to '/home/oracle/rmanbak/% F ';
Allocate channel specified device type disk format'/home/oracle/rmanbak/inc0 _ % d _ % s _ % p _ % u _ % T ';
Backup incremental level 0 tag = 'level 0' database skip inaccessible filesperset 10 plus archivelog filesperset 20;
Release channel identifier;
}
Allocate channel for maintenance device type disk;
Crosscheck backup;
Delete noprompt expired backup;
Delete noprompt obsolete;
Delete noprompt archivelog until time 'sysdate-30 ';

Level 0 running scripts

[Oracle @ oracle122 script] $ cat exec_0_level.sh
ORACLE_HOSTNAME = oracle122; export ORACLE_HOSTNAME
ORACLE_BASE =/u01/app; export ORACLE_BASE
ORACLE_HOME =/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 folder file/home/oracle/rmanbak/script/db_bak0.rman log/home/oracle/rmanbak/script /log/rman _ $ DATE. log append

Ii. Level 1 backup (incremental)

[Oracle @ oracle122 script] $ cat db_bak1.rman
Run
{
Configure retention policy to recovery window of 8 days;
Configure controlfile autobackup on;
Configure controlfile autobackup format for device type disk to '/home/oracle/rmanbak/% F ';
Allocate channel specified device type disk format'/home/oracle/rmanbak/inc1 _ % d _ % s _ % p _ % u _ % T ';
Backup incremental level 1 tag = 'Level 1' database skip inaccessible filesperset 10 plus archivelog filesperset 20;
Release channel identifier;
}
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 running script

[Oracle @ oracle122 script] $ cat exec_1_level.sh
ORACLE_HOSTNAME = oracle122; export ORACLE_HOSTNAME
ORACLE_BASE =/u01/app; export ORACLE_BASE
ORACLE_HOME =/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 folder file/home/oracle/rmanbak/script/db_bak1.rman log/home/oracle/rmanbak/script /log/rman _ $ DATE. log append

 

Level 3 and level 2 backup (from level 0 to backup now)

[Oracle @ oracle122 script] $ cat db_bak2.rman
Run
{
Configure retention policy to recovery window of 8 days;
Configure controlfile autobackup on;
Configure controlfile autobackup format for device type disk to '/home/oracle/rmanbak/% F ';
Allocate channel specified device type disk format'/home/oracle/rmanbak/inc2 _ % d _ % s _ % p _ % u _ % T ';
Backup incremental level 2 tag = 'Level 2' database skip inaccessible filesperset 10 plus archivelog filesperset 20 delete all input;
Release channel identifier;
}
Allocate channel for maintenance device type disk;
Crosscheck backup;
Delete noprompt expired backup;
Delete noprompt obsolete;

2-level running script

[Oracle @ oracle122 script] $ cat exec_2_level.sh
ORACLE_HOSTNAME = oracle122; export ORACLE_HOSTNAME
ORACLE_BASE =/u01/app; export ORACLE_BASE
ORACLE_HOME =/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 folder file/home/oracle/rmanbak/script/db_bak2.rman log/home/oracle/rmanbak/script /log/rman _ $ DATE. log append

Scheduled Backup: Zero-level backup on Sunday, two-level backup on Wednesday, and one-level Incremental backup at on Monday, Tuesday, Thursday, and Saturday

[Oracle @ oracle122 script] $ crontab-l
* 23 ** 0/home/oracle/rmanbak/script/exec_0_level.sh
* 23 ** 1/home/oracle/rmanbak/script/exec_1_level.sh
* 23 ** 2/home/oracle/rmanbak/script/exec_1_level.sh
* 23 ** 3/home/oracle/rmanbak/script/exec_2_level.sh
* 23 ** 4/home/oracle/rmanbak/script/exec_1_level.sh
* 23 ** 5/home/oracle/rmanbak/script/exec_1_level.sh
* 23 ** 6/home/oracle/rmanbak/script/exec_1_level.sh

-------------------------------------- Recommended reading --------------------------------------

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

-------------------------------------- Split line --------------------------------------