本文共 3437 字,大约阅读时间需要 11 分钟。
解决方法:
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/