RMAN备份脚本
<p>[TOC]</p>
<h2>冷备份</h2>
<pre><code>## 冷备份脚本
[oracle@MES ~]$ vi /backup/script/cold.sql
run{
shutdown immediate;
startup mount;
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup database format '/backup/rman/colddb_%d_%T_%U.bak';
backup current controlfile format '/backup/rman/coldctl_%d_%T_%U.bak';
alter database open;
release channel c1;
release channel c2;
}
## 执行脚本
RMAN> @/backup/script/cold.sql
RMAN> run{
2> shutdown immediate;
3> startup mount;
4> allocate channel c1 device type disk;
5> allocate channel c2 device type disk;
6> backup database format '/backup/rman/colddb_%d_%T_%U.bak';
7> backup current controlfile format '/backup/rman/coldctl_%d_%T_%U.bak';
8> alter database open;
9> release channel c1;
10> release channel c2;
11> }
database closed
database dismounted
Oracle instance shut down
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 5251267320 bytes
Fixed Size 8907512 bytes
Variable Size 939524096 bytes
Database Buffers 4294967296 bytes
Redo Buffers 7868416 bytes
allocated channel: c1
channel c1: SID=42 device type=DISK
allocated channel: c2
channel c2: SID=50 device type=DISK
Starting backup at 25-NOV-21
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/RACDB/DATAFILE/system.256.1089477103
input datafile file number=00002 name=+DATA/RACDB/DATAFILE/tjdata.261.1089483283
input datafile file number=00005 name=+DATA/RACDB/DATAFILE/tjdata.262.1089483247
channel c1: starting piece 1 at 25-NOV-21
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/RACDB/DATAFILE/sysaux.257.1089477137
input datafile file number=00004 name=+DATA/RACDB/DATAFILE/undotbs1.258.1089477153
input datafile file number=00007 name=+DATA/RACDB/DATAFILE/users.259.1089477153
channel c2: starting piece 1 at 25-NOV-21
channel c2: finished piece 1 at 25-NOV-21
piece handle=/backup/rman/colddb_RACDB_20211125_0v0f34qq_1_1.bak tag=TAG20211125T192202 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:03
channel c1: finished piece 1 at 25-NOV-21
piece handle=/backup/rman/colddb_RACDB_20211125_0u0f34qq_1_1.bak tag=TAG20211125T192202 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:07
Finished backup at 25-NOV-21
Starting backup at 25-NOV-21
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 25-NOV-21
channel c1: finished piece 1 at 25-NOV-21
piece handle=/backup/rman/coldctl_RACDB_20211125_100f34r1_1_1.bak tag=TAG20211125T192209 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-NOV-21
Starting Control File and SPFILE Autobackup at 25-NOV-21
piece handle=+ARCH/RACDB/AUTOBACKUP/2021_11_25/s_1089573681.276.1089573731 comment=NONE
Finished Control File and SPFILE Autobackup at 25-NOV-21
Statement processed
released channel: c1
released channel: c2
RMAN> **end-of-file**</code></pre>
<h2>热备份</h2>
<pre><code>##热备份脚本
[oracle@MES ~]$ vi /backup/script/hot.sql
run{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup database format '/backup/rman/hotdb_%d_%T_%U.bak'
plus archivelog format '/backup/rman/hotar_%d_%T_%U.bak';
backup current controlfile format '/backup/rman/hotctl_%d_%T_%U.bak';
release channel c1;
release channel c2;
}
## 执行脚本
RMAN> @/backup/script/hot.sql
RMAN> run{
2> allocate channel c1 device type disk;
3> allocate channel c2 device type disk;
4> backup database format '/backup/rman/hotdb_%d_%T_%U.bak'
5> plus archivelog format '/backup/rman/hotar_%d_%T_%U.bak';
6> backup current controlfile format '/backup/rman/hotctl_%d_%T_%U.bak';
7> release channel c1;
8> release channel c2;
9> }
allocated channel: c1
channel c1: SID=42 device type=DISK
allocated channel: c2
channel c2: SID=50 device type=DISK
Starting backup at 25-NOV-21
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=28 RECID=13 STAMP=1089574138
channel c1: starting piece 1 at 25-NOV-21
channel c1: finished piece 1 at 25-NOV-21
piece handle=/backup/rman/hotar_RACDB_20211125_120f357q_1_1.bak tag=TAG20211125T192858 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-NOV-21
Starting backup at 25-NOV-21
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/RACDB/DATAFILE/system.256.1089477103
input datafile file number=00002 name=+DATA/RACDB/DATAFILE/tjdata.261.1089483283
input datafile file number=00005 name=+DATA/RACDB/DATAFILE/tjdata.262.1089483247
channel c1: starting piece 1 at 25-NOV-21
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/RACDB/DATAFILE/sysaux.257.1089477137
input datafile file number=00004 name=+DATA/RACDB/DATAFILE/undotbs1.258.1089477153
input datafile file number=00007 name=+DATA/RACDB/DATAFILE/users.259.1089477153
channel c2: starting piece 1 at 25-NOV-21
channel c2: finished piece 1 at 25-NOV-21
piece handle=/backup/rman/hotdb_RACDB_20211125_140f357s_1_1.bak tag=TAG20211125T192859 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:03
channel c1: finished piece 1 at 25-NOV-21
piece handle=/backup/rman/hotdb_RACDB_20211125_130f357s_1_1.bak tag=TAG20211125T192859 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:07
Finished backup at 25-NOV-21
Starting backup at 25-NOV-21
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=29 RECID=14 STAMP=1089574147
channel c1: starting piece 1 at 25-NOV-21
channel c1: finished piece 1 at 25-NOV-21
piece handle=/backup/rman/hotar_RACDB_20211125_150f3583_1_1.bak tag=TAG20211125T192907 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-NOV-21
Starting backup at 25-NOV-21
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 25-NOV-21
channel c1: finished piece 1 at 25-NOV-21
piece handle=/backup/rman/hotctl_RACDB_20211125_160f3584_1_1.bak tag=TAG20211125T192908 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-NOV-21
Starting Control File and SPFILE Autobackup at 25-NOV-21
piece handle=+ARCH/RACDB/AUTOBACKUP/2021_11_25/s_1089574150.279.1089574151 comment=NONE
Finished Control File and SPFILE Autobackup at 25-NOV-21
released channel: c1
released channel: c2
RMAN> **end-of-file**</code></pre>