博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
RAC 数据库数据库恢复数据文件显示为0
阅读量:5814 次
发布时间:2019-06-18

本文共 3437 字,大约阅读时间需要 11 分钟。

1,数据库异机恢复数据文件显示为0

解决方法:

CATALOG START WITH

SWITCH DATABASE TO COPY;

RMAN> report schema;List of Permanent Datafiles===========================File Size(MB) Tablespace           RB segs Datafile Name---- -------- -------------------- ------- ------------------------1    0        SYSTEM               ***     +DATA/jmrac/datafile/system.274.9832027612    0        SYSAUX               ***     +DATA/jmrac/datafile/sysaux.275.9832027613    0        UNDOTBS1             ***     +DATA/jmrac/datafile/undotbs1.276.9832027614    0        USERS                ***     +DATA/jmrac/datafile/users.277.9832027615    0        EXAMPLE              ***     +DATA/orcl/datafile/example.285.9832028596    0        UNDOTBS2             ***     +DATA/orcl/datafile/undotbs2.286.983203157List of Temporary Files=======================File Size(MB) Tablespace           Maxsize(MB) Tempfile Name---- -------- -------------------- ----------- --------------------1    20       TEMP                 32767       +DATA/orcl/tempfile/temp.284.983202853RMAN> RMAN> CATALOG START WITH '+DATA/orcl';searching for all files that match the pattern +DATA/orclList of Files Unknown to the Database=====================================File Name: +data/ORCL/DATAFILE/SYSTEM.294.984744009File Name: +data/ORCL/DATAFILE/SYSAUX.295.984744009File Name: +data/ORCL/DATAFILE/EXAMPLE.277.984744009File Name: +data/ORCL/DATAFILE/UNDOTBS1.276.984744009File Name: +data/ORCL/DATAFILE/UNDOTBS2.275.984744009File Name: +data/ORCL/DATAFILE/USERS.274.984744009Do you really want to catalog the above files (enter YES or NO)? yescataloging files...cataloging doneList of Cataloged Files=======================File Name: +data/ORCL/DATAFILE/SYSTEM.294.984744009File Name: +data/ORCL/DATAFILE/SYSAUX.295.984744009File Name: +data/ORCL/DATAFILE/EXAMPLE.277.984744009File Name: +data/ORCL/DATAFILE/UNDOTBS1.276.984744009File Name: +data/ORCL/DATAFILE/UNDOTBS2.275.984744009File Name: +data/ORCL/DATAFILE/USERS.274.984744009RMAN> SWITCH DATABASE TO COPY;datafile 1 switched to datafile copy "+DATA/orcl/datafile/system.294.984744009"datafile 2 switched to datafile copy "+DATA/orcl/datafile/sysaux.295.984744009"datafile 3 switched to datafile copy "+DATA/orcl/datafile/undotbs1.276.984744009"datafile 4 switched to datafile copy "+DATA/orcl/datafile/users.274.984744009"datafile 5 switched to datafile copy "+DATA/orcl/datafile/example.277.984744009"datafile 6 switched to datafile copy "+DATA/orcl/datafile/undotbs2.275.984744009"RMAN> report schema;List of Permanent Datafiles===========================File Size(MB) Tablespace           RB segs Datafile Name---- -------- -------------------- ------- ------------------------1    810      SYSTEM               ***     +DATA/orcl/datafile/system.294.9847440092    690      SYSAUX               ***     +DATA/orcl/datafile/sysaux.295.9847440093    95       UNDOTBS1             ***     +DATA/orcl/datafile/undotbs1.276.9847440094    36       USERS                ***     +DATA/orcl/datafile/users.274.9847440095    330      EXAMPLE              ***     +DATA/orcl/datafile/example.277.9847440096    50       UNDOTBS2             ***     +DATA/orcl/datafile/undotbs2.275.984744009List of Temporary Files=======================File Size(MB) Tablespace           Maxsize(MB) Tempfile Name---- -------- -------------------- ----------- --------------------1    20       TEMP                 32767       +DATA/orcl/tempfile/temp.284.983202853

转载地址:http://emtbx.baihongyu.com/

你可能感兴趣的文章
Http、TCP/IP协议与Socket之间的区别(转载)
查看>>
解决Unable to load R3 module ...VBoxDD.dll (VBoxDD):GetLastError=1790
查看>>
.net excel利用NPOI导入oracle
查看>>
vrpie在Visio Studio 中无法调试的问题
查看>>
第六课:数据库的基本工具
查看>>
关于二叉树重构的思索
查看>>
$_SERVER['SCRIPT_FLENAME']与__FILE__
查看>>
skynet实践(8)-接入websocket
查看>>
系统版本判断
查看>>
My97DatePicker 日历插件
查看>>
0603 学术诚信与职业道德
查看>>
小点心家族第3位成员——楼层定位效果
查看>>
Knockout.Js官网学习(enable绑定、disable绑定)
查看>>
hive基本操作与应用
查看>>
excel快捷键设置
查看>>
poj3692
查看>>
python之信号量【Semaphore】
查看>>
html5纲要,细谈HTML 5新增的元素
查看>>
Android应用集成支付宝接口的简化
查看>>
[分享]Ubuntu12.04安装基础教程(图文)
查看>>