Este error en mi caso surguio cuando:
1)Se restauro una base de datos de cintas
2) Se abrio la base de datos utilizando el comando alter database open resetlogs.
3)Verificando los tablespace recuperandos se identifico que el datafile 292 se encontraba offline.
4)Poner datafile online
SQL> alter database datafile 292 online;
alter database datafile 292 online
*
ERROR at line 1:
ORA-01190: control file or data file 292 is from before the last RESETLOGS
ORA-01110: data file 292: '/REG_p/p012band/oradat01/DAT32_64M_INVM_P01_01.dbf'
En este punto se necestita recuperar el datafile. para esto la solución es:
1)Conectarse a RMAN : $ rman target /
2)recover datafile 292;
RMAN> recover datafile 292;
Starting recover at 21.10.2015
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 599017 is already on disk as file /REG_p/p012band/oralog/ARCH779852395_1_599017.arc/ARCH779852395_1_599034.arc
archive log thread 1 sequence 599035 is already on disk as file /REG_p/p012band/oralog/ARCH779852395_1_599035.arc
archive log thread 1 sequence 599036 is already on disk as file /REG_p/p012band/oralog/ARCH779852395_1_599036.arc
archive log thread 1 sequence 1 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_1.arc
archive log thread 1 sequence 2 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_2.arc
archive log thread 1 sequence 3 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_3.arc
archive log thread 1 sequence 4 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_4.arc
archive log thread 1 sequence 5 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_5.arc
archive log thread 1 sequence 6 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_6.arc
archive log thread 1 sequence 7 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_7.arc
archive log thread 1 sequence 8 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_8.arc
archive log thread 1 sequence 9 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_9.arc
archive log thread 1 sequence 10 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_10.arc
archive log thread 1 sequence 11 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_11.arc
archive log thread 1 sequence 12 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_12.arc
archive log thread 1 sequence 13 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_13.arc
archive log thread 1 sequence 14 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_14.arc
archive log thread 1 sequence 15 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_15.arc
archive log thread 1 sequence 16 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_16.arc
archive log thread 1 sequence 17 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_17.arc
archive log thread 1 sequence 18 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_18.arc
archive log thread 1 sequence 19 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_19.arc
archive log thread 1 sequence 20 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_20.arc
archive log thread 1 sequence 21 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_21.arc
archive log thread 1 sequence 22 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_22.arc
archive log thread 1 sequence 23 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_23.arc
archive log thread 1 sequence 24 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_24.arc
archive log thread 1 sequence 25 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_25.arc
archive log thread 1 sequence 26 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_26.arc
archive log thread 1 sequence 27 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_27.arc
archive log thread 1 sequence 28 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_28.arc
archive log thread 1 sequence 29 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_29.arc
archive log thread 1 sequence 30 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_30.arc
archive log thread 1 sequence 31 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_31.arc
archive log thread 1 sequence 32 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_32.arc
archive log thread 1 sequence 33 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_33.arc
archive log thread 1 sequence 34 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_34.arc
archive log thread 1 sequence 35 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_35.arc
archive log thread 1 sequence 36 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_36.arc
archive log thread 1 sequence 37 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_37.arc
archive log thread 1 sequence 38 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_38.arc
archive log thread 1 sequence 39 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_39.arc
archive log thread 1 sequence 40 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_40.arc
archive log thread 1 sequence 41 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_41.arc
archive log thread 1 sequence 42 is already on disk as file /REG_p/p012band/oralog/ARCH893682755_1_42.arc
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599017.arc thread=1 sequence=599017
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599018.arc thread=1 sequence=599018
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599019.arc thread=1 sequence=599019
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599020.arc thread=1 sequence=599020
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599021.arc thread=1 sequence=599021
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599022.arc thread=1 sequence=599022
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599023.arc thread=1 sequence=599023
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599024.arc thread=1 sequence=599024
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599025.arc thread=1 sequence=599025
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599026.arc thread=1 sequence=599026
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599027.arc thread=1 sequence=599027
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599028.arc thread=1 sequence=599028
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599029.arc thread=1 sequence=599029
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599030.arc thread=1 sequence=599030
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599031.arc thread=1 sequence=599031
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599032.arc thread=1 sequence=599032
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599033.arc thread=1 sequence=599033
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599034.arc thread=1 sequence=599034
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599035.arc thread=1 sequence=599035
archive log filename=/REG_p/p012band/oralog/ARCH779852395_1_599036.arc thread=1 sequence=599036
media recovery complete, elapsed time: 00:39:54
Finished recover at 21.10.2015
3)Finalizado el recover procedemos a poner el datafile como online
SQL>alter database datafile 292 online;
Database altered.
4) Verificar si se encuntra en online el datafile
SQL>select status, file# from v$datafile where file# = 292;
STATUS FILE#
------- ----------
ONLINE 292
5) Ponemos el tablespace atado al datafile en online
SQL>alter tablespace DAT_TEST_1 online;
Tablespace altered.
6)Ejecutar procesos sobre el tablespace
[oracle@TEST]:/oracle/test/test_1>exp TABLES=TEST_1 log=/tmp/test.log file=/tmp/test.dmp
Export: Release 10.2.0.5.0 - Production on Wed Oct 21 16:12:54 2015
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
About to export specified tables via Conventional Path ...
. . exporting table TEST
Espero les ayude.
