RMAN做全备
<h2>备份全库</h2>
<pre><code>-- 备份所有数据文件、控制文件、spfile文件以及所有归档日志。
-- filesperset 是每个备份集中包含的最大文件个数
RMAN> backup database format='/backup/rman/prod_%s.bak' filesperset 10;
--ASM
RMAN> backup database format='+arch' filesperset 10;
-- 当 delete input 后，控制文件相关信息（ v$archived_log ）也会被更新 archivelog 物理日志也被删除。
-- 并删除旧的归档日志，
RMAN> backup database plus archivelog delete input;
-- archivelog 的备份是根据控制文件中（ v$archived_log ）中的内容导航的
-- 如果控制文件中记录了而实际归档中又不存在，则会报错，skip inaccessible 的含义是跳过物理上缺失的日志文件。
RMAN> backup database format '/backup/rman/%U.bak' plus archivelog delete input skip inaccessible;</code></pre>
<pre><code>-- 备份所有数据文件、控制文件、spfile文件以及所有归档日志。
-- filesperset 是每个备份集中包含的最大文件个数
RMAN> backup database format='/backup/rman/prod_%s.bak' filesperset 10;
Starting backup at 25-NOV-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=77 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/RACDB/DATAFILE/system.256.1089477103
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=00002 name=+DATA/RACDB/DATAFILE/tjdata.261.1089483283
input datafile file number=00005 name=+DATA/RACDB/DATAFILE/tjdata.262.1089483247
input datafile file number=00007 name=+DATA/RACDB/DATAFILE/users.259.1089477153
channel ORA_DISK_1: starting piece 1 at 25-NOV-21
channel ORA_DISK_1: finished piece 1 at 25-NOV-21
piece handle=/backup/rman/prod_2.bak tag=TAG20211125T141327 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
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_1089555214.256.1089555215 comment=NONE
Finished Control File and SPFILE Autobackup at 25-NOV-21</code></pre>
<pre><code>-- 当 delete input 后，控制文件相关信息（ v$archived_log ）也会被更新 archivelog 物理日志也被删除。
-- 并删除旧的归档日志，
RMAN> backup database plus archivelog delete input;
Starting backup at 25-NOV-21
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=19 RECID=4 STAMP=1089554348
input archived log thread=1 sequence=20 RECID=5 STAMP=1089555632
channel ORA_DISK_1: starting piece 1 at 25-NOV-21
channel ORA_DISK_1: finished piece 1 at 25-NOV-21
piece handle=+ARCH/RACDB/BACKUPSET/2021_11_25/annnf0_tag20211125t142032_0.259.1089555633 tag=TAG20211125T142032 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+ARCH/RACDB/ARCHIVELOG/2021_11_25/thread_1_seq_19.257.1089554349 RECID=4 STAMP=1089554348
archived log file name=+ARCH/RACDB/ARCHIVELOG/2021_11_25/thread_1_seq_20.258.1089555631 RECID=5 STAMP=1089555632
Finished backup at 25-NOV-21
Starting backup at 25-NOV-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/RACDB/DATAFILE/system.256.1089477103
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=00002 name=+DATA/RACDB/DATAFILE/tjdata.261.1089483283
input datafile file number=00005 name=+DATA/RACDB/DATAFILE/tjdata.262.1089483247
input datafile file number=00007 name=+DATA/RACDB/DATAFILE/users.259.1089477153
channel ORA_DISK_1: starting piece 1 at 25-NOV-21
channel ORA_DISK_1: finished piece 1 at 25-NOV-21
piece handle=+ARCH/RACDB/BACKUPSET/2021_11_25/nnndf0_tag20211125t142033_0.258.1089555633 tag=TAG20211125T142033 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 25-NOV-21
Starting backup at 25-NOV-21
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=21 RECID=6 STAMP=1089555636
channel ORA_DISK_1: starting piece 1 at 25-NOV-21
channel ORA_DISK_1: finished piece 1 at 25-NOV-21
piece handle=+ARCH/RACDB/BACKUPSET/2021_11_25/annnf0_tag20211125t142036_0.260.1089555637 tag=TAG20211125T142036 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+ARCH/RACDB/ARCHIVELOG/2021_11_25/thread_1_seq_21.257.1089555637 RECID=6 STAMP=1089555636
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_1089555637.257.1089555639 comment=NONE
Finished Control File and SPFILE Autobackup at 25-NOV-21</code></pre>
<pre><code>-- archivelog 的备份是根据控制文件中（ v$archived_log ）中的内容导航的
-- 如果控制文件中记录了而实际归档中又不存在，则会报错，skip inaccessible 的含义是跳过物理上缺失的日志文件。
RMAN> backup database format '/backup/rman/%U.bak' plus archivelog delete input skip inaccessible;
Starting backup at 25-NOV-21
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=22 RECID=7 STAMP=1089555885
channel ORA_DISK_1: starting piece 1 at 25-NOV-21
channel ORA_DISK_1: finished piece 1 at 25-NOV-21
piece handle=+ARCH/RACDB/BACKUPSET/2021_11_25/annnf0_tag20211125t142445_0.262.1089555885 tag=TAG20211125T142445 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+ARCH/RACDB/ARCHIVELOG/2021_11_25/thread_1_seq_22.261.1089555885 RECID=7 STAMP=1089555885
Finished backup at 25-NOV-21
Starting backup at 25-NOV-21
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/RACDB/DATAFILE/system.256.1089477103
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=00002 name=+DATA/RACDB/DATAFILE/tjdata.261.1089483283
input datafile file number=00005 name=+DATA/RACDB/DATAFILE/tjdata.262.1089483247
input datafile file number=00007 name=+DATA/RACDB/DATAFILE/users.259.1089477153
channel ORA_DISK_1: starting piece 1 at 25-NOV-21
channel ORA_DISK_1: finished piece 1 at 25-NOV-21
piece handle=/backup/rman/090f2jde_1_1.bak tag=TAG20211125T142446 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 25-NOV-21
Starting backup at 25-NOV-21
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=23 RECID=8 STAMP=1089555894
channel ORA_DISK_1: starting piece 1 at 25-NOV-21
channel ORA_DISK_1: finished piece 1 at 25-NOV-21
piece handle=+ARCH/RACDB/BACKUPSET/2021_11_25/annnf0_tag20211125t142454_0.263.1089555895 tag=TAG20211125T142454 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+ARCH/RACDB/ARCHIVELOG/2021_11_25/thread_1_seq_23.261.1089555895 RECID=8 STAMP=1089555894
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_1089555895.261.1089555897 comment=NONE
Finished Control File and SPFILE Autobackup at 25-NOV-21</code></pre>