1、默认归档已打开SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination+DATA/archOldestonlinelogsequence20Nextlogsequencetoarchive22Currentlogsequence22SQL>SQL>2、offline表空间SQL>altertablespaceFINANCEoffline;Tablespacealtered.3、cp数据文件ASMCMD[+data/FSCZRAC/datafile]>cp/u01/a...
copying /u01/app/oracle/product/11.2.0/dbhome_1/dbs/DATAfsczracdatafilefinance.DBF -> +data/fsczrac/datafile/DATAfsczracdatafilefinance.DBF ASMCMD [+data/FSCZRAC/datafile] > 4、修改控制文件中的数据文件路径 SQL> alter database rename file'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/DA...
ORA-01110: data file 226: '+DG_DATA02/racdb/blsp_temp.dbf'SQL> 这时候，再去删除报错的数据...
当查询数据库数据时,提示临时表空间异常,报错ORA-01157 ORA-01110,经过对数据文件处理后,已经解决此故障。 环境:Oracle 11g RAC For Linux 6,该库为DataGuard备库 1. 特定用户查询数据时报错,如下: ERROR: ORA-01157: cannot identify/lock data file 226 - see DBWR trace file ORA-01110: data file 226:...
11g rac rhel 6.8 二、报错信息 SQL> select file_name from dba_data_files; ERROR: ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01110: data file 6: ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/DATAfsczracdatafilefinance.DBF’ ...
SQL> CREATE TEMPORARY TABLESPACE PCS_TEMP TEMPFILE 'BBBBBBBB' SIZE 20G AUTOEXTEND OFF; Tablespace created 搞定。这里要注意一下,因为我的是RAC环境,所以在置表空间为offline的时候需要两个数据库都shutdown,然后启动一台或者两台到mount状态下操作。
ORA-01157和ORA-01110 今天一同事在现场扩表空间,环境是:solaris 10 cluster 3.2 + oracle 10g RAC扩完后,执行sqlplus /as sysdba然后查询表空间: SQL>select file_name from dba_data_files; 出现了下面的错误提示: ORA-01157: cannot identify/lock data file 10 - see DBWR trace file...
oracle rac环境将datafile创建到本地文件系统,会造成间歇性访问异常。 若数据文件在节点1,而客户端访问连接的节点1,那么可以正常操作;而若数据文件在节点1,而客户端访问连接的节点2,那么此时就会报错: 代码语言:javascript 复制 ORA-01157: cannot identify/lock data file 8 - see DBWR trace file ORA-01110: da...
ORA-01157: cannot identify/lock data file xxx - see DBWR trace file ORA-01110: data file 201: xxx/temp01.dbf 部分trace文件: DDE: Problem Key ORA 1110 was flood controlled (0x5) (no incident) ORA-01110: data file 201: xxx/temp01.dbf ...