阿里巴巴网站的功能,简单炫酷的编程代码,网站 版式,微信公众号推广赚钱引用收藏#xff1a;http://blog.itpub.net/501889/viewspace-1083311/ 同事不小心#xff0c;在RAC环境下创建了本地数据文件#xff0c;这个肯定会出问题的#xff0c;节点2不能访问此数据文件。其实发现做错了#xff0c;立马删掉应该没有问题。数据文件还没有数据。下…引用收藏http://blog.itpub.net/501889/viewspace-1083311/ 同事不小心在RAC环境下创建了本地数据文件这个肯定会出问题的节点2不能访问此数据文件。其实发现做错了立马删掉应该没有问题。数据文件还没有数据。下面演示一下错误的解决方法思路就是把本地文件COPY到共享磁盘中ASM在rename即可。点击(此处)折叠或打开SQL alter tablespace USERS add datafile /home/oracle/user01.dbf size 10m;//创建错误过程Tablespace altered.SQL alter database datafile 8 offline;Database altered.SQL SQL SQL SQL exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsoraclezbdb1:~/product/10.2.0/db_1/bin rman target /Recovery Manager: Release 10.2.0.4.0 - Production on Tue Feb 18 16:17:54 2014Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: QT0000J2 (DBID3109660417)RMAN RMAN RMAN RMAN RMAN copy datafile /home/oracle/user01.dbf to RACDG;Starting backup at 18-FEB-14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid1060 instanceqt0000j21 devtypeDISKchannel ORA_DISK_1: starting datafile copyinput datafile fno00008 name/home/oracle/user01.dbfoutput filenameRACDG/qt0000j2/datafile/users.270.839866683 tagTAG20140218T161802 recid1 stamp839866682channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01Finished backup at 18-FEB-14RMAN exitRecovery Manager complete.oraclezbdb1:~/product/10.2.0/db_1/bin sqlplus / as sysdba;SQL*Plus: Release 10.2.0.4.0 - Production on Tue Feb 18 16:19:02 2014Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL SQL SQL alter database rename file /home/oracle/user01.dbf to RACDG/qt0000j2/datafile/users.270.839866683; Database altered.SQL SQL SQL SQL select name from v$datafiles;select name from v$datafiles *ERROR at line 1:ORA-00942: table or view does not existSQL select name from v$datafile;NAME--------------------------------------------------------------------------------RACDG/qt0000j2/datafile/system.259.730655367RACDG/qt0000j2/datafile/undotbs1.260.730655371RACDG/qt0000j2/datafile/sysaux.261.730655371RACDG/qt0000j2/datafile/undotbs2.263.730655377RACDG/qt0000j2/datafile/users.264.730655377RACDG/qt0000j2/datafile/ciimss_ts.268.733087301RACDG/qt0000j2/datafile/ciimss_idx_ts.269.733087365RACDG/qt0000j2/datafile/users.270.8398666838 rows selected.SQL select file_name,file_id,ONLINE_STATUS from dba_data_files;RACDG/qt0000j2/datafile/users.270.839866683 8 RECOVERSQL recover datafile 8;ORA-00279: change 225618407 generated at 02/18/2014 16:17:27 needed for thread1ORA-00289: suggestion :/home/oracle/product/10.2.0/db_1/dbs/arch1_2667_730655361.dbfORA-00280: change 225618407 for thread 1 is in sequence #2667Specify log: {RETsuggested | filename | AUTO | CANCEL}autoLog applied.Media recovery complete.SQL select file_name,file_id,ONLINE_STATUS from dba_data_files;RACDG/qt0000j2/datafile/users.270.839866683 8 OFFLINE SQL alter database datafile \RACDG/qt0000j2/datafile/users.270.839866683\ online;转载于:https://www.cnblogs.com/dfzzqq/p/6625349.html
