东莞定制建站网站推广公司,免费在线设计平台,dedecms5.7装饰公司网站模板,学生成绩管理系统 网站建设NOCDB情况下#xff0c;要把ASM中的文件恢复到文件系统#xff0c;大家都知道分别设置每个文件的路径即可#xff0c;但如果是租户环境#xff0c;每个PDB都有不同路径#xff0c;而且每个PDB都有SYSTEM#xff0c;SYSAUX等一些表空降#xff0c;不可能放在同一个目录中…NOCDB情况下要把ASM中的文件恢复到文件系统大家都知道分别设置每个文件的路径即可但如果是租户环境每个PDB都有不同路径而且每个PDB都有SYSTEMSYSAUX等一些表空降不可能放在同一个目录中而是放在不同的目录那恢复时怎么设置呢 比如下面数据库以在本地恢复为例如果是异机恢复步骤类似SYSorclcdb show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORCLPDB READ WRITE NOORCLCDB,有一个PDBORCLPDB,一个PDBSEED数据文件放在ASM磁盘组DATA中想整体恢复到文件系统比如 /u01/app/oracle/oradata/orclcdb/RMAN report schema;Report of database schema for database with db_unique_name ORCLCDBList of Permanent DatafilesFile Size(MB) Tablespace RB segs Datafile Name---- -------- -------------------- ------- ------------------------1 1700 SYSTEM *** DATA/ORCLCDB/DATAFILE/system.257.11402868273 1024 SYSAUX *** DATA/ORCLCDB/DATAFILE/sysaux.258.11402869634 1500 UNDOTBS1 *** DATA/ORCLCDB/DATAFILE/undotbs1.259.11402870295 540 PDB$SEED:SYSTEM *** DATA/ORCLCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.266.11402899956 430 PDB$SEED:SYSAUX *** DATA/ORCLCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.267.11402899957 5 USERS *** DATA/ORCLCDB/DATAFILE/users.260.11402870298 215 PDB$SEED:UNDOTBS1 *** DATA/ORCLCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.268.11402899959 550 ORCLPDB:SYSTEM *** DATA/ORCLCDB/FECB9F1537517278E0537885A8C0E7DC/DATAFILE/system.272.114029228910 500 ORCLPDB:SYSAUX *** DATA/ORCLCDB/FECB9F1537517278E0537885A8C0E7DC/DATAFILE/sysaux.273.114029228911 215 ORCLPDB:UNDOTBS1 *** DATA/ORCLCDB/FECB9F1537517278E0537885A8C0E7DC/DATAFILE/undotbs1.271.114029228912 15 ORCLPDB:USERS *** DATA/ORCLCDB/FECB9F1537517278E0537885A8C0E7DC/DATAFILE/users.275.1140292305List of Temporary FilesFile Size(MB) Tablespace Maxsize(MB) Tempfile Name---- -------- -------------------- ----------- --------------------1 500 TEMP 32767 DATA/ORCLCDB/TEMPFILE/temp.265.11402870892 138 PDB$SEED:TEMP 32767 DATA/ORCLCDB/FECB1A5B8C146A75E0537885A8C0F418/TEMPFILE/temp.269.11402900633 139 ORCLPDB:TEMP 32767 DATA/ORCLCDB/FECB9F1537517278E0537885A8C0E7DC/TEMPFILE/temp.274.1140292293步骤如下
1.备份 rman backup database plus archivelog;
2.关闭数据库 sqlshutdown immediate;
3.恢复到文件系统 RMANrun{allocate channel c1 device type disk;allocate channel c2 device type disk;allocate channel c3 device type disk;allocate channel c4 device type disk;set newname for database cdb$root to /u01/app/oracle/oradata/ORCLCDB/%b;set newname for database PDB$SEED to /u01/app/oracle/oradata/ORCLCDB/pdbseed/%b;set newname for database ORCLPDB to /u01/app/oracle/oradata/ORCLCDB/orclpdb/%b;restore database root database PDB$SEED DATABASE ORCLPDB;switch datafile all;switch tempfile all;recover database;}需要注意的是这里不同的PDB要对应到不同的目录需要单独指定PDB而且cdb$root要单独指定。allocated channel: c1channel c1: SID613 device typeDISKallocated channel: c2channel c2: SID11 device typeDISKallocated channel: c3channel c3: SID213 device typeDISKallocated channel: c4channel c4: SID414 device typeDISKexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting restore at 19-AUG-23channel c2: starting datafile backup set restorechannel c2: specifying datafile(s) to restore from backup setchannel c2: restoring datafile 00001 to /u01/app/oracle/oradata/ORCLCDB/system.257.1140286827channel c2: restoring datafile 00003 to /u01/app/oracle/oradata/ORCLCDB/sysaux.258.1140286963channel c2: restoring datafile 00004 to /u01/app/oracle/oradata/ORCLCDB/undotbs1.259.1140287029channel c2: restoring datafile 00007 to /u01/app/oracle/oradata/ORCLCDB/users.260.1140287029channel c2: reading from backup piece FRA/ORCLCDB/BACKUPSET/2023_08_19/nnndf0_tag20230819t170606_0.291.1145293567channel c3: starting datafile backup set restorechannel c3: specifying datafile(s) to restore from backup setchannel c3: restoring datafile 00009 to /u01/app/oracle/oradata/ORCLCDB/orclpdb/system.272.1140292289channel c3: restoring datafile 00010 to /u01/app/oracle/oradata/ORCLCDB/orclpdb/sysaux.273.1140292289channel c3: restoring datafile 00011 to /u01/app/oracle/oradata/ORCLCDB/orclpdb/undotbs1.271.1140292289channel c3: restoring datafile 00012 to /u01/app/oracle/oradata/ORCLCDB/orclpdb/users.275.1140292305channel c3: reading from backup piece FRA/ORCLCDB/FECB9F1537517278E0537885A8C0E7DC/BACKUPSET/2023_08_19/nnndf0_tag20230819t170606_0.290.1145293671channel c1: restoring datafile 00005input datafile copy RECID22 STAMP1144754940 file nameFRA/ORCLCDB/FECB1A5B8C146A75E0537885A8C0F418/DATAFILE/system.260.1144754939destination for restore of datafile 00005: /u01/app/oracle/oradata/ORCLCDB/pdbseed/system.266.1140289995channel c4: restoring datafile 00006input datafile copy RECID24 STAMP1144754946 file nameFRA/ORCLCDB/FECB1A5B8C146A75E0537885A8C0F418/DATAFILE/sysaux.259.1144754945destination for restore of datafile 00006: /u01/app/oracle/oradata/ORCLCDB/pdbseed/sysaux.267.1140289995channel c4: copied datafile copy of datafile 00006, elapsed time: 00:00:45output file name/u01/app/oracle/oradata/ORCLCDB/pdbseed/sysaux.267.1140289995 RECID34 STAMP1145295053channel c4: restoring datafile 00008input datafile copy RECID25 STAMP1144754949 file nameFRA/ORCLCDB/FECB1A5B8C146A75E0537885A8C0F418/DATAFILE/undotbs1.268.1144754949destination for restore of datafile 00008: /u01/app/oracle/oradata/ORCLCDB/pdbseed/undotbs1.268.1140289995channel c1: copied datafile copy of datafile 00005, elapsed time: 00:01:00output file name/u01/app/oracle/oradata/ORCLCDB/pdbseed/system.266.1140289995 RECID36 STAMP1145295065channel c3: piece handleFRA/ORCLCDB/FECB9F1537517278E0537885A8C0E7DC/BACKUPSET/2023_08_19/nnndf0_tag20230819t170606_0.290.1145293671 tagTAG20230819T170606channel c3: restored backup piece 1channel c3: restore complete, elapsed time: 00:01:00channel c4: copied datafile copy of datafile 00008, elapsed time: 00:00:15output file name/u01/app/oracle/oradata/ORCLCDB/pdbseed/undotbs1.268.1140289995 RECID38 STAMP1145295072channel c2: piece handleFRA/ORCLCDB/BACKUPSET/2023_08_19/nnndf0_tag20230819t170606_0.291.1145293567 tagTAG20230819T170606channel c2: restored backup piece 1channel c2: restore complete, elapsed time: 00:01:41Finished restore at 19-AUG-23datafile 1 switched to datafile copyinput datafile copy RECID41 STAMP1145295112 file name/u01/app/oracle/oradata/ORCLCDB/system.257.1140286827datafile 3 switched to datafile copyinput datafile copy RECID42 STAMP1145295112 file name/u01/app/oracle/oradata/ORCLCDB/sysaux.258.1140286963datafile 4 switched to datafile copyinput datafile copy RECID43 STAMP1145295112 file name/u01/app/oracle/oradata/ORCLCDB/undotbs1.259.1140287029datafile 7 switched to datafile copyinput datafile copy RECID44 STAMP1145295112 file name/u01/app/oracle/oradata/ORCLCDB/users.260.1140287029datafile 5 switched to datafile copyinput datafile copy RECID45 STAMP1145295112 file name/u01/app/oracle/oradata/ORCLCDB/pdbseed/system.266.1140289995datafile 6 switched to datafile copyinput datafile copy RECID46 STAMP1145295113 file name/u01/app/oracle/oradata/ORCLCDB/pdbseed/sysaux.267.1140289995datafile 8 switched to datafile copyinput datafile copy RECID47 STAMP1145295113 file name/u01/app/oracle/oradata/ORCLCDB/pdbseed/undotbs1.268.1140289995datafile 9 switched to datafile copyinput datafile copy RECID48 STAMP1145295113 file name/u01/app/oracle/oradata/ORCLCDB/orclpdb/system.272.1140292289datafile 10 switched to datafile copyinput datafile copy RECID49 STAMP1145295113 file name/u01/app/oracle/oradata/ORCLCDB/orclpdb/sysaux.273.1140292289datafile 11 switched to datafile copyinput datafile copy RECID50 STAMP1145295113 file name/u01/app/oracle/oradata/ORCLCDB/orclpdb/undotbs1.271.1140292289datafile 12 switched to datafile copyinput datafile copy RECID51 STAMP1145295113 file name/u01/app/oracle/oradata/ORCLCDB/orclpdb/users.275.1140292305Starting recover at 19-AUG-23starting media recoverymedia recovery complete, elapsed time: 00:00:01Finished recover at 19-AUG-23released channel: c1released channel: c2released channel: c3released channel: c44.打开数据库 RMAN alter database open
5.验证数据库数据文件
SYSorclcdb select name from v$datafile;NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/ORCLCDB/system.257.1140286827/u01/app/oracle/oradata/ORCLCDB/sysaux.258.1140286963/u01/app/oracle/oradata/ORCLCDB/undotbs1.259.1140287029/u01/app/oracle/oradata/ORCLCDB/pdbseed/system.266.1140289995/u01/app/oracle/oradata/ORCLCDB/pdbseed/sysaux.267.1140289995/u01/app/oracle/oradata/ORCLCDB/users.260.1140287029/u01/app/oracle/oradata/ORCLCDB/pdbseed/undotbs1.268.1140289995/u01/app/oracle/oradata/ORCLCDB/orclpdb/system.272.1140292289/u01/app/oracle/oradata/ORCLCDB/orclpdb/sysaux.273.1140292289/u01/app/oracle/oradata/ORCLCDB/orclpdb/undotbs1.271.1140292289/u01/app/oracle/oradata/ORCLCDB/orclpdb/users.275.11402923056. 临时文件及其他文件的处理
可以参照这个处理http://bbs.cqsztech.com/forum.ph ... hlight%D2%EC%BB%FA附录 mos: Doc ID 2818346.1