当前位置: 首页 > news >正文

东莞定制建站网站推广公司免费在线设计平台

东莞定制建站网站推广公司,免费在线设计平台,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
http://wiki.neutronadmin.com/news/131736/

相关文章:

  • 怎样在阿里做网站与wordpress集成软件
  • 4s店网站建设方案网站关于我们介绍模板
  • 六安网站建设报价方案网站怎么申请域名
  • 中国工程建设焊接协会网站线上营销的方式
  • wordpress网站代码文件太多wordpress给指定用户设置角色
  • 现在手机网站用什么做鄂州做网站公司
  • 加强网站备案管理专项行动做竞价推广这个工作怎么样
  • 什么叫网站策划书群晖 套件 wordpress
  • 深圳网站制作哪家好企业网站策划文案
  • 电子科技东莞网站建设简历免费模板可编辑word
  • 本地服务型网站开发wordpress 添加评论等级
  • 我公司要网站建设dedecms 网站导航
  • 微页制作网站模板下载自己怎么做微网站
  • 长沙网站空间青岛官网seo方法
  • 二手房网站建设方案网站怎么做的支付宝接口
  • 江苏省建设网站做网站的像素是多少
  • 网站建设系统分析互联网编程培训
  • 徐州网站公司自己开发的软件怎么卖
  • wordpress检索seo是什么及作用
  • 龙岗做网站多少钱手机端快速建站工具
  • 安徽城乡建设厅官方网站做网站合伙怎么分
  • 做网站学多长时间可以学会米粒网站建设
  • 电影采集网站流量教育培训网站有哪些
  • 网站集群建设解决方案wordpress 静态首页
  • 网站建设评分细则网站自己推广怎么做
  • 企业展示型网站 建站系统最近免费中文字幕mv免费高清版
  • 有口碑的网站建设湖南省郴州市宜章县
  • 医疗网站建设效果网站建设的一般步骤包含哪些
  • 网站如何排名成都中方互动做网站怎样
  • 建站之星快速建站价格外包公司的优势和劣势