本篇内容主要讲解“Oracle19c rman使用简单测试分析”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“Oracle19c rman使用简单测试分析”吧!

PDB 支持 资料库

--连接示例connecttarget"sbu@prodASSYSBACKUP"

自动删除闪回日志

--默认1440分钟/一天，19c开始超过自动清理db_flashback_retention_target18C新特性

复制一个pdb到另一个存在的cdb中

复制数据库到Oracle云

前滚物理备库，简化使用

RMAN备份可以用迁移，pdb、cdb切换

块丢失写保护增强

全备

connecttarget/run{allocatechannelch2typedisk;allocatechannelch3typedisk;altersystemarchivelogcurrent;altersystemarchivelogcurrent;backupformat'/backup/mypdb_full_%T_%s_%p'databaseplusarchivelogdeleteallinput;backupformat'/backup/mypdb_controlfile_%T_%s_%p'currentcontrolfile;altersystemarchivelogcurrent;backupformat'/backup/mypdb_arch_%Y%M%D_%s_%p'archivelogall;releasechannelch2;releasechannelch3;}

全备备份的数据文件参考

--其中数据文件2,5,6是pdb模板colfile_namefora50selectfile_id,file_name,tablespace_namefromcdb_data_filesorderbyfile_id;

备份pdb数据库

--更相信命令，参考全备BACKUPPLUGGABLEDATABASEmypdb;--or[oracle@node216~]$rmantargetsys/oracle@mypdbRecoveryManager:Release19.0.0.0.0-ProductiononFriFeb1421:57:322020Version19.3.0.0.0Copyright(c)1982,2019,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:MYDB19C:MYPDB(DBID=2219134196)RMAN>backupdatabase;

备份cdb,pdbseed

--备份root+pdbseed建议一起备份run{allocatechannelch2typedisk;allocatechannelch3typedisk;altersystemarchivelogcurrent;altersystemarchivelogcurrent;backupformat'/backup/root_full_%T_%s_%p'databaserootplusarchivelogdeleteallinput;backupformat'/backup/pdbseed_full_%T_%s_%p'database'PDB$SEED';backupformat'/backup/root_controlfile_%T_%s_%p'currentcontrolfile;altersystemarchivelogcurrent;backupformat'/backup/root_arch_%Y%M%D_%s_%p'archivelogall;releasechannelch2;releasechannelch3;}恢复测试

--恢复root+pdbseed,也可单独恢复restorecontrolfilefrom'/backup/root_controlfile_20200215_62_1';alterdatabasemount;run{restoredatabaseroot;restoredatabase'pdb$seed';recoverdatabaseroot;recoverdatabase'pdb$seed';}--跳过pdb数据库，openaltersessionsetcontainer=mypdb;colnamefora50selectfile#,name,statusfromv$datafile;alterdatabasedatafile9,10,11,12,13offline;alterdatabaseopenresetlogs;--恢复pdbcolpdb_namefora20selectpdb_name,statusfromdba_pdbs;restorepluggabledatabasemypdb;recoverpluggabledatabasemypdb;altersessionsetcontainer=mypdb;alterdatabasedatafile9,10,11,12,13online;alterdatabaseopen;--oraltersessionsetcontainer="CDB$ROOT";alterpluggabledatabasemypdbopen;

pdb迁移，no-cdb pdb

--备份BACKUPformat'/backup/testpdb_full_%T_%s_%p'PLUGGABLEDATABASEtestpdbPLUSARCHIVELOG;--卸载/导出pdbsqlplus/assysdbaalterpluggabledatabasetestpdbunpluginto'/home/oracle/testpdb.xml';--删除pdb,迁移可不删除,注意不能删除数据文件droppluggabledatabasetestpdbkeepdatafiles;--检查目标cdb，是否适用备份的pdbSETSERVEROUTPUTONDECLAREcompatibleCONSTANTVARCHAR2(3):=CASEDBMS_PDB.CHECK_PLUG_COMPATIBILITY(pdb_descr_file=>'/home/oracle/testpdb.xml')WHENTRUETHEN'YES'ELSE'NO'END;BEGINDBMS_OUTPUT.PUT_LINE(compatible);END;/--创建pdbcreatepluggabledatabasetestpdbusing'/home/oracle/testpdb.xml'--nocopytempfilereuse;FILE_NAME_CONVERT=('/u01/app/oracle/oradata/MYDB19C/pdbseed/','/u01/app/oracle/oradata/testpdb');--openalterpluggabledatabasetestpdbopen;--恢复，手动删除原有数据文件,可不删除，直接恢复SETPREPLUGINCONTAINER=testpdb;LISTPREPLUGINBACKUPOFPLUGGABLEDATABASEtestpdb;--恢复RESTOREPLUGGABLEDATABASEtestpdbFROMPREPLUGIN;RECOVERPLUGGABLEDATABASEtestpdbFROMPREPLUGIN;catalogprepluginarchivelog'/u01/app/oracle_base/oradata/CDB18/arch/1_26_969723966.dbf';--检查RESTOREPLUGGABLEDATABASEtestpdbSKIPPREPLUGIN;--openRECOVERPLUGGABLEDATABASEtestpdb;ALTERPLUGGABLEDATABASEtestpdbopen;--orrmantargetsys/oracle@testpdbrecoverdatabase;Duplicating pdb 复制到已存在的另一个cdb中

限制

Only active database duplication is supported.

Only the following clauses of the DUPLICATE command are supported: NORESUME,
DB_FILE_NAME_CONVERT, SECTION SIZE, and USING COMPRESSED BACKUPSET

The following clauses of the DUPLICATE command are not supported: SPFILE, NO
STANDBY, FARSYNC STANDBY, and LOG_FILE_NAME_CONVERT.

Duplicating a PDB to a CDB that is a standby database is not supported

Only one PDB can be duplicated at a time.

Partial PDB duplication is not supported, only complete PDB duplication is
supported. For example, you cannot include or exclude specific tablespaces while
duplicating a PDB

Duplicating a non-CDB as a PDB in an existing CDB is not supported.

Duplicating PDBs that contain TDE-encrypted tablespaces is not supported.

步骤

--配置网络MYDB19C=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node216)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mydb19c)))TESTCDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node217)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=testcdb)))--创建相关目录，目标端mkdir-p/u01/app/oracle/oradata/TESTCDB/mystpdb--临时存放归档等mkdir-p/backup/mystpdbaltersystemsetremote_recovery_file_dest='/backup/mystpdb';--连接rmantargetsys/oracle@mydb19cauxiliarysys/oracle@testcdb--开始复制DUPLICATEPLUGGABLEDATABASEmypdbASmystpdbTOtestcdbFROMACTIVEDATABASEDB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/mypdb','/u01/app/oracle/oradata/TESTCDB/mystpdb';--会自动导入相关元数据

复制大概过程

恢复数据文件：restore complete of datafile 14 to datafile copy

创建pdb

CREATEPLUGGABLEDATABASEmystpdbASCLONEUSING'/u01/app/oracle/product/19.0.0/dbhome_1/dbs/_rm_pdb_pitr_1_testcdb.xml'SOURCE_FILE_NAME_CONVERT=('/u01/app/oracle/oradata/mypdb/mypdp_system01.dbf','/u01/app/oracle/oradata/TESTCDB/mystpdb/mypdp_system01.dbf')NOCOPYREFRESHMODEMANUAL;

拷贝归档至目标端，并应用，增量/不完成恢复完成

调整数据文件号：删除之前，根据新环境整理新的file_id

open pdb

远程克隆方式

--源端设置用户权限altersessionsetcontainer=mypdb;grantcreatepluggabledatabasetomypdb;--目标端创建dblinkcreatedatabaselinkclonePdbconnecttomypdbidentifiedbymypdbusing'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.80.216)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mypdb)))';--开始创建，与Duplicating处理过程相似createpluggabledatabasepdb8frommypdb@clonePdbFILE_NAME_CONVERT=('/u01/app/oracle/oradata/mypdb','/u01/app/oracle/oradata/TESTCDB/pdb8');

到此，相信大家对“Oracle19c rman使用简单测试分析”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！