### 本次我们主要一起学习rman相关使用,包含复制,迁移
---
##### 19c新特性
- PDB 支持 资料库
```
--连接示例
connect target "sbu@prod AS SYSBACKUP"
```
- 自动删除闪回日志
```
--默认1440分钟/一天,19c开始超过自动清理
db_flashback_retention_target
```
##### 18C新特性
- 复制一个pdb到另一个存在的cdb中
- 复制数据库到Oracle云
- 前滚物理备库,简化使用
- RMAN备份可以用迁移,pdb、cdb切换
- 块丢失写保护增强
##### 部分功能测试
###### 全备
```
connect target /
run {
allocate channel ch1 type disk;
allocate channel ch2 type disk;
alter system archive log current;
alter system archive log current;
backup format '/backup/mypdb_full_%T_%s_%p' database plus archivelog delete all input;
backup format '/backup/mypdb_controlfile_%T_%s_%p' current controlfile;
alter system archive log current;
backup format '/backup/mypdb_arch_%Y%M%D_%s_%p' archivelog all;
release channel ch1;
release channel ch2;
}
```
> 全备备份的数据文件参考
```
--其中数据文件2,5,6是pdb模板
col file_name for a50
select file_id,file_name,tablespace_name from cdb_data_files order by file_id;
```
###### 备份pdb数据库
```
--更相信命令,参考全备
BACKUP PLUGGABLE DATABASE mypdb;
--or
[oracle@node216 ~]$ rman target sys/oracle@mypdb
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Feb 14 21:57:32 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to ta