12cR2中备份的一些测试总结

最新推荐文章于 2023-03-14 09:09:07 发布
最新推荐文章于 2023-03-14 09:09:07 发布
阅读量186 收藏
点赞数
分类专栏： 12C/18C/19C RMAN
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xxzhaobb/article/details/80159817
版权
1 RMAN中的参数设置，CDB中自动备份控制文件默认是开启的，PDB中是关闭的
2 连接到根容器数据库上备份数据库，会把根容器数据库，种子数据库，PDB数据库都备份了
3 连接到PDB数据库上备份数据库，只会备份该PDB数据库 
4 连接到CDB上，备份表空间，默认备份的是CDB上的表空间，除非指定了PDB。比如PDB1:USERS, USERS等 

5 备份根容器数据库，backup database root; 备份容器数据库backup database pdb1,或者backup pluggable database pdb1;

===============================================

1 

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TEST are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_test.f'; # default

RMAN> 
RMAN> show all;

db_unique_name 为 TEST 的数据库的 RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_test.f'; # default

RMAN>

2

RMAN> backup database;

Starting backup at 01-MAY-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=80 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=/u01/app/oracle/oradata/test/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/test/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/test/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/test/users01.dbf
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj6kb9r_.bkp tag=TAG20180501T154129 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/test/pdb1/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/test/pdb1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj6n9fx_.bkp tag=TAG20180501T154129 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00014 name=/u01/app/oracle/oradata/test/pdb2/sysaux01.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/test/pdb2/system01.dbf
input datafile file number=00015 name=/u01/app/oracle/oradata/test/pdb2/undotbs01.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/test/pdb2/users01.dbf
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/67FDD2C4A6EB05FFE0531202A8C0B969/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj6odqt_.bkp tag=TAG20180501T154129 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/test/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/test/pdbseed/system01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/test/pdbseed/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/67FDAB9DF94277BBE0531202A8C067A6/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj6pht6_.bkp tag=TAG20180501T154129 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 01-MAY-18

Starting Control File and SPFILE Autobackup at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_05_01/o1_mf_s_974994281_fgj6qc7g_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 01-MAY-18

RMAN> 

RMAN> report schema;

Report of database schema for database with db_unique_name TEST

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    820      SYSTEM               YES     /u01/app/oracle/oradata/test/system01.dbf
3    630      SYSAUX               NO      /u01/app/oracle/oradata/test/sysaux01.dbf
4    70       UNDOTBS1             YES     /u01/app/oracle/oradata/test/undotbs01.dbf
5    250      PDB$SEED:SYSTEM      NO      /u01/app/oracle/oradata/test/pdbseed/system01.dbf
6    330      PDB$SEED:SYSAUX      NO      /u01/app/oracle/oradata/test/pdbseed/sysaux01.dbf
7    5        USERS                NO      /u01/app/oracle/oradata/test/users01.dbf
8    100      PDB$SEED:UNDOTBS1    NO      /u01/app/oracle/oradata/test/pdbseed/undotbs01.dbf
9    260      PDB1:SYSTEM          YES     /u01/app/oracle/oradata/test/pdb1/system01.dbf
10   370      PDB1:SYSAUX          NO      /u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
11   100      PDB1:UNDOTBS1        YES     /u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
12   5        PDB1:USERS           NO      /u01/app/oracle/oradata/test/pdb1/users01.dbf
13   250      PDB2:SYSTEM          NO      /u01/app/oracle/oradata/test/pdb2/system01.dbf
14   330      PDB2:SYSAUX          NO      /u01/app/oracle/oradata/test/pdb2/sysaux01.dbf
15   100      PDB2:UNDOTBS1        NO      /u01/app/oracle/oradata/test/pdb2/undotbs01.dbf
16   5        PDB2:USERS           NO      /u01/app/oracle/oradata/test/pdb2/users01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    132      TEMP                 32767       /u01/app/oracle/oradata/test/temp01.dbf
2    64       PDB$SEED:TEMP        32767       /u01/app/oracle/oradata/test/pdbseed/temp012018-03-22_17-09-51-967-PM.dbf
3    130      PDB1:TEMP            32767       /u01/app/oracle/oradata/test/pdb1/temp01.dbf
4    64       PDB2:TEMP            32767       /u01/app/oracle/oradata/test/pdb2/temp01.dbf

RMAN> 
C:\Users\zhao-pc>rman target sys/oracle@pdb1

恢复管理器: Release 11.2.0.1.0 - Production on 星期二 5月 1 15:47:23 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

连接到目标数据库: TEST (DBID=2269603344)

RMAN> backup database;

启动 backup 于 01-5月 -18
使用目标数据库控制文件替代恢复目录
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=79 设备类型=DISK
通道 ORA_DISK_1: 正在启动全部数据文件备份集
通道 ORA_DISK_1: 正在指定备份集内的数据文件
输入数据文件: 文件号=00010 名称=/u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
输入数据文件: 文件号=00009 名称=/u01/app/oracle/oradata/test/pdb1/system01.dbf
输入数据文件: 文件号=00011 名称=/u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
输入数据文件: 文件号=00012 名称=/u01/app/oracle/oradata/test/pdb1/users01.dbf
通道 ORA_DISK_1: 正在启动段 1 于 01-5月 -18
通道 ORA_DISK_1: 已完成段 1 于 01-5月 -18
段句柄=/u01/app/oracle/fast_recovery_area/test/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154806_fgj6xq4j_.bkp 标记=TAG20180501T154806 注释=NONE
通道 ORA_DISK_1: 备份集已完成, 经过时间:00:00:35
完成 backup 于 01-5月 -18



RMAN> report schema;

db_unique_name 为 TEST 的数据库的数据库方案报表

永久数据文件列表
===========================
文件大小 (MB) 表空间           回退段数据文件名称
---- -------- -------------------- ------- ------------------------
9    260      SYSTEM               ***     /u01/app/oracle/oradata/test/pdb1/system01.dbf
10   370      SYSAUX               ***     /u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
11   100      UNDOTBS1             ***     /u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
12   5        USERS                ***     /u01/app/oracle/oradata/test/pdb1/users01.dbf

临时文件列表
=======================
文件大小 (MB) 表空间           最大大小 (MB) 临时文件名称
---- -------- -------------------- ----------- --------------------
3    130      TEMP                 32767       /u01/app/oracle/oradata/test/pdb1/temp01.dbf

RMAN>

3 

RMAN> backup tablespace PDB1:USERS;

Starting backup at 01-MAY-18
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=00012 name=/u01/app/oracle/oradata/test/pdb1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T161059_fgj88m7x_.bkp tag=TAG20180501T161059 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-MAY-18

Starting Control File and SPFILE Autobackup at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_05_01/o1_mf_s_974995860_fgj88nlf_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 01-MAY-18

备份FRA，备份的格式为db_unique_name/backupset/YYYY_MM_DD 

RMAN> backup recovery area to destination '/home/oracle';

Starting backup at 01-MAY-18
using channel ORA_DISK_1
specification does not match any datafile copy in the repository
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=2 RECID=1 STAMP=971461907
input archived log thread=1 sequence=3 RECID=2 STAMP=971465355
input archived log thread=1 sequence=4 RECID=3 STAMP=971465483
input archived log thread=1 sequence=5 RECID=4 STAMP=971465503
input archived log thread=1 sequence=6 RECID=5 STAMP=971465752
input archived log thread=1 sequence=7 RECID=6 STAMP=971465752
input archived log thread=1 sequence=8 RECID=7 STAMP=971465803
input archived log thread=1 sequence=9 RECID=9 STAMP=971470633
input archived log thread=1 sequence=10 RECID=10 STAMP=971470683
input archived log thread=1 sequence=11 RECID=13 STAMP=971470884
input archived log thread=1 sequence=12 RECID=15 STAMP=971472179
input archived log thread=1 sequence=13 RECID=18 STAMP=971472181
input archived log thread=1 sequence=14 RECID=20 STAMP=971472188
input archived log thread=1 sequence=15 RECID=21 STAMP=971472189
input archived log thread=1 sequence=16 RECID=23 STAMP=971472606
input archived log thread=1 sequence=17 RECID=24 STAMP=971472783
input archived log thread=1 sequence=18 RECID=28 STAMP=971474404
input archived log thread=1 sequence=19 RECID=29 STAMP=971474417
input archived log thread=1 sequence=20 RECID=30 STAMP=971474419
input archived log thread=1 sequence=21 RECID=32 STAMP=971685424
input archived log thread=1 sequence=22 RECID=31 STAMP=971685419
input archived log thread=1 sequence=23 RECID=33 STAMP=971688236
input archived log thread=1 sequence=24 RECID=34 STAMP=971688305
input archived log thread=1 sequence=25 RECID=36 STAMP=971688345
input archived log thread=1 sequence=26 RECID=39 STAMP=971688710
input archived log thread=1 sequence=27 RECID=40 STAMP=973865441
input archived log thread=1 sequence=28 RECID=41 STAMP=974215577
input archived log thread=1 sequence=29 RECID=42 STAMP=974450485
input archived log thread=1 sequence=30 RECID=43 STAMP=974489098
input archived log thread=1 sequence=31 RECID=44 STAMP=974622335
input archived log thread=1 sequence=32 RECID=45 STAMP=974638057
input archived log thread=1 sequence=33 RECID=46 STAMP=974656832
input archived log thread=1 sequence=34 RECID=47 STAMP=974735124
input archived log thread=1 sequence=35 RECID=48 STAMP=974973919
input archived log thread=1 sequence=36 RECID=49 STAMP=974993875
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_annnn_TAG20180501T163436_fgj9nwkc_.bkp tag=TAG20180501T163436 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
channel ORA_DISK_1: input backup set: count=1, stamp=971462496, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_03_22/o1_mf_n_971462497_fc7232tf_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncnnf_TAG20180322T184136_fgj9ql02_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=21, stamp=971471283, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_03_22/o1_mf_s_971471283_fc7booh2_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncsnf_TAG20180322T210803_fgj9qlr4_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=22, stamp=971472189, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_03_22/o1_mf_s_971472190_fc7cl465_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncsnf_TAG20180322T212309_fgj9qmz3_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=23, stamp=971475003, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_03_22/o1_mf_s_971474341_fc7g9z5o_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncsnf_TAG20180322T221003_fgj9qnwm_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=24, stamp=971688708, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_03_25/o1_mf_s_971688707_fcfz071j_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncsnf_TAG20180325T093148_fgj9qoy2_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=25, stamp=973875678, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_04_19/o1_mf_s_973875678_ffjppzgp_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncsnf_TAG20180419T170118_fgj9qq68_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:03
channel ORA_DISK_1: input backup set: count=26, stamp=974992175, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_ncnnf_TAG20180501T150934_fgj4ol9y_.bkp
piece handle=/home/oracle/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_ncnnf_TAG20180501T150934_fgj9qtdb_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:03
channel ORA_DISK_1: input backup set: count=27, stamp=974992353, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/backupset/2018_05_01/o1_mf_ncnnf_TAG20180501T151233_fgj4v2bm_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncnnf_TAG20180501T151233_fgj9qx84_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:03
channel ORA_DISK_1: input backup set: count=28, stamp=974992355, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_05_01/o1_mf_s_974992355_fgj4v3wc_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncsnf_TAG20180501T151235_fgj9r0go_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:03
channel ORA_DISK_1: input backup set: count=29, stamp=974994090, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj6kb9r_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj9r3wc_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:01:25
channel ORA_DISK_1: input backup set: count=30, stamp=974994185, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj6n9fx_.bkp
piece handle=/home/oracle/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj9tsf7_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:45
channel ORA_DISK_1: input backup set: count=31, stamp=974994220, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/67FDD2C4A6EB05FFE0531202A8C0B969/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj6odqt_.bkp
piece handle=/home/oracle/TEST/67FDD2C4A6EB05FFE0531202A8C0B969/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj9w5x9_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:45
channel ORA_DISK_1: input backup set: count=32, stamp=974994255, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/67FDAB9DF94277BBE0531202A8C067A6/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj6pht6_.bkp
piece handle=/home/oracle/TEST/67FDAB9DF94277BBE0531202A8C067A6/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154129_fgj9xmgz_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:45
channel ORA_DISK_1: input backup set: count=33, stamp=974994281, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_05_01/o1_mf_s_974994281_fgj6qc7g_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncsnf_TAG20180501T154441_fgj9yzy4_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:03
channel ORA_DISK_1: input backup set: count=34, stamp=974994487, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154806_fgj6xq4j_.bkp
piece handle=/home/oracle/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T154806_fgj9z2yg_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:35
channel ORA_DISK_1: input backup set: count=35, stamp=974995859, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T161059_fgj88m7x_.bkp
piece handle=/home/oracle/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T161059_fgjb0610_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=36, stamp=974995860, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_05_01/o1_mf_s_974995860_fgj88nlf_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncsnf_TAG20180501T161100_fgjb073r_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:03
channel ORA_DISK_1: input backup set: count=37, stamp=974995871, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T161110_fgj88z1j_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T161110_fgjb0b55_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=38, stamp=974995872, piece=1
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece /u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_05_01/o1_mf_s_974995872_fgj890m1_.bkp
piece handle=/home/oracle/TEST/backupset/2018_05_01/o1_mf_ncsnf_TAG20180501T161112_fgjb0c68_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:03
Finished backup at 01-MAY-18

Starting Control File and SPFILE Autobackup at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_05_01/o1_mf_s_974997646_fgjb0gl5_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 01-MAY-18

RMAN> 
[oracle@orcl12c 2018_05_01]$ ll
total 2754496
-rw-r-----. 1 oracle oinstall 1364729856 May  1 16:35 o1_mf_annnn_TAG20180501T163436_fgj9nwkc_.bkp
-rw-r-----. 1 oracle oinstall   18792448 May  1 16:36 o1_mf_ncnnf_TAG20180322T184136_fgj9ql02_.bkp
-rw-r-----. 1 oracle oinstall   19087360 May  1 16:36 o1_mf_ncnnf_TAG20180501T151233_fgj9qx84_.bkp
-rw-r-----. 1 oracle oinstall   18825216 May  1 16:36 o1_mf_ncsnf_TAG20180322T210803_fgj9qlr4_.bkp
-rw-r-----. 1 oracle oinstall   18825216 May  1 16:36 o1_mf_ncsnf_TAG20180322T212309_fgj9qmz3_.bkp
-rw-r-----. 1 oracle oinstall   19120128 May  1 16:36 o1_mf_ncsnf_TAG20180322T221003_fgj9qnwm_.bkp
-rw-r-----. 1 oracle oinstall   19120128 May  1 16:36 o1_mf_ncsnf_TAG20180325T093148_fgj9qoy2_.bkp
-rw-r-----. 1 oracle oinstall   19120128 May  1 16:36 o1_mf_ncsnf_TAG20180419T170118_fgj9qq68_.bkp
-rw-r-----. 1 oracle oinstall   19120128 May  1 16:36 o1_mf_ncsnf_TAG20180501T151235_fgj9r0go_.bkp
-rw-r-----. 1 oracle oinstall   19120128 May  1 16:40 o1_mf_ncsnf_TAG20180501T154441_fgj9yzy4_.bkp
-rw-r-----. 1 oracle oinstall   19120128 May  1 16:40 o1_mf_ncsnf_TAG20180501T161100_fgjb073r_.bkp
-rw-r-----. 1 oracle oinstall   19120128 May  1 16:40 o1_mf_ncsnf_TAG20180501T161112_fgjb0c68_.bkp
-rw-r-----. 1 oracle oinstall 1245323264 May  1 16:37 o1_mf_nnndf_TAG20180501T154129_fgj9r3wc_.bkp
-rw-r-----. 1 oracle oinstall    1171456 May  1 16:40 o1_mf_nnndf_TAG20180501T161110_fgjb0b55_.bkp
[oracle@orcl12c 2018_05_01]$ pwd
/home/oracle/TEST/backupset/2018_05_01
[oracle@orcl12c 2018_05_01]$
仅仅备份某一个可插拔数据库，比如pdb1
backup database pdb1;  
RMAN> backup database pdb1;

Starting backup at 01-MAY-18
using channel ORA_DISK_1
file 12 is excluded from whole database backup
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/test/pdb1/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T170940_fgjcpn8o_.bkp tag=TAG20180501T170940 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
Finished backup at 01-MAY-18

Starting Control File and SPFILE Autobackup at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_05_01/o1_mf_s_974999406_fgjcqggj_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 01-MAY-18

RMAN> 
RMAN> backup pluggable database pdb1;

Starting backup at 01-MAY-18
using channel ORA_DISK_1
file 12 is excluded from whole database backup
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/test/pdb1/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/67FDCE20C52E0518E0531202A8C0E70F/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T171118_fgjcspdm_.bkp tag=TAG20180501T171118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16
Finished backup at 01-MAY-18

Starting Control File and SPFILE Autobackup at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_05_01/o1_mf_s_974999494_fgjct804_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 01-MAY-18

RMAN>

仅仅备份根容器数据库

RMAN> backup database root;

Starting backup at 01-MAY-18
using channel ORA_DISK_1
file 7 is excluded from whole database backup
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=/u01/app/oracle/oradata/test/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/test/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/test/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 01-MAY-18
channel ORA_DISK_1: finished piece 1 at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/backupset/2018_05_01/o1_mf_nnndf_TAG20180501T171222_fgjcvq2c_.bkp tag=TAG20180501T171222 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 01-MAY-18

Starting Control File and SPFILE Autobackup at 01-MAY-18
piece handle=/u01/app/oracle/fast_recovery_area/test/TEST/autobackup/2018_05_01/o1_mf_s_974999608_fgjcxsmf_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 01-MAY-18

RMAN>








文档搬运工
关注
专栏目录
Oracle Database 12cR2 Architecture体系结构图 高清版
08-29
在12cR2的体系结构中，我们关注以下几个关键组件和概念： 1. **多租户架构**：Oracle 12c 引入了多租户容器数据库（CDB），允许在一个物理数据库中容纳多个独立的数据库，称为可插拔数据库（PDB）。PDB 可以像传统...
oracle-database-server-12cR2-preinstall
11-14
Oracle Database Server...总结一下，Oracle Database Server 12cR2 Preinstall是Oracle数据库在Linux环境中快速、高效部署的重要工具，它简化了系统准备阶段，确保了安装的顺利进行，是企业级数据库管理者的得力助手。
Oracle 12c 多租户 CDB 与 PDB 备份
张冲andy的博客
05-10 3396
一、  CDB 备份 1.1  只备份CDB 只备份CDB数据库需要具有SYSDBA或SYSBACKUP权限用户连接到CDB的root环境下，执行backupdatabase root命令即可完成对CDB的备份，方法如下： [oracle@12c01 ~]$ rman target /  [oracle@12c01 ~]$ mkdir /home/oracle/rmanback/ RMA
ORACLE——RMAN 参数解读
weixin_34192816的博客
07-04 337
查看默认rman配置参数 oracle用户下登录rman：rman target / 查看所有配置参数详情：show all show all的第一行：using target database control file instead of recovery catalog，指的是使用目标数据库控制文件代替恢复目录 备份记录的两种模式catalog和nocatlog，参考...
oracle 12c+备份和恢复
Brent的专栏
09-29 2042
1.在12c多租户环境中,备份有两个关键方面:CDB级别的备份和PDB级别的备份 一.CDB全备份 在大部分情况下,备份往往是CDB级别的.这就意味着CDB$ROOT,PDB$SEED,PDBS都会被备份. CDB的备份包括的:控制文件,所有数据文件(包含CDB和PDB的),所有归档日志的备份,建议对spfile也进行备份. CDB的备份和12c以前的备份没有什么不同呢. 下面的所有的...
Oracle 12C新特性总结
热门推荐
Kay的博客
02-10 1万+
Oracle 12C新特性总结1.1 不可见字段1.2 相同字段上的多重索引1.3 DDL日志1.4 新的备份用户特权1.5 数据泵的增强1.6 完整可传输导出/导入 迁移数据库1.7 扩展数据类型长度32k Strings1.8 在SQL语句中通过with语句定义函数(12.1.0.2）1.9 在线移动并重命名数据文件1.10 高级索引压缩1.11 PGA大小限制1.12 RMAN 表级恢复1...
Oracle 12C R1升级到12C R2
Expec-乐的博客
06-21 1668
1环境说明 源库：12.1.0.2 SQL> select * from v$version rownum =1; BANNER CON_ID ---------------------------------------------------------------- ---------------- Oracle Database 12c Enterprise E...
Oracle 10G R2升级到12cR1
Expec-乐的博客
06-21 1231
1升级说明 12cR2也是今年官方正式放出来，由于众多非常好的新特性，所以很多用户也想将自己的数据库升级/迁移到12CR2中。但是无法从10G直接升级到12cR2,必须通过多次升级才行。升级具体步骤和之前升级数据库没有什么区别，只要做好前提检查就行。 大概方法： 数据库升级助手（DBUA）--最简单 手动升级（基于脚本）--最容易出错 2直接升级到12c的路线 只支持...
Oracle 12c RAC 安装文档
NateIT的博客
08-24 1087
首先，谢谢原作者：此文为转载的文章，现将原地址贴出如下： Oracle 12c RAC 安装文档​www.cnblogs.com/leohahah/p/9488963.html 更多精彩Zabbix文章、技术交流、免费技术培训加微号NateIT，免费获取zabbix安装、配置、优化技术培训视频 官网：http://ywzs.hanyunintel.com 参考文档： https://docs.oracle.com/en/database/oracle/oracle-database/12.
代码测试,调试与优化小结
廖新元的linux 学习历程
10-14 5072
http://www.cppblog.com/cuijixin/default.html?page=8 代码测试、调试与优化的小结 by falcon<zhangjinw@gmail.com> 2008-02-29     代码写完以后往往要做测试（或验证）、调试，可能还要优化。     关于测试（或验证），通常对应着两个英文单词verification和validation，在资料...
一些可以参考的文档集合11
最新发布
xuejianxinokok的专栏
03-14 392
之前的文章集合:
课程环境搭建文档 Oracle 12cR2环境搭建（Linux平台）.pdf
07-30
Oracle 12cR2环境搭建（Linux平台） 本文档旨在指导读者搭建 Oracle 12cR2 环境在 Linux 平台上，包括配置 VMWare WorkStation、虚拟机磁盘规划、Linux 系统环境搭建等内容。 课程环境搭建概述 Oracle 12cR2 ...
Oracle 11gR2迁移升级至12cR2 RAC
03-26
### Oracle 11gR2迁移升级至12cR2 RAC #### 概述 本文档旨在详细介绍如何从Oracle 11.2.0.4单机环境迁移到Oracle 12cR2 RAC环境的过程。该迁移不仅涉及物理硬件的变化，还包含了数据库版本的升级。通过这种方式，...
Oracle 12CR2 RAC 升级
04-11
### Oracle 12CR2 RAC 升级详解 #### 一、概述 Oracle 12CR2 RAC（Real Application Clusters）升级涉及到多个组件的更新，包括Grid Infrastructure (GI)、RDBMS（Relational Database Management System）以及...
19c的EM Express
文档搬运工
10-11 6223
参考文档： https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/getting-started-with-database-administration.html#GUID-BA75AD46-D22E-4914-A31E-C395CD6A2BBA EM Express is available only whe...
Oracle 19c RAC的安装
文档搬运工
10-10 6221
RDBMS 19.0.0.0 OS redhat7.4 SWAP配置，官方的建议：（单独安装Oracle） https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/server-configuration-checklist-for-oracle-database-installation.html#GUID-C...
安装19c rac 碰到的问题 - "INS-06006" 及RPM包问题
文档搬运工
04-29 5895
OS：redhat 7.4 RDBMS： 19.3.0.0 问题 在安装rac的时候，提示出现ins-06006错误，两个节点相互ssh，发现是通的。但是图形界面上的test就是不能通过。图形界面上的setup再次设置后，还是不可以。 运行runcluvfy.sh脚本来检查。发现一些问题 [grid@node19c01 grid]$ ./runcluvfy.sh stage -pre ...
12c的备库alertlog中出现 “Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE h”
文档搬运工
09-08 5798
RDBMS 12.2.0.1 的data guard 。 最近在备库的alert.log上看到一些警告 2018-09-08T08:24:31.886590+08:00 Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE has been deprecated. Warning: ALT...
CentOS7安装Oracle12cR2详细教程
确保你的硬件环境满足最低需求，例如在本案例中使用的是一台运行Windows Server 2008 R2的主机，通过VMware 12.5.4虚拟化软件运行CentOS-7-x64操作系统，并计划安装Oracle 12CR2。至少需要2GB内存，但推荐分配16GB或...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值