这篇文章主要讲解了“怎么解决Oracle中提示PDB库有数据文件需要进行介质恢复问题”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“怎么解决Oracle中提示PDB库有数据文件需要进行介质恢复问题”吧！

Oracle Linux 7.1数据库为Oracle 12.2.0.1 RAC，数据库启用了归档，在手动关闭数据库后启动数据库时提示PDB库有数据文件需要进行介质恢复

[grid@jytest1~]$srvctlstopdatabase-dbjy[grid@jytest1~]$crsctlstatres-t--------------------------------------------------------------------------------NameTargetStateServerStatedetails--------------------------------------------------------------------------------LocalResources--------------------------------------------------------------------------------ora.ASMNET1LSNR_ASM.lsnrONLINEONLINEjytest1STABLEONLINEONLINEjytest2STABLEora.CRS.dgONLINEONLINEjytest1STABLEONLINEONLINEjytest2STABLEora.DATA.dgONLINEONLINEjytest1STABLEONLINEONLINEjytest2STABLEora.FRA.dgONLINEONLINEjytest1STABLEONLINEONLINEjytest2STABLEora.LISTENER.lsnrONLINEONLINEjytest1STABLEONLINEONLINEjytest2STABLEora.TEST.dgONLINEONLINEjytest1STABLEONLINEONLINEjytest2STABLEora.chadONLINEONLINEjytest1STABLEONLINEONLINEjytest2STABLEora.net1.networkONLINEONLINEjytest1STABLEONLINEONLINEjytest2STABLEora.onsONLINEONLINEjytest1STABLEONLINEONLINEjytest2STABLEora.proxy_advmOFFLINEOFFLINEjytest1STABLEOFFLINEOFFLINEjytest2STABLE--------------------------------------------------------------------------------ClusterResources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1ONLINEONLINEjytest1STABLEora.LISTENER_SCAN2.lsnr1ONLINEONLINEjytest2STABLEora.LISTENER_SCAN3.lsnr1ONLINEONLINEjytest2STABLEora.MGMTLSNR1ONLINEONLINEjytest2169.254.237.25088.88.88.2,STABLEora.asm1ONLINEONLINEjytest1Started,STABLE2ONLINEONLINEjytest2STABLE3ONLINEOFFLINESTABLEora.cvu1ONLINEONLINEjytest2STABLEora.jy.db1OFFLINEOFFLINEInstanceShutdown,STABLE2OFFLINEOFFLINEInstanceShutdown,STABLEora.jy.jy_srv.svc1OFFLINEOFFLINESTABLEora.jytest1.vip1ONLINEONLINEjytest1STABLEora.jytest2.vip1ONLINEONLINEjytest2STABLEora.mgmtdb1ONLINEONLINEjytest2Open,STABLEora.qosmserver1ONLINEONLINEjytest1STABLEora.scan1.vip1ONLINEONLINEjytest1STABLEora.scan2.vip1ONLINEONLINEjytest2STABLEora.scan3.vip1ONLINEONLINEjytest2STABLE--------------------------------------------------------------------------------

提示PDB的数据文件需要进行介质恢复，文件号是38

[grid@jytest1~]$srvctlstartdatabase-dbjyPRCR-1079:Failedtostartresourceora.jy.dbCRS-5017:Theresourceaction"ora.jy.dbstart"encounteredthefollowingerror:ORA-01113:file38needsmediarecoveryORA-01110:datafile38:'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649'.Fordetailsreferto"(:CLSN00107:)"in"/u01/app/grid/diag/crs/jytest2/crs/trace/crsd_oraagent_oracle.trc".CRS-2674:Startof'ora.jy.db'on'jytest2'failedCRS-5017:Theresourceaction"ora.jy.dbstart"encounteredthefollowingerror:ORA-01113:file38needsmediarecoveryORA-01110:datafile38:'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649'.Fordetailsreferto"(:CLSN00107:)"in"/u01/app/grid/diag/crs/jytest1/crs/trace/crsd_oraagent_oracle.trc".CRS-2674:Startof'ora.jy.db'on'jytest1'failedCRS-2632:Therearenomoreserverstotrytoplaceresource'ora.jy.db'onthatwouldsatisfyitsplacementpolicy

对38号文件执行介质恢复

[oracle@jytest1~]$sqlplus/assysdbaSQL*Plus:Release12.2.0.1.0ProductiononWedFeb1317:47:552019Copyright(c)1982,2016,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupORACLEinstancestarted.TotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1610616096bytesDatabaseBuffers520093696bytesRedoBuffers7979008bytesDatabasemounted.ORA-01113:file38needsmediarecoveryORA-01110:datafile38:'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649'SQL>recoverdatafile38;Mediarecoverycomplete.

在对38号文件进行介质恢复后打开CDB时提示39号文件也需要进行介质恢复

SQL>alterdatabaseopen;alterdatabaseopen*ERRORatline1:ORA-01113:file39needsmediarecoveryORA-01110:datafile39:'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649'

如是执行recover database命令来对CDB进行介质恢复并打开CDB

SQL>recoverdatabase;Mediarecoverycomplete.SQL>alterdatabaseopen;Databasealtered.

在打开JYPDB时提示PDB的45号文件需要进行介质恢复

SQL>alterpluggabledatabasejypdbopen;alterpluggabledatabasejypdbopen*ERRORatline1:ORA-01113:file45needsmediarecoveryORA-01110:datafile45:'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783'

如是对45号文件进行介质恢复，虽然介质恢复成功但在打开jypdb时仍然提示需要进行介质恢复

SQL>recoverdatafile45;Mediarecoverycomplete.SQL>alterpluggabledatabasejypdbopen;alterpluggabledatabasejypdbopen*ERRORatline1:ORA-01113:file45needsmediarecoveryORA-01110:datafile45:'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783'

如是查询数据文件检查点SCN与数据文件头SCN，发现44与45号文件的数据文件检查点SCN与数据文件头SCN号不一致并且数据文件检查点SCN比数据文件头SCN号大，因此需要进行日志文件来进行恢复。但在执行recover datafile命令成功后，打开JYPDB时仍然提示需要进行介质恢复。

SQL>selectFILE#,CHECKPOINT_CHANGE#,LAST_CHANGE#fromv$datafile;FILE#CHECKPOINT_CHANGE#LAST_CHANGE#----------------------------------------11761179983176117998417611799851449535144953561449535144953571761179988144953514495359176117998381760985931760985933917609859317609859340176098593176098593FILE#CHECKPOINT_CHANGE#LAST_CHANGE#----------------------------------------411760985931760985934217609859317609859343176098593176098593441760985931758983224517609859317589832246216646762166467647216646762166467648216646762166467649216646762166467650216646762166467651216646762166467622rowsselected.SQL>selectFILE#,CHECKPOINT_CHANGE#fromv$datafile_header;FILE#CHECKPOINT_CHANGE#----------------------------11761179983176117998417611799851449535614495357176117998814495359176117998381760985933917609859340176098593FILE#CHECKPOINT_CHANGE#----------------------------411760985934217609859343176098593441758983224517589832246216646764721664676482166467649216646765021664676512166467622rowsselected.

如是打算重建控制文件再执行介质恢复，下面先备份控制文件到跟踪文件，在跟踪文件中有重建控制文件的相关命令

SQL>alterdatabasebackupcontrolfiletotraceas'/tmp/ctl.txt';Databasealtered.

关闭RAC数据库

SQL>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.

将RAC数据库启动到nomount状态

SQL>STARTUPNOMOUNTORACLEinstancestarted.TotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1610616096bytesDatabaseBuffers520093696bytesRedoBuffers7979008bytes

重建控制文件，提示数据库不是排他模式，也就是说在RAC环境不能重建控制文件

SQL>CREATECONTROLFILEREUSEDATABASE"JY"NORESETLOGSARCHIVELOG2MAXLOGFILES1923MAXLOGMEMBERS34MAXDATAFILES10245MAXINSTANCES326MAXLOGHISTORY2927LOGFILE8GROUP1'+DATA/JY/ONLINELOG/group_1.261.961976319'SIZE200MBLOCKSIZE512,9GROUP2'+DATA/JY/ONLINELOG/group_2.302.961976321'SIZE200MBLOCKSIZE512,10GROUP3'+DATA/JY/ONLINELOG/group_3.263.961976697'SIZE200MBLOCKSIZE512,11GROUP4'+DATA/JY/ONLINELOG/group_4.262.961976705'SIZE200MBLOCKSIZE512,12GROUP6(13'+DATA/JY/ONLINELOG/group_6.280.972435899',14'+FRA/JY/ONLINELOG/group_6.354.972435909'15)SIZE200MBLOCKSIZE51216--STANDBYLOGFILE17DATAFILE18'+DATA/JY/DATAFILE/system.317.962209603',19'+DATA/JY/DATAFILE/sysaux.298.962209605',20'+DATA/JY/DATAFILE/undotbs1.277.962209605',21'+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675',22'+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675',23'+DATA/JY/DATAFILE/users.301.962209605',24'+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675',25'+DATA/JY/DATAFILE/undotbs2.312.962209605',26'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649',27'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649',28'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649',29'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649',30'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649',31'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609',32'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/tts.257.966380353',33'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783',34'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409',35'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409',36'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409',37'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409',38'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409',39'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409'40CHARACTERSETZHS16GBK41;CREATECONTROLFILEREUSEDATABASE"JY"NORESETLOGSARCHIVELOG*ERRORatline1:ORA-01503:CREATECONTROLFILEfailedORA-12720:operationrequiresdatabaseisinEXCLUSIVEmode

修改数据库为排他模式

SQL>showparameterclusterNAMETYPEVALUE-----------------------------------------------------------------------------cdb_clusterbooleanFALSEcdb_cluster_namestringjycluster_databasebooleanTRUEcluster_database_instancesinteger2cluster_interconnectsstringSQL>altersystemsetcluster_database=falsescope=spfilesid='*';Systemaltered.

重启数据库到nomount状态

SQL>shtudownimmediateSP2-0734:unknowncommandbeginning"shtudowni..."-restoflineignored.SQL>shutdownimmediateORA-01507:databasenotmountedORACLEinstanceshutdown.SQL>STARTUPNOMOUNTORACLEinstancestarted.TotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1459621152bytesDatabaseBuffers671088640bytesRedoBuffers7979008bytes

重建控制文件

SQL>CREATECONTROLFILEREUSEDATABASE"JY"NORESETLOGSARCHIVELOG2MAXLOGFILES1923MAXLOGMEMBERS34MAXDATAFILES10245MAXINSTANCES326MAXLOGHISTORY2927LOGFILE8GROUP1'+DATA/JY/ONLINELOG/group_1.261.961976319'SIZE200MBLOCKSIZE512,9GROUP2'+DATA/JY/ONLINELOG/group_2.302.961976321'SIZE200MBLOCKSIZE512,10GROUP3'+DATA/JY/ONLINELOG/group_3.263.961976697'SIZE200MBLOCKSIZE512,11GROUP4'+DATA/JY/ONLINELOG/group_4.262.961976705'SIZE200MBLOCKSIZE512,12GROUP6(13'+DATA/JY/ONLINELOG/group_6.280.972435899',14'+FRA/JY/ONLINELOG/group_6.354.972435909'15)SIZE200MBLOCKSIZE51216--STANDBYLOGFILE17DATAFILE18'+DATA/JY/DATAFILE/system.317.962209603',19'+DATA/JY/DATAFILE/sysaux.298.962209605',20'+DATA/JY/DATAFILE/undotbs1.277.962209605',21'+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675',22'+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675',23'+DATA/JY/DATAFILE/users.301.962209605',24'+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675',25'+DATA/JY/DATAFILE/undotbs2.312.962209605',26'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649',27'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649',28'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649',29'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649',30'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649',31'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609',32'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/tts.257.966380353',33'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783',34'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409',35'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409',36'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409',37'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409',38'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409',39'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409'40CHARACTERSETZHS16GBK41;Controlfilecreated.

如是查询数据文件检查点SCN与数据文件头SCN，现在44与45号文件的数据文件检查点SCN与数据文件头SCN号仍然不一致并且数据文件检查点SCN比数据文件头SCN号大

SQL>colnamefora100SQL>selectname,checkpoint_change#fromv$datafile_header;NAMECHECKPOINT_CHANGE#----------------------------------------------------------------------------------------------------------------------+DATA/JY/DATAFILE/system.317.962209603176144167+DATA/JY/DATAFILE/sysaux.298.962209605176144167+DATA/JY/DATAFILE/undotbs1.277.962209605176144167+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.9622096751449535+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.9622096751449535+DATA/JY/DATAFILE/users.301.962209605176144167+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.9622096751449535+DATA/JY/DATAFILE/undotbs2.312.962209605176144167+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649176098593+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649176098593+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649176098593+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649176098593+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649176098593+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609176098593+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/tts.257.966380353175898322+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783175898322+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.96246940921664676+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.96246940921664676+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.96246940921664676+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.96246940921664676+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.96246940921664676+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.9624694092166467622rowsselected.SQL>selectname,checkpoint_change#fromv$datafile;NAMECHECKPOINT_CHANGE#----------------------------------------------------------------------------------------------------------------------+DATA/JY/DATAFILE/system.317.962209603176144167+DATA/JY/DATAFILE/sysaux.298.962209605176144167+DATA/JY/DATAFILE/undotbs1.277.962209605176144167+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675176144167+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675176144167+DATA/JY/DATAFILE/users.301.962209605176144167+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675176144167+DATA/JY/DATAFILE/undotbs2.312.962209605176144167+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649176144167+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649176144167+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649176144167+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649176144167+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649176144167+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609176144167+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/tts.257.966380353176144167+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783176144167+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409176144167+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409176144167+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409176144167+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409176144167+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409176144167+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.96246940917614416722rowsselected.

对CDB执行介质恢复操作，根据提示输入相关的归档日志文件名来进行恢复并将CDB成功打开

SQL>recoverdatabaseORA-00279:change175898322generatedatneededforthread2Specifylog:{=suggested|filename|AUTO|CANCEL}+TEST/JY/ARCHIVELOG/2019_02_13/thread_2_seq_1073.422.1000144183ORA-00279:change176098395generatedat02/13/201917:49:43neededforthread2ORA-00289:suggestion:+TEST/arch/2_1074_961976319.dbfORA-00280:change176098395forthread2isinsequence#1074Specifylog:{=suggested|filename|AUTO|CANCEL}+TEST/JY/ARCHIVELOG/2019_02_13/thread_2_seq_1074.382.1000144185ORA-00279:change176098399generatedat02/13/201917:49:45neededforthread2ORA-00289:suggestion:+TEST/arch/2_1075_961976319.dbfORA-00280:change176098399forthread2isinsequence#1075Specifylog:{=suggested|filename|AUTO|CANCEL}+TEST/arch/2_1075_961976319.dbfORA-00279:change176098399generatedat02/13/201917:49:45neededforthread1ORA-00289:suggestion:+TEST/arch/1_1182_961976319.dbfORA-00280:change176098399forthread1isinsequence#1182Specifylog:{=suggested|filename|AUTO|CANCEL}+TEST/arch/1_1182_961976319.dbfORA-00279:change176098401generatedat02/13/201917:49:45neededforthread2ORA-00289:suggestion:+TEST/arch/2_1076_961976319.dbfORA-00280:change176098401forthread2isinsequence#1076Specifylog:{=suggested|filename|AUTO|CANCEL}+TEST/arch/2_1076_961976319.dbfORA-00288:tocontinuerecoverytypeALTERDATABASERECOVERCONTINUEORA-00278:logfile'+TEST/arch/2_1076_961976319.dbf'nolongerneededforthisrecoveryORA-00279:change176098489generatedat02/13/201917:49:50neededforthread1ORA-00289:suggestion:+TEST/arch/1_1183_961976319.dbfORA-00280:change176098489forthread1isinsequence#1183Specifylog:{=suggested|filename|AUTO|CANCEL}+TEST/arch/1_1183_961976319.dbfLogapplied.Mediarecoverycomplete.SQL>alterdatabaseopen;Databasealtered.

将PDB数据库打开

SQL>ALTERPLUGGABLEDATABASEALLOPEN;Pluggabledatabasealtered.SQL>showpdbsCON_IDCON_NAMEOPENMODERESTRICTED------------------------------------------------------------2PDB$SEEDREADONLYNO3JYPDBREADWRITENO

根据备份控制文件到跟踪文件重建控制文件的命令来添加临时表空间的相关文件

SQL>ALTERTABLESPACETEMPADDTEMPFILE'+DATA/JY/TEMPFILE/temp.299.961976339';Tablespacealtered.SQL>ALTERSESSIONSETCONTAINER=PDB$SEED;Sessionaltered.SQL>ALTERTABLESPACETEMPADDTEMPFILE'+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/TEMPFILE/temp.297.962209865'SIZE67108864REUSEAUTOEXTENDONNEXT655360MAXSIZE32767M;Tablespacealtered.SQL>ALTERSESSIONSETCONTAINER=JYPDB;Sessionaltered.SQL>ALTERTABLESPACETEMPADDTEMPFILE'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/TEMPFILE/temp.276.967852391'REUSE;Tablespacealtered.

将数据库设置为集群模式并关闭数据库

SQL>altersystemsetcluster_database=truescope=spfilesid='*';Systemaltered.SQL>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.

使用集群命令来启动数据库

[grid@jytest1~]$srvctlstartdatabase-dbjy

将JYPDB以读写方式打开

[oracle@jytest1~]$sqlplus/assysdbaSQL*Plus:Release12.2.0.1.0ProductiononWedFeb1322:30:532019Copyright(c)1982,2016,Oracle.Allrightsreserved.Connectedto:OracleDatabase12cEnterpriseEditionRelease12.2.0.1.0-64bitProductionSQL>showpdbsCON_IDCON_NAMEOPENMODERESTRICTED------------------------------------------------------------2PDB$SEEDREADONLYNO3JYPDBMOUNTEDSQL>alterpluggabledatabasejypdbopen;Pluggabledatabasealtered.SQL>showpdbsCON_IDCON_NAMEOPENMODERESTRICTED------------------------------------------------------------2PDB$SEEDREADONLYNO3JYPDBREADWRITENO[oracle@jytest2~]$sqlplus/assysdbaSQL*Plus:Release12.2.0.1.0ProductiononWedFeb1322:31:172019Copyright(c)1982,2016,Oracle.Allrightsreserved.Connectedto:OracleDatabase12cEnterpriseEditionRelease12.2.0.1.0-64bitProductionSQL>showpdbsCON_IDCON_NAMEOPENMODERESTRICTED------------------------------------------------------------2PDB$SEEDREADONLYNO3JYPDBMOUNTEDSQL>alterpluggabledatabasejypdbopen;Pluggabledatabasealtered.SQL>showpdbsCON_IDCON_NAMEOPENMODERESTRICTED------------------------------------------------------------2PDB$SEEDREADONLYNO3JYPDBREADWRITENO

到此数据库的恢复操作就完成了

感谢各位的阅读，以上就是“怎么解决Oracle中提示PDB库有数据文件需要进行介质恢复问题”的内容了，经过本文的学习后，相信大家对怎么解决Oracle中提示PDB库有数据文件需要进行介质恢复问题这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是亿速云，小编将为大家推送更多相关知识点的文章，欢迎关注！