小编给大家分享一下如何使用RMAN对PDB中的表空间或数据文件执行完全恢复，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！

因为不同PDB中的表空间可以有相同的名字，为了消除这种混淆你必须直接连接到PDB来恢复PDB的表空间。相反，因为数据文件号与路径名是跨CDB唯一标识的，所以可以连接到root容器或PDB来恢复PDB的数据文件。如果连接到CDB的root容器，那么可以使用单个命令来恢复多个PDB中的数据文件。如果连接到PDB，只能恢复PDB中的数据文件。

还原与恢复PDB中的non-SYSTEM表空间
1.启动RMAN并连接到目标数据库

[oracle@jytest1~]$rmantargetsys/xxxxx@jypdbRecoveryManager:Release12.2.0.1.0-ProductiononMonDec1117:59:272017Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:JY:JYPDB(DBID=4203494064)

2.如果数据库的状态为open，那么将要恢复的表空间置于脱机状态

SQL>altertablespacetestofflineimmediate;Tablespacealtered.

3.使用show命令来查看是否配置了预先设置的通道。如果需要的设置类型与通道被配置，那么不需要执行任何操作。否则可以使用configure命令来配置自动通道，或都使用包含allocate channel命令的run块

RMAN>showall;RMANconfigurationparametersfordatabasewithdb_unique_nameJYare:CONFIGURERETENTIONPOLICYTOREDUNDANCY1;#defaultCONFIGUREBACKUPOPTIMIZATIONOFF;#defaultCONFIGUREDEFAULTDEVICETYPETODISK;#defaultCONFIGURECONTROLFILEAUTOBACKUPON;#defaultCONFIGURECONTROLFILEAUTOBACKUPFORMATFORDEVICETYPEDISKTO'+test/rman_backup/%F';CONFIGUREDEVICETYPEDISKPARALLELISM1BACKUPTYPETOBACKUPSET;#defaultCONFIGUREDATAFILEBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGUREARCHIVELOGBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGUREMAXSETSIZETOUNLIMITED;#defaultCONFIGUREENCRYPTIONFORDATABASEOFF;#defaultCONFIGUREENCRYPTIONALGORITHM'AES128';#defaultCONFIGURECOMPRESSIONALGORITHM'BASIC'ASOFRELEASE'DEFAULT'OPTIMIZEFORLOADTRUE;#defaultCONFIGURERMANOUTPUTTOKEEPFOR7DAYS;#defaultCONFIGUREARCHIVELOGDELETIONPOLICYTONONE;#defaultCONFIGURESNAPSHOTCONTROLFILENAMETO'+test/jy/snapcf_jy.f';

4.还原与恢复表空间
.如果将数据文件还原到原始位置，那么执行restore tablespace与recover tablespace命令

.如果将数据文件还原到新目录，那么在run命令块中执行restore tablespace与recover tablespace命令，并且使用set newname命令来重命名数据文件。

RMAN>restoretablespace'TEST';Startingrestoreat11-DEC-17usingchannelORA_DISK_1channelORA_DISK_1:startingdatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_DISK_1:restoringdatafile00015to+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609channelORA_DISK_1:readingfrombackuppiece+TEST/rman_backup/jy_979425723_20171211_0osls830_1_1channelORA_DISK_1:piecehandle=+TEST/rman_backup/jy_979425723_20171211_0osls830_1_1tag=TAG20171211T164446channelORA_DISK_1:restoredbackuppiece1channelORA_DISK_1:restorecomplete,elapsedtime:00:00:03Finishedrestoreat11-DEC-17RMAN>recovertablespace'TEST';Startingrecoverat11-DEC-17usingchannelORA_DISK_1startingmediarecoverymediarecoverycomplete,elapsedtime:00:00:01Finishedrecoverat11-DEC-17

5.检查输出结果查看是否恢复成功。如果恢复成功将表空间设置为联机状态

RMAN>altertablespacetestonline;Statementprocessed

还原与恢复PDB中的SYSTEM表空间
1.启动RMAN并使用有sysdba或sysbackup权限的公共用户连接到root容器。

[oracle@jytest1~]$rmantarget/catalogrco/abcd@jypdb_173RecoveryManager:Release12.2.0.1.0-ProductiononMonDec1118:11:552017Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:JY(DBID=979425723)connectedtorecoverycatalogdatabase

2.关闭CDB并重启到mount状态

SQL>conn/assysdbaConnected.SQL>shutdownimmediate;Databaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>startupmountORACLEinstancestarted.TotalSystemGlobalArea6442450944bytesFixedSize8807168bytesVariableSize1895828736bytesDatabaseBuffers4529848320bytesRedoBuffers7966720bytesDatabasemounted.

3.还原与恢复PDB中SYSTEM表空间的数据文件

[oracle@jytest1~]$rmantarget/catalogrco/abcd@jypdb_173RecoveryManager:Release12.2.0.1.0-ProductiononMonDec1118:20:302017Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:JY(DBID=979425723,notopen)connectedtorecoverycatalogdatabaseRMAN>reportschema;startingfullresyncofrecoverycatalogfullresynccompleteReportofdatabaseschemafordatabasewithdb_unique_nameJYListofPermanentDatafiles===========================FileSize(MB)TablespaceRBsegsDatafileName---------------------------------------------------------------1830SYSTEMYES+DATA/JY/DATAFILE/system.317.96220960331230SYSAUXNO+DATA/JY/DATAFILE/sysaux.298.962209605475UNDOTBS1YES+DATA/JY/DATAFILE/undotbs1.277.9622096055250PDB$SEED:SYSTEMNO+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.9622096756340PDB$SEED:SYSAUXNO+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.96220967575USERSNO+DATA/JY/DATAFILE/users.301.9622096058100PDB$SEED:UNDOTBS1NO+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675950UNDOTBS2YES+DATA/JY/DATAFILE/undotbs2.312.96220960510260JYPDB:SYSTEMYES+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.96220964911460JYPDB:SYSAUXNO+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.96220964912100JYPDB:UNDOTBS1YES+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.96220964913100JYPDB:UNDO_2YES+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649145JYPDB:USERSNO+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.96220964915100JYPDB:TESTNO+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.96221060916260TESTPDB:SYSTEMYES+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.96246940917460TESTPDB:SYSAUXNO+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.96246940918100TESTPDB:UNDOTBS1YES+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.96246940919100TESTPDB:UNDO_2YES+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409205TESTPDB:USERSNO+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.96246940921100TESTPDB:TESTNO+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409ListofTemporaryFiles=======================FileSize(MB)TablespaceMaxsize(MB)TempfileName---------------------------------------------------------------1142TEMP32767+DATA/JY/TEMPFILE/temp.299.961976339264PDB$SEED:TEMP32767+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/TEMPFILE/temp.297.9622098653135JYPDB:TEMP32767+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/TEMPFILE/temp.276.9622105194135TESTPDB:TEMP32767+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/TEMPFILE/temp.258.962469435RMAN>restoretablespace'JYPDB:SYSTEM';Startingrestoreat11-DEC-17allocatedchannel:ORA_DISK_1channelORA_DISK_1:SID=10instance=jy1devicetype=DISKRMAN-00571:===========================================================RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:===========================================================RMAN-03002:failureofrestorecommandat12/11/201718:21:09RMAN-06004:ORACLEerrorfromrecoverycatalogdatabase:RMAN-20202:TablespacenotfoundintherecoverycatalogRMAN-06019:couldnottranslatetablespacename"JYPDB:SYSTEM"

这里在还原SYSTEM表空间时使用表空间名时会报错，如是使用restore datafile与recover datafile方法来还原与恢复SYSTEM表空间

RMAN>restoredatafile10;Startingrestoreat11-DEC-17usingchannelORA_DISK_1channelORA_DISK_1:startingdatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_DISK_1:restoringdatafile00010to+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649channelORA_DISK_1:readingfrombackuppiece+TEST/rman_backup/jy_979425723_20171211_0osls830_1_1channelORA_DISK_1:piecehandle=+TEST/rman_backup/jy_979425723_20171211_0osls830_1_1tag=TAG20171211T164446channelORA_DISK_1:restoredbackuppiece1channelORA_DISK_1:restorecomplete,elapsedtime:00:00:15Finishedrestoreat11-DEC-17RMAN>recoverdatafile10;Startingrecoverat11-DEC-17usingchannelORA_DISK_1startingmediarecoverymediarecoverycomplete,elapsedtime:00:00:01Finishedrecoverat11-DEC-17

4.打开CDB中的所有PDB

RMAN>alterdatabaseopen;StatementprocessedstartingfullresyncofrecoverycatalogfullresynccompleteRMAN>alterpluggabledatabaseallopenreadwrite;Statementprocessedstartingfullresyncofrecoverycatalogfullresynccomplete

看完了这篇文章，相信你对“如何使用RMAN对PDB中的表空间或数据文件执行完全恢复”有了一定的了解，如果想了解更多相关知识，欢迎关注亿速云行业资讯频道，感谢各位的阅读！