三根据数据文件所在运行模式及所归属的表空间的类型作相应的处理一数据库处于archivelog模式下1使用recoverdatabase或使用recoverdatafile命令进行数据库恢复alterdatabaseopenresetlogs命令打开数据库二数据库处于noarchivelog模式下1损坏的数据文件属于system表空间如无物理级备份则须重建数据库2损坏的数据文件属于temp表空间此时...
13 9 E:\ORACLE9I\ORADATA\GAXZTEMP.DB OFFLINE 0 14 10 E:\ORACLE9I\ORADATA\GAXZUSR.DB OFFLINE 0 15 11 E:\ORACLE9I\ORADATA\GAXZRBS.DB OFFLINE 0 TS# FILE# NAME STATUS CHECKPOINT_CHANGE# --- --- --- --- --- 16 12 E:\ORACLE9I\ORADATA\GAXZWEB.DB OFFLINE 0 已选择12行。 SQLP...
ORA-00376: file 12 cannot be read at this time ORA-01110: data file 12: '/u01/app/oracle/...
SQL> select file_name,file_id,tablespace_name,online_status from dba_data_files order by tablespace_name, file_id; Even when the temp file is offline, ORA-01110 is seen in alert log or trace file. Run the sql to check temp files and online or drop it. SQL>select file_name, tablespa...
expdp导出数据时报错ORA-01157和ORA-01110,由于导出的oracle数据库是临时通过备份恢复出来的,临时表空间的文件没有被恢复,所以报此错误。执行altertablespacetempaddtempfile'/path/temp.dbf'size200mautoextendon;在默认表空间temp增加文件后,expdp但是仍然报错临时空
drop原来的temp表空间文件: alter database tempfile '原来的temp表空间文件的绝对路径' drop; 然后重启数据库,报错解决。 方法二: 创建temp1新的表空间: create temporary tablespace temp1 tempfile 'temp1.dbf的绝对路径' size 100m AUTOEXTEND ON;
Oracle Database - Enterprise Edition - Version 12.2.0.1 and later: Database upgrade fails with Error: "ORA-01110: data file N: '<location/temp.dbf>', as tempfile is
创建的外部表为jeanron.temp_tabselect t1.cash,t1.TEST_TRANSACTION_ID ,t2.trade_no,t2.cash from TEST_NEW.TEST_detail t1,jeanron.temp_tab t2 where req_time >= to_date('2016-03-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and req_time < to_date('2016-04-01 00:00:00', 'yyyy...
SQL> select file_id,file_name,bytes/1024/1024 MB,status,tablespace_name from dba_temp_files ...
RMAN> catalog start with '/U01/app/oracle/temp'; using target database control file instead of recovery catalog searching for all files that match the pattern /U01/app/oracle/temp List of Files Unknown to the Database === File Name: /U01/app/oracle/temp/full_1804_908984436...